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.IBE_MINISITERUNTIME_PVT dependencies on JTF_NUMBER_TABLE

Line 443: p_msite_ids IN JTF_NUMBER_TABLE,

439: --+
440: PROCEDURE Load_Msite_List_Details
441: (
442: p_api_version IN NUMBER,
443: p_msite_ids IN JTF_NUMBER_TABLE,
444: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
445: x_master_msite_id OUT NOCOPY NUMBER,
446: x_minisite_cur OUT NOCOPY minisite_cur_type,
447: x_name_cur OUT NOCOPY name_cur_type,

Line 444: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

440: PROCEDURE Load_Msite_List_Details
441: (
442: p_api_version IN NUMBER,
443: p_msite_ids IN JTF_NUMBER_TABLE,
444: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
445: x_master_msite_id OUT NOCOPY NUMBER,
446: x_minisite_cur OUT NOCOPY minisite_cur_type,
447: x_name_cur OUT NOCOPY name_cur_type,
448: x_lang_cur OUT NOCOPY lang_cur_type,

Line 452: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

448: x_lang_cur OUT NOCOPY lang_cur_type,
449: x_currency_cur OUT NOCOPY currency_cur_type,
450: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
451: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
452: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
453: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
455: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
456: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,

Line 453: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,

449: x_currency_cur OUT NOCOPY currency_cur_type,
450: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
451: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
452: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
453: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
455: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
456: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
457: x_return_status OUT NOCOPY VARCHAR2,

Line 454: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

450: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
451: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
452: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
453: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
455: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
456: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
457: x_return_status OUT NOCOPY VARCHAR2,
458: x_msg_count OUT NOCOPY NUMBER,

Line 455: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

451: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
452: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
453: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
454: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
455: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
456: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
457: x_return_status OUT NOCOPY VARCHAR2,
458: x_msg_count OUT NOCOPY NUMBER,
459: x_msg_data OUT NOCOPY VARCHAR2

Line 673: x_msite_ids := JTF_NUMBER_TABLE();

669:
670: --+
671: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
672: --+
673: x_msite_ids := JTF_NUMBER_TABLE();
674: IF (p_msite_ids IS NULL) THEN
675: l_index := 1;
676: FOR r3 IN c3 LOOP
677: x_msite_ids.EXTEND();

Line 753: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

749: start_date_active, end_date_active -- added by YAXU on 08/06/02
750: FROM ibe_msites_b MM
751: WHERE MM.msite_id IN
752: (SELECT t.COLUMN_VALUE
753: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
754: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)
755: ORDER BY msite_id ;
756:
757: -- Mini-site name and description for all languages

Line 761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

757: -- Mini-site name and description for all languages
758: OPEN x_name_cur FOR SELECT /*+ ORDERED USE_NL (V MM TL L) INDEX (MM,IBE_MSITES_B_U1) */
759: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
760: FROM(select distinct to_number(t.column_value) as msite_id
761: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
762: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
763: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
764: WHERE L.language_code = TL.language
765: AND L.msite_id = MM.msite_id

Line 778: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

774: INDEX (MM,IBE_MSITES_B_U1) */
775: MM.msite_id, L.language_code
776: FROM
777: (select distinct to_number(t.column_value) as msite_id
778: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
779: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
780: ibe_msites_b MM,
781: ibe_msite_languages L
782: WHERE MM.msite_id = L.msite_id

Line 795: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

791: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
792: C.orderable_limit,
793: C.payment_threshold,C.partner_prc_listid
794: FROM (select distinct to_number(t.column_value) as msite_id
795: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
796: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
797: ibe_msites_b MM, ibe_msite_currencies C
798: WHERE MM.msite_id = C.msite_id
799: AND MM.msite_id = v.msite_id

Line 808: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

804: OPEN x_msite_resps_cur FOR SELECT /*+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)*/
805: MM.msite_id, MRB.msite_resp_id, MRB.responsibility_id, MRB.application_id, MRTL.language,
806: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
807: FROM (select distinct to_number(t.column_value) as msite_id
808: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
809: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
810: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
811: WHERE MM.msite_id = MRB.msite_id
812: AND MRB.msite_resp_id = MRTL.msite_resp_id

Line 821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

817: -- Mini-site and party association (from ibe_msite_prty_accss table)
818: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
819: MM.msite_id, party_id
820: FROM (select distinct to_number(t.column_value) as msite_id
821: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
822: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
823: ibe_msites_b MM, ibe_msite_prty_accss MP
824: WHERE MM.msite_id = MP.msite_id
825: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)

Line 835: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

831: -- (from ibe_msite_information table)
832: OPEN x_pm_cc_sm_cur FOR SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
833: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
834: FROM(select distinct to_number(t.column_value) as msite_id
835: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
836: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
837: ibe_msites_b MM, ibe_msite_information MI
838: WHERE MM.msite_id = MI.msite_id
839: AND MM.msite_id = v.msite_id

Line 846: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

842: UNION
843: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
844: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
845: FROM(select distinct to_number(t.column_value) as msite_id
846: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
847: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
848: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV
849: WHERE MM.msite_id = MI.msite_id
850: AND MM.msite_id = v.msite_id

Line 861: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t

857: UNION --ssekar bug 5064210 query split to handle multiple sources of payment/credit card info.
858: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
859: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
860: FROM(select distinct to_number(t.column_value) as msite_id
861: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
862: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
863: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
864: WHERE MM.msite_id = MI.msite_id
865: AND MM.msite_id = v.msite_id

Line 883: x_section_msite_ids := JTF_NUMBER_TABLE();

879: l_exclude_flag := 'N';
880: END IF;
881:
882: -- Initialize the variables
883: x_section_msite_ids := JTF_NUMBER_TABLE();
884: x_section_ids := JTF_NUMBER_TABLE();
885: x_item_msite_ids := JTF_NUMBER_TABLE();
886: x_item_ids := JTF_NUMBER_TABLE();
887:

Line 884: x_section_ids := JTF_NUMBER_TABLE();

880: END IF;
881:
882: -- Initialize the variables
883: x_section_msite_ids := JTF_NUMBER_TABLE();
884: x_section_ids := JTF_NUMBER_TABLE();
885: x_item_msite_ids := JTF_NUMBER_TABLE();
886: x_item_ids := JTF_NUMBER_TABLE();
887:
888: IF (l_exclude_flag = 'Y') THEN

Line 885: x_item_msite_ids := JTF_NUMBER_TABLE();

881:
882: -- Initialize the variables
883: x_section_msite_ids := JTF_NUMBER_TABLE();
884: x_section_ids := JTF_NUMBER_TABLE();
885: x_item_msite_ids := JTF_NUMBER_TABLE();
886: x_item_ids := JTF_NUMBER_TABLE();
887:
888: IF (l_exclude_flag = 'Y') THEN
889:

Line 886: x_item_ids := JTF_NUMBER_TABLE();

882: -- Initialize the variables
883: x_section_msite_ids := JTF_NUMBER_TABLE();
884: x_section_ids := JTF_NUMBER_TABLE();
885: x_item_msite_ids := JTF_NUMBER_TABLE();
886: x_item_ids := JTF_NUMBER_TABLE();
887:
888: IF (l_exclude_flag = 'Y') THEN
889:
890: -- For sections