Human Capital Management - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center