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 59: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

55: (
56: p_api_version IN NUMBER,
57: p_msite_id IN NUMBER,
58: p_access_name IN VARCHAR2,
59: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
60: x_return_status OUT NOCOPY VARCHAR2,
61: x_msg_count OUT NOCOPY NUMBER,
62: x_msg_data OUT NOCOPY VARCHAR2
63: )

Line 160: x_item_ids := JTF_NUMBER_TABLE();

156: x_root_section_id => l_master_root_section_id
157: );
158:
159: l_index := 1;
160: x_item_ids := JTF_NUMBER_TABLE();
161: OPEN C_msite_valid(l_msite_id);
162: FETCH C_msite_valid INTO l_root_section_id;
163: CLOSE C_msite_valid;
164: FOR r2 IN c2(l_master_msite_id, l_msite_id,l_root_section_id) LOOP

Line 211: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,

207: (
208: p_api_version IN NUMBER,
209: p_msite_id IN NUMBER,
210: p_access_name IN VARCHAR2,
211: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2
215: )

Line 270: x_section_ids := JTF_NUMBER_TABLE();

266: x_mini_site_id => l_master_msite_id,
267: x_root_section_id => l_master_root_section_id
268: );
269:
270: x_section_ids := JTF_NUMBER_TABLE();
271: l_index := 1;
272: FOR r1 IN c1(l_master_msite_id, l_msite_id) LOOP
273: x_section_ids.EXTEND();
274: x_section_ids(l_index) := r1.child_section_id;

Line 708: p_msite_ids IN JTF_NUMBER_TABLE,

704: --+
705: PROCEDURE Load_Msite_List_Details
706: (
707: p_api_version IN NUMBER,
708: p_msite_ids IN JTF_NUMBER_TABLE,
709: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
710: x_master_msite_id OUT NOCOPY NUMBER,
711: x_minisite_cur OUT NOCOPY minisite_cur_type,
712: x_name_cur OUT NOCOPY name_cur_type,

Line 709: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

705: PROCEDURE Load_Msite_List_Details
706: (
707: p_api_version IN NUMBER,
708: p_msite_ids IN JTF_NUMBER_TABLE,
709: x_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
710: x_master_msite_id OUT NOCOPY NUMBER,
711: x_minisite_cur OUT NOCOPY minisite_cur_type,
712: x_name_cur OUT NOCOPY name_cur_type,
713: x_lang_cur OUT NOCOPY lang_cur_type,

Line 717: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

713: x_lang_cur OUT NOCOPY lang_cur_type,
714: x_currency_cur OUT NOCOPY currency_cur_type,
715: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
716: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
717: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
718: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
719: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
720: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
721: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,

Line 718: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,

714: x_currency_cur OUT NOCOPY currency_cur_type,
715: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
716: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
717: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
718: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
719: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
720: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
721: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
722: x_return_status OUT NOCOPY VARCHAR2,

Line 719: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,

715: x_msite_resps_cur OUT NOCOPY msite_resp_cur_type,
716: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
717: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
718: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
719: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
720: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
721: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,

Line 720: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,

716: x_party_access_cur OUT NOCOPY msite_prty_access_cur_type,
717: x_section_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
718: x_section_ids OUT NOCOPY JTF_NUMBER_TABLE,
719: x_item_msite_ids OUT NOCOPY JTF_NUMBER_TABLE,
720: x_item_ids OUT NOCOPY JTF_NUMBER_TABLE,
721: x_pm_cc_sm_cur OUT NOCOPY pm_cc_sm_cur_type,
722: x_return_status OUT NOCOPY VARCHAR2,
723: x_msg_count OUT NOCOPY NUMBER,
724: x_msg_data OUT NOCOPY VARCHAR2

Line 938: x_msite_ids := JTF_NUMBER_TABLE();

934:
935: --+
936: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
937: --+
938: x_msite_ids := JTF_NUMBER_TABLE();
939: IF (p_msite_ids IS NULL) THEN
940: l_index := 1;
941: FOR r3 IN c3 LOOP
942: x_msite_ids.EXTEND();

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

1014: start_date_active, end_date_active -- added by YAXU on 08/06/02
1015: FROM ibe_msites_b MM
1016: WHERE MM.msite_id IN
1017: (SELECT t.COLUMN_VALUE
1018: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1019: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125)
1020: ORDER BY msite_id ;
1021:
1022: -- Mini-site name and description for all languages

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

1022: -- Mini-site name and description for all languages
1023: OPEN x_name_cur FOR SELECT /*+ ORDERED USE_NL (V MM TL L) INDEX (MM,IBE_MSITES_B_U1) */
1024: MM.msite_id, L.language_code, TL.msite_name,TL.msite_description
1025: FROM(select distinct to_number(t.column_value) as msite_id
1026: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1027: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1028: ibe_msites_b MM, ibe_msites_tl TL, ibe_msite_languages L
1029: WHERE L.language_code = TL.language
1030: AND L.msite_id = MM.msite_id

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

1039: INDEX (MM,IBE_MSITES_B_U1) */
1040: MM.msite_id, L.language_code
1041: FROM
1042: (select distinct to_number(t.column_value) as msite_id
1043: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1044: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1045: ibe_msites_b MM,
1046: ibe_msite_languages L
1047: WHERE MM.msite_id = L.msite_id

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

1056: C.bizpartner_prc_listid,C.registered_prc_listid, C.walkin_prc_listid,
1057: C.orderable_limit,
1058: C.payment_threshold,C.partner_prc_listid
1059: FROM (select distinct to_number(t.column_value) as msite_id
1060: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1061: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1062: ibe_msites_b MM, ibe_msite_currencies C
1063: WHERE MM.msite_id = C.msite_id
1064: AND MM.msite_id = v.msite_id

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

1069: OPEN x_msite_resps_cur FOR SELECT /*+ ORDERED USE_NL (V MM MRB MRTL) INDEX (MM,IBE_MSITES_B_U1)*/
1070: MM.msite_id, MRB.msite_resp_id, MRB.responsibility_id, MRB.application_id, MRTL.language,
1071: MRTL.display_name, MRB.start_date_active, MRB.end_date_active
1072: FROM (select distinct to_number(t.column_value) as msite_id
1073: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1074: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1075: ibe_msites_b MM, ibe_msite_resps_b MRB, ibe_msite_resps_tl MRTL
1076: WHERE MM.msite_id = MRB.msite_id
1077: AND MRB.msite_resp_id = MRTL.msite_resp_id

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

1082: -- Mini-site and party association (from ibe_msite_prty_accss table)
1083: OPEN x_party_access_cur FOR SELECT /*+ ORDERED USE_NL (V MM MP) INDEX (MM,IBE_MSITES_B_U1) */
1084: MM.msite_id, party_id
1085: FROM (select distinct to_number(t.column_value) as msite_id
1086: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1087: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1088: ibe_msites_b MM, ibe_msite_prty_accss MP
1089: WHERE MM.msite_id = MP.msite_id
1090: AND sysdate BETWEEN MP.start_date_Active AND NVL(MP.end_date_active,sysdate)

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

1096: -- (from ibe_msite_information table)
1097: OPEN x_pm_cc_sm_cur FOR SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
1098: MM.msite_id, MI.msite_information_context, MI.msite_information1,MI.msite_information2
1099: FROM(select distinct to_number(t.column_value) as msite_id
1100: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1101: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1102: ibe_msites_b MM, ibe_msite_information MI
1103: WHERE MM.msite_id = MI.msite_id
1104: AND MM.msite_id = v.msite_id

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

1107: UNION
1108: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
1109: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
1110: FROM(select distinct to_number(t.column_value) as msite_id
1111: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1112: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1113: ibe_msites_b MM, ibe_msite_information MI, fnd_lookup_values FLV
1114: WHERE MM.msite_id = MI.msite_id
1115: AND MM.msite_id = v.msite_id

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

1122: UNION --ssekar bug 5064210 query split to handle multiple sources of payment/credit card info.
1123: SELECT /*+ ORDERED USE_NL(V MM MI) INDEX(MM,IBE_MSITES_B_U1) */
1124: MM.msite_id, MI.msite_information_context,MI.msite_information1,MI.msite_information2
1125: FROM(select distinct to_number(t.column_value) as msite_id
1126: FROM TABLE(CAST(x_msite_ids AS JTF_NUMBER_TABLE)) t
1127: WHERE t.COLUMN_VALUE > 0 AND t.COLUMN_VALUE < 9.99E125) v,
1128: ibe_msites_b MM, ibe_msite_information MI, iby_creditcard_issuers_b cci
1129: WHERE MM.msite_id = MI.msite_id
1130: AND MM.msite_id = v.msite_id

Line 1156: x_section_msite_ids := JTF_NUMBER_TABLE();

1152: IBE_Util.Debug('Get_Msite_Details - l_exclude_flag = ' || l_exclude_flag);
1153: END IF;
1154:
1155: -- Initialize the variables
1156: x_section_msite_ids := JTF_NUMBER_TABLE();
1157: x_section_ids := JTF_NUMBER_TABLE();
1158: x_item_msite_ids := JTF_NUMBER_TABLE();
1159: x_item_ids := JTF_NUMBER_TABLE();
1160:

Line 1157: x_section_ids := JTF_NUMBER_TABLE();

1153: END IF;
1154:
1155: -- Initialize the variables
1156: x_section_msite_ids := JTF_NUMBER_TABLE();
1157: x_section_ids := JTF_NUMBER_TABLE();
1158: x_item_msite_ids := JTF_NUMBER_TABLE();
1159: x_item_ids := JTF_NUMBER_TABLE();
1160:
1161: IF (l_exclude_flag = 'Y') THEN

Line 1158: x_item_msite_ids := JTF_NUMBER_TABLE();

1154:
1155: -- Initialize the variables
1156: x_section_msite_ids := JTF_NUMBER_TABLE();
1157: x_section_ids := JTF_NUMBER_TABLE();
1158: x_item_msite_ids := JTF_NUMBER_TABLE();
1159: x_item_ids := JTF_NUMBER_TABLE();
1160:
1161: IF (l_exclude_flag = 'Y') THEN
1162:

Line 1159: x_item_ids := JTF_NUMBER_TABLE();

1155: -- Initialize the variables
1156: x_section_msite_ids := JTF_NUMBER_TABLE();
1157: x_section_ids := JTF_NUMBER_TABLE();
1158: x_item_msite_ids := JTF_NUMBER_TABLE();
1159: x_item_ids := JTF_NUMBER_TABLE();
1160:
1161: IF (l_exclude_flag = 'Y') THEN
1162:
1163: -- For sections