DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on CS_INCIDENT_LINKS

Line 915: --CS_INCIDENT_LINKS

911:
912: BEGIN
913:
914: CSM_UTIL_PKG.LOG('Recording Incident Links','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
915: --CS_INCIDENT_LINKS
916:
917: l_pk_name_list(1):= 'LINK_ID';
918: l_pk_type_list(1):= 'NUMBER';
919:

Line 921: FROM CS_INCIDENT_LINKS

917: l_pk_name_list(1):= 'LINK_ID';
918: l_pk_type_list(1):= 'NUMBER';
919:
920: FOR rec IN (SELECT LINK_ID
921: FROM CS_INCIDENT_LINKS
922: WHERE CREATION_DATE >= G_HA_START_TIME)
923: LOOP
924: l_pk_value_list(1):=rec.LINK_ID;
925: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

Line 925: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

921: FROM CS_INCIDENT_LINKS
922: WHERE CREATION_DATE >= G_HA_START_TIME)
923: LOOP
924: l_pk_value_list(1):=rec.LINK_ID;
925: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
926: END LOOP;
927:
928: FOR rec IN (SELECT LINK_ID
929: FROM CS_INCIDENT_LINKS

Line 929: FROM CS_INCIDENT_LINKS

925: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
926: END LOOP;
927:
928: FOR rec IN (SELECT LINK_ID
929: FROM CS_INCIDENT_LINKS
930: WHERE CREATION_DATE < G_HA_START_TIME
931: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
932: LOOP
933: l_pk_value_list(1):=rec.LINK_ID;

Line 934: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');

930: WHERE CREATION_DATE < G_HA_START_TIME
931: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
932: LOOP
933: l_pk_value_list(1):=rec.LINK_ID;
934: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
935: END LOOP;
936:
937: CSM_UTIL_PKG.LOG('Recording Related Objects','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
938: --CS_INCIDENT_LINKS_EXT

Line 938: --CS_INCIDENT_LINKS_EXT

934: TRACK_HA_RECORD('CS_INCIDENT_LINKS',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
935: END LOOP;
936:
937: CSM_UTIL_PKG.LOG('Recording Related Objects','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);
938: --CS_INCIDENT_LINKS_EXT
939:
940: l_pk_name_list(1):= 'LINK_ID';
941: l_pk_type_list(1):= 'NUMBER';
942:

Line 944: FROM CS_INCIDENT_LINKS_EXT

940: l_pk_name_list(1):= 'LINK_ID';
941: l_pk_type_list(1):= 'NUMBER';
942:
943: FOR rec IN (SELECT LINK_ID
944: FROM CS_INCIDENT_LINKS_EXT
945: WHERE CREATION_DATE >= G_HA_START_TIME)
946: LOOP
947: l_pk_value_list(1):=rec.LINK_ID;
948: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

Line 948: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');

944: FROM CS_INCIDENT_LINKS_EXT
945: WHERE CREATION_DATE >= G_HA_START_TIME)
946: LOOP
947: l_pk_value_list(1):=rec.LINK_ID;
948: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
949: END LOOP;
950:
951: FOR rec IN (SELECT LINK_ID
952: FROM CS_INCIDENT_LINKS

Line 952: FROM CS_INCIDENT_LINKS

948: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'I','N');
949: END LOOP;
950:
951: FOR rec IN (SELECT LINK_ID
952: FROM CS_INCIDENT_LINKS
953: WHERE CREATION_DATE < G_HA_START_TIME
954: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
955: LOOP
956: l_pk_value_list(1):=rec.LINK_ID;

Line 957: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');

953: WHERE CREATION_DATE < G_HA_START_TIME
954: AND LAST_UPDATE_DATE >= G_HA_START_TIME)
955: LOOP
956: l_pk_value_list(1):=rec.LINK_ID;
957: TRACK_HA_RECORD('CS_INCIDENT_LINKS_EXT',l_pk_name_list,l_pk_type_list,l_pk_value_list,'U','N');
958: END LOOP;
959:
960:
961: CSM_UTIL_PKG.LOG('Recording CUG INCIDENT ATTRIBUTES Data','CSM_HA_EVENT_PKG.RECORD_MISC_DATA', FND_LOG.LEVEL_PROCEDURE);