Add or Update status validation in Special Information Types (SIT) through Self Service
Hi,
I have created a SIT with 3 segments and am doing the validation at the FND_FLEX_PLSQL.validate package as below.
Segment 1 = calendar year
Segment2 = Training Course 1
Segment3 = Training Course 2
a) There should be only one TRAINING request during the calendar year (user_segment1). If there is more than one request, system should through an error.
b) In case of "Update" in SIT, system should allow to modify.
How can we distinguish SIT request is for ADD or UPDATE in the code below.
Below code throws an error for both ADD and UPDATE SIT.
/********************************************/
IF id_flex_num = 2090
THEN