APPS.IEC_SUBSET_PVT dependencies on IEC_G_SUBSET_RT_INFO

Line 837: -- Create an entry in the IEC_G_SUBSET_RT_INFO table to support

833: ----------------------------------------------------------------
834: L_QUOTA_RESET := L_QUOTA_RESET / G_NUM_MINUTES_IN_DAY;
835:
836: ----------------------------------------------------------------
837: -- Create an entry in the IEC_G_SUBSET_RT_INFO table to support
838: -- the new subset.
839: ----------------------------------------------------------------
840: BEGIN
841:

Line 842: INSERT INTO IEC_G_SUBSET_RT_INFO

838: -- the new subset.
839: ----------------------------------------------------------------
840: BEGIN
841:
842: INSERT INTO IEC_G_SUBSET_RT_INFO
843: ( SUBSET_RT_INFO_ID
844: , LIST_SUBSET_ID
845: , WORKING_QUANTUM
846: , WORKING_QUOTA

Line 861: ( IEC_G_SUBSET_RT_INFO_S.NEXTVAL

857: , LAST_UPDATED_BY
858: , LAST_UPDATE_DATE
859: )
860: VALUES
861: ( IEC_G_SUBSET_RT_INFO_S.NEXTVAL
862: , P_SUBSET_ID
863: , L_QUANTUM
864: , L_QUOTA
865: , SYSDATE + L_QUOTA_RESET

Line 882: ' UPDATE IEC_G_SUBSET_RT_INFO

878:
879: EXCEPTION
880: WHEN DUP_VAL_ON_INDEX THEN
881: EXECUTE IMMEDIATE
882: ' UPDATE IEC_G_SUBSET_RT_INFO
883: SET STATUS_CODE = :1
884: , LOAD_PRIORITY = :2
885: , LAST_UPDATE_DATE = SYSDATE
886: WHERE LIST_SUBSET_ID = :3'

Line 891: END; -- end of block for inserting entry into IEC_G_SUBSET_RT_INFO table.

887: USING L_STATUS_CODE, L_LOAD_PRIORITY, P_SUBSET_ID;
888:
889: WHEN OTHERS THEN
890: RAISE;
891: END; -- end of block for inserting entry into IEC_G_SUBSET_RT_INFO table.
892:
893: EXCEPTION
894: WHEN OTHERS THEN
895: ROLLBACK TO CREATE_SUBSET_RT_INFO_SAVE;