APPS.IEC_COMMON_UTIL_PVT dependencies on IEC_G_LIST_LOCK_STATES

Line 839: FROM IEC_G_LIST_LOCK_STATES

835: INTO l_server_id
836:
837: , l_lock_flag
838:
839: FROM IEC_G_LIST_LOCK_STATES
840:
841: WHERE CAMPAIGN_SCHEDULE_ID = P_SCHED_ID
842:
843: FOR UPDATE;

Line 913: INSERT INTO IEC_G_LIST_LOCK_STATES

909: WHEN NO_DATA_FOUND
910:
911: THEN
912:
913: INSERT INTO IEC_G_LIST_LOCK_STATES
914:
915: ( cpn_lock_state_id
916:
917: , campaign_schedule_id

Line 927: ( iec_g_list_lock_states_s.nextval

923: , object_version_number )
924:
925: VALUES
926:
927: ( iec_g_list_lock_states_s.nextval
928:
929: , p_sched_id
930:
931: , p_server_id

Line 1069: UPDATE IEC_G_LIST_LOCK_STATES

1065: -- Attempt to update the lock entry if it isn't currently locked.
1066:
1067: ----------------------------------------------------------------
1068:
1069: UPDATE IEC_G_LIST_LOCK_STATES
1070:
1071: SET LOCK_FLAG = 'Y'
1072:
1073: , SERVER_ID = P_SERVER_ID

Line 1107: UPDATE IEC_G_LIST_LOCK_STATES

1103: -- Attempt to update the lock entry if it isn't currently locked.
1104:
1105: ----------------------------------------------------------------
1106:
1107: UPDATE IEC_G_LIST_LOCK_STATES
1108:
1109: SET LOCK_FLAG = 'Y'
1110:
1111: , SERVER_ID = P_SERVER_ID

Line 1247: UPDATE IEC_G_LIST_LOCK_STATES

1243: -- Attempt to update the lock entry.
1244:
1245: ----------------------------------------------------------------
1246:
1247: UPDATE IEC_G_LIST_LOCK_STATES
1248:
1249: SET LOCK_FLAG = 'N'
1250:
1251: , SERVER_ID = P_SERVER_ID