APPS.JAI_RCV_RRSL_TRIGGER_PKG dependencies on JAI_RCV_SUBLED_ENTRIES

Line 58: INSERT INTO JAI_RCV_SUBLED_ENTRIES(SUBLED_ENTRY_ID,LAST_UPDATE_DATE,

54: -----------------------------------------------------------------------------------------------------------------------------------------------------------------------*/
55:
56:
57: IF pv_action = jai_constants.INSERTING THEN --1
58: INSERT INTO JAI_RCV_SUBLED_ENTRIES(SUBLED_ENTRY_ID,LAST_UPDATE_DATE,
59: LAST_UPDATED_BY,
60: CREATION_DATE,
61: CREATED_BY,
62: LAST_UPDATE_LOGIN,

Line 127: VALUES( JAI_RCV_SUBLED_ENTRIES_S.nextval,

123: REFERENCE10,
124: SOURCE_DOC_QUANTITY,
125: FROM_TYPE
126: )
127: VALUES( JAI_RCV_SUBLED_ENTRIES_S.nextval,
128: pr_new.LAST_UPDATE_DATE,
129: pr_new.LAST_UPDATED_BY,
130: pr_new.CREATION_DATE,
131: pr_new.CREATED_BY,

Line 199: UPDATE JAI_RCV_SUBLED_ENTRIES

195: 'A'
196: );
197: ELSIF pv_action = jai_constants.UPDATING THEN
198:
199: UPDATE JAI_RCV_SUBLED_ENTRIES
200: SET LAST_UPDATE_DATE = pr_new.LAST_UPDATE_DATE,
201: LAST_UPDATED_BY = pr_new.LAST_UPDATED_BY,
202: CREATION_DATE = pr_new.CREATION_DATE,
203: CREATED_BY = pr_new.CREATED_BY,