eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_TCOP_ENGINE_PKG dependencies on AMS_TCOP_CONTACTS

Line 369: FROM ams_tcop_contacts contact

365: CURSOR C_GET_PARTY_CONTACTS(p_party_id NUMBER,
366: p_no_of_days NUMBER)
367: IS
368: SELECT count(party_id)
369: FROM ams_tcop_contacts contact
370: WHERE party_id = p_party_id
371: AND contact_date between sysdate and (sysdate - p_no_of_days);
372:
373:

Line 381: FROM AMS_TCOP_CONTACTS

377: p_no_of_days NUMBER
378: )
379: IS
380: SELECT schedule_id
381: FROM AMS_TCOP_CONTACTS
382: WHERE party_id = p_party_id
383: AND contact_date between sysdate and (sysdate - p_no_of_days);
384:
385: l_party_id NUMBER;

Line 676: SELECT AMS_TCOP_CONTACTS_S.NEXTVAL

672:
673: -- Get the Sequence value
674: CURSOR C_GET_NEXT_CONTACT_SEQ
675: IS
676: SELECT AMS_TCOP_CONTACTS_S.NEXTVAL
677: FROM DUAL;
678:
679: -- Get the Sequence value
680: -- CURSOR C_GET_NEXT_FATIGUE_BY_SEQ

Line 1126: 'Ready to create entries in AMS_TCOP_CONTACTS'

1122: l_label := 'SET_TCOP_CONTACTS';
1123: write_debug_message(LOG_LEVEL_PROCEDURE,
1124: PROCEDURE_NAME,
1125: l_label,
1126: 'Ready to create entries in AMS_TCOP_CONTACTS'
1127: );
1128:
1129: END IF;
1130:

Line 1145: --Update the AMS_TCOP_CONTACTS table

1141: 'Total Number of contacts = '||
1142: to_char(l_contacted_party_count)
1143: );
1144:
1145: --Update the AMS_TCOP_CONTACTS table
1146: IF (l_contacted_party_count > 0) THEN
1147: -- Create an array of Sequence number
1148: FOR i in l_contacted_party_list.FIRST .. l_contacted_party_list.LAST
1149: LOOP

Line 1161: 'Before Calling BULK Insert into AMS_TCOP_CONTACTS'

1157:
1158: write_debug_message(LOG_LEVEL_EVENT,
1159: PROCEDURE_NAME,
1160: l_label,
1161: 'Before Calling BULK Insert into AMS_TCOP_CONTACTS'
1162: );
1163:
1164: -- Do a Bulk Insert into AMS_TCOP_CONTACTS Table
1165: FORALL i in l_contacted_party_list.FIRST .. l_contacted_party_list.LAST

Line 1164: -- Do a Bulk Insert into AMS_TCOP_CONTACTS Table

1160: l_label,
1161: 'Before Calling BULK Insert into AMS_TCOP_CONTACTS'
1162: );
1163:
1164: -- Do a Bulk Insert into AMS_TCOP_CONTACTS Table
1165: FORALL i in l_contacted_party_list.FIRST .. l_contacted_party_list.LAST
1166: INSERT INTO
1167: AMS_TCOP_CONTACTS
1168: (contact_id,

Line 1167: AMS_TCOP_CONTACTS

1163:
1164: -- Do a Bulk Insert into AMS_TCOP_CONTACTS Table
1165: FORALL i in l_contacted_party_list.FIRST .. l_contacted_party_list.LAST
1166: INSERT INTO
1167: AMS_TCOP_CONTACTS
1168: (contact_id,
1169: party_id,
1170: schedule_id,
1171: media_id,

Line 1195: 'After Calling BULK Insert into AMS_TCOP_CONTACTS'

1191:
1192: write_debug_message(LOG_LEVEL_EVENT,
1193: PROCEDURE_NAME,
1194: l_label,
1195: 'After Calling BULK Insert into AMS_TCOP_CONTACTS'
1196: );
1197:
1198: write_debug_message(LOG_LEVEL_EVENT,
1199: PROCEDURE_NAME,