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_SUMMARIZATION_PKG dependencies on JTF_NUMBER_TABLE

Line 609: PROCEDURE UPDATE_CONTACT_COUNT(p_party_id_list JTF_NUMBER_TABLE

605: --
606: -- Purpose
607: -- This procedure updates contact count for all the contacted parties
608: --
609: PROCEDURE UPDATE_CONTACT_COUNT(p_party_id_list JTF_NUMBER_TABLE
610: ,p_schedule_id NUMBER
611: ,p_activity_id NUMBER
612: ,p_global_rule_id NUMBER
613: ,p_channel_rule_id NUMBER

Line 619: CURSOR C_GET_EXISTING_PARTY (p_party_id_list JTF_NUMBER_TABLE)

615:
616: IS
617: -- Verify if new entries need to be created in AMS_TCOP_CONTACT_SUMMARY
618: -- and in AMS_TCOP_CONTACT_SUM_DTL
619: CURSOR C_GET_EXISTING_PARTY (p_party_id_list JTF_NUMBER_TABLE)
620: IS
621: SELECT summary.PARTY_ID,summary.contact_summary_id
622: FROM AMS_TCOP_CONTACT_SUMMARY summary,
623: (SELECT column_value party_id

Line 624: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))

620: IS
621: SELECT summary.PARTY_ID,summary.contact_summary_id
622: FROM AMS_TCOP_CONTACT_SUMMARY summary,
623: (SELECT column_value party_id
624: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))
625: ) party_list
626: WHERE summary.party_id=party_list.party_id;
627:
628: CURSOR C_GET_NEW_PARTY (p_original_party_id_list JTF_NUMBER_TABLE

Line 628: CURSOR C_GET_NEW_PARTY (p_original_party_id_list JTF_NUMBER_TABLE

624: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))
625: ) party_list
626: WHERE summary.party_id=party_list.party_id;
627:
628: CURSOR C_GET_NEW_PARTY (p_original_party_id_list JTF_NUMBER_TABLE
629: ,p_existing_party_id_list JTF_NUMBER_TABLE
630: )
631: IS
632: SELECT orig_party_list.PARTY_ID

Line 629: ,p_existing_party_id_list JTF_NUMBER_TABLE

625: ) party_list
626: WHERE summary.party_id=party_list.party_id;
627:
628: CURSOR C_GET_NEW_PARTY (p_original_party_id_list JTF_NUMBER_TABLE
629: ,p_existing_party_id_list JTF_NUMBER_TABLE
630: )
631: IS
632: SELECT orig_party_list.PARTY_ID
633: FROM (SELECT column_value party_id

Line 634: FROM TABLE(CAST(p_original_party_id_list as JTF_NUMBER_TABLE))

630: )
631: IS
632: SELECT orig_party_list.PARTY_ID
633: FROM (SELECT column_value party_id
634: FROM TABLE(CAST(p_original_party_id_list as JTF_NUMBER_TABLE))
635: ) orig_party_list
636: WHERE orig_party_list.PARTY_ID NOT IN
637: (SELECT column_value
638: FROM TABLE(CAST(p_existing_party_id_list as JTF_NUMBER_TABLE))

Line 638: FROM TABLE(CAST(p_existing_party_id_list as JTF_NUMBER_TABLE))

634: FROM TABLE(CAST(p_original_party_id_list as JTF_NUMBER_TABLE))
635: ) orig_party_list
636: WHERE orig_party_list.PARTY_ID NOT IN
637: (SELECT column_value
638: FROM TABLE(CAST(p_existing_party_id_list as JTF_NUMBER_TABLE))
639: );
640:
641: CURSOR C_GET_SUM_DTL_SEQ
642: IS

Line 662: CURSOR C_GET_EXISTING_PARTY_CHNL (p_party_id_list JTF_NUMBER_TABLE

658: SELECT AMS_TCOP_CHNL_SUM_S.NEXTVAL
659: FROM DUAL;
660:
661: -- Get existing entries from AMS_TCOP_CHANNEL_SUMMARY
662: CURSOR C_GET_EXISTING_PARTY_CHNL (p_party_id_list JTF_NUMBER_TABLE
663: ,p_activity_id NUMBER
664: )
665: IS
666: SELECT summary.PARTY_ID,summary.channel_summary_id

Line 669: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))

665: IS
666: SELECT summary.PARTY_ID,summary.channel_summary_id
667: FROM AMS_TCOP_CHANNEL_SUMMARY summary,
668: (SELECT column_value party_id
669: FROM TABLE(CAST(p_party_id_List as JTF_NUMBER_TABLE))
670: ) party_list
671: WHERE summary.party_id=party_list.party_id
672: AND summary.media_id=p_activity_id;
673:

Line 677: l_existing_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

673:
674: -- Get the list of parties which already have a row in
675: -- AMS_TCOP_CONTACT_SUMMARY and in AMS_TCOP_CONTACT_SUM_DTL
676:
677: l_existing_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
678: l_new_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
679:
680: l_contact_summary_id_list NUMBER_ARRAY;
681: l_sum_detail_seq_id_list NUMBER_ARRAY;

Line 678: l_new_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();

674: -- Get the list of parties which already have a row in
675: -- AMS_TCOP_CONTACT_SUMMARY and in AMS_TCOP_CONTACT_SUM_DTL
676:
677: l_existing_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
678: l_new_party_id_list JTF_NUMBER_TABLE := JTF_NUMBER_TABLE();
679:
680: l_contact_summary_id_list NUMBER_ARRAY;
681: l_sum_detail_seq_id_list NUMBER_ARRAY;
682: l_contact_sum_seq_id_list NUMBER_ARRAY;