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

Line 98: p_prod_lst IN JTF_NUMBER_TABLE ,

94: p_application_id IN NUMBER ,
95: p_msite_id IN NUMBER ,
96: p_top_section_id IN NUMBER ,
97: p_incl_section IN VARCHAR2 := NULL ,
98: p_prod_lst IN JTF_NUMBER_TABLE ,
99: p_rel_type_code IN VARCHAR2 ,
100: p_org_id IN NUMBER ,
101: p_max_ret_num IN NUMBER := NULL ,
102: p_order_by_clause IN VARCHAR2 := NULL ,

Line 103: x_items_tbl OUT NOCOPY JTF_Number_Table ,

99: p_rel_type_code IN VARCHAR2 ,
100: p_org_id IN NUMBER ,
101: p_max_ret_num IN NUMBER := NULL ,
102: p_order_by_clause IN VARCHAR2 := NULL ,
103: x_items_tbl OUT NOCOPY JTF_Number_Table ,
104: x_return_status OUT NOCOPY VARCHAR2 ,
105: x_msg_count OUT NOCOPY NUMBER ,
106: x_msg_data OUT NOCOPY VARCHAR2
107: )

Line 148: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

144: AND MSIB.inventory_item_id = ICRI.related_item_id
145: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
146: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
147: AND MSIB.web_status = ''PUBLISHED''
148: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
149:
150: l_with_mtl_stmt1 VARCHAR2(4000) :=
151: ' SELECT DISTINCT ICRI.related_item_id
152: FROM ibe_ct_related_items ICRI,

Line 160: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

156: AND MSIB.inventory_item_id = ICRI.related_item_id
157: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
158: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
159: AND MSIB.web_status = ''PUBLISHED''
160: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
161:
162: l_with_mtl_stmt4 VARCHAR2(2000) :=
163: ' AND ICRI.related_item_id NOT IN (
164: SELECT ICRE.related_item_id

Line 167: AND ICRE.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

163: ' AND ICRI.related_item_id NOT IN (
164: SELECT ICRE.related_item_id
165: FROM ibe_ct_rel_exclusions ICRE
166: WHERE ICRE.relation_type_code = :rel_type_code1
167: AND ICRE.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
168:
169: l_without_mtl_bulk_stmt VARCHAR2(4000) :=
170: 'BEGIN
171: SELECT DISTINCT ICRI.related_item_id

Line 186: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

182: AND MSIB.inventory_item_id = ICRI.related_item_id
183: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
184: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
185: AND MSIB.web_status = ''PUBLISHED''
186: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
187:
188: l_stmt VARCHAR2(2000);
189: l_rel_items_csr prod_cursor;
190: l_rel_item_id NUMBER;

Line 227: x_items_tbl := JTF_Number_Table();

223:
224: END IF;
225:
226: -- Initialize the return value table
227: x_items_tbl := JTF_Number_Table();
228:
229: IF (AMS_DEBUG_HIGH_ON) THEN
230:
231:

Line 430: p_prod_lst IN JTF_NUMBER_TABLE ,

426: PROCEDURE getRelatedItems(
427: p_api_version_number IN NUMBER ,
428: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
429: p_application_id IN NUMBER ,
430: p_prod_lst IN JTF_NUMBER_TABLE ,
431: p_rel_type_code IN VARCHAR2 ,
432: p_org_id IN NUMBER ,
433: p_max_ret_num IN NUMBER := NULL ,
434: p_order_by_clause IN VARCHAR2 := NULL ,

Line 435: x_items_tbl OUT NOCOPY JTF_Number_Table ,

431: p_rel_type_code IN VARCHAR2 ,
432: p_org_id IN NUMBER ,
433: p_max_ret_num IN NUMBER := NULL ,
434: p_order_by_clause IN VARCHAR2 := NULL ,
435: x_items_tbl OUT NOCOPY JTF_Number_Table ,
436: x_return_status OUT NOCOPY VARCHAR2 ,
437: x_msg_count OUT NOCOPY NUMBER ,
438: x_msg_data OUT NOCOPY VARCHAR2
439: )

Line 459: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

455: AND MSIB.inventory_item_id = ICRI.related_item_id
456: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
457: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
458: AND MSIB.web_status = ''PUBLISHED''
459: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
460:
461: l_with_mtl_stmt1 VARCHAR2(2500) :=
462:
463: ' SELECT DISTINCT ICRI.related_item_id

Line 472: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

468: AND MSIB.inventory_item_id = ICRI.related_item_id
469: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
470: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
471: AND MSIB.web_status = ''PUBLISHED''
472: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
473:
474:
475: l_with_mtl_stmt2 VARCHAR2(3000) :=
476: ' UNION ALL

Line 489: AND MRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

485: AND MSIB.inventory_item_id = MRI.related_item_id
486: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
487: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
488: AND MSIB.web_status = ''PUBLISHED''
489: AND MRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
490:
491: l_with_mtl_stmt3 VARCHAR2(3000) :=
492: ' UNION ALL
493: SELECT MRI.inventory_item_id

Line 506: AND MRI.related_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

502: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
503: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
504: AND MSIB.web_status = ''PUBLISHED''
505: AND MRI.reciprocal_flag = ''Y''
506: AND MRI.related_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
507:
508: l_with_mtl_stmt4 VARCHAR2(2000) :=
509: ' MINUS
510: SELECT ICRE.related_item_id

Line 513: AND ICRE.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

509: ' MINUS
510: SELECT ICRE.related_item_id
511: FROM ibe_ct_rel_exclusions ICRE
512: WHERE ICRE.relation_type_code = :rel_type_code13
513: AND ICRE.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
514:
515: l_without_mtl_bulk_stmt VARCHAR2(2500) :=
516: 'BEGIN
517: SELECT DISTINCT ICRI.related_item_id

Line 532: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

528: AND MSIB.inventory_item_id = ICRI.related_item_id
529: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
530: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
531: AND MSIB.web_status = ''PUBLISHED''
532: AND ICRI.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
533:
534: l_stmt VARCHAR2(2000);
535: l_rel_items_csr prod_cursor;
536: l_rel_item_id NUMBER;

Line 573: x_items_tbl := JTF_Number_Table();

569:
570: END IF;
571:
572: -- Initialize the return value table
573: x_items_tbl := JTF_Number_Table();
574:
575: IF (AMS_DEBUG_HIGH_ON) THEN
576: AMS_UTILITY_PVT.debug_message('p_org_id : p_rel_type_code = '
577: || TO_CHAR(p_org_id) || ' : ' || p_rel_type_code);

Line 713: p_input_lst IN JTF_NUMBER_TABLE,

709:
710:
711: PROCEDURE sortRandom
712: (
713: p_input_lst IN JTF_NUMBER_TABLE,
714: p_max_ret_num IN NUMBER := NULL,
715: x_output_lst OUT NOCOPY JTF_Number_Table
716: )
717: IS

Line 715: x_output_lst OUT NOCOPY JTF_Number_Table

711: PROCEDURE sortRandom
712: (
713: p_input_lst IN JTF_NUMBER_TABLE,
714: p_max_ret_num IN NUMBER := NULL,
715: x_output_lst OUT NOCOPY JTF_Number_Table
716: )
717: IS
718: l_input_lst JTF_NUMBER_TABLE;
719: l_randoms JTF_NUMBER_TABLE;

Line 718: l_input_lst JTF_NUMBER_TABLE;

714: p_max_ret_num IN NUMBER := NULL,
715: x_output_lst OUT NOCOPY JTF_Number_Table
716: )
717: IS
718: l_input_lst JTF_NUMBER_TABLE;
719: l_randoms JTF_NUMBER_TABLE;
720: i PLS_INTEGER := 1;
721: j PLS_INTEGER := 1;
722: limit PLS_INTEGER;

Line 719: l_randoms JTF_NUMBER_TABLE;

715: x_output_lst OUT NOCOPY JTF_Number_Table
716: )
717: IS
718: l_input_lst JTF_NUMBER_TABLE;
719: l_randoms JTF_NUMBER_TABLE;
720: i PLS_INTEGER := 1;
721: j PLS_INTEGER := 1;
722: limit PLS_INTEGER;
723: temp NUMBER;

Line 733: l_input_lst := JTF_NUMBER_TABLE();

729:
730: AMS_UTILITY_PVT.debug_message('random sorting starts');
731:
732: END IF;
733: l_input_lst := JTF_NUMBER_TABLE();
734: x_output_lst := JTF_NUMBER_TABLE();
735: for i in 1..p_input_lst.COUNT
736: loop
737: l_input_lst.EXTEND;

Line 734: x_output_lst := JTF_NUMBER_TABLE();

730: AMS_UTILITY_PVT.debug_message('random sorting starts');
731:
732: END IF;
733: l_input_lst := JTF_NUMBER_TABLE();
734: x_output_lst := JTF_NUMBER_TABLE();
735: for i in 1..p_input_lst.COUNT
736: loop
737: l_input_lst.EXTEND;
738: l_input_lst(i) := p_input_lst(i);

Line 741: l_randoms := JTF_NUMBER_TABLE();

737: l_input_lst.EXTEND;
738: l_input_lst(i) := p_input_lst(i);
739: end loop;
740:
741: l_randoms := JTF_NUMBER_TABLE();
742: IF(p_input_lst.COUNT > 1) THEN
743:
744: --first generate all random numbers
745: for i in 1..p_input_lst.COUNT

Line 808: p_prod_lst IN JTF_NUMBER_TABLE,

804: p_application_id IN NUMBER,
805: p_party_id IN NUMBER,
806: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
807: p_currency_code IN VARCHAR2 := NULL,
808: p_prod_lst IN JTF_NUMBER_TABLE,
809: p_msite_id IN NUMBER := NULL,
810: p_top_section_id IN NUMBER := NULL,
811: p_org_id IN NUMBER,
812: p_bus_prior IN VARCHAR2 := NULL,

Line 817: x_prod_lst OUT NOCOPY JTF_Number_Table,

813: p_bus_prior_order IN VARCHAR2 := NULL,
814: p_filter_ref_code IN VARCHAR2 := NULL,
815: p_price_list_id IN NUMBER := NULL,
816: p_max_ret_num IN NUMBER := NULL,
817: x_prod_lst OUT NOCOPY JTF_Number_Table,
818: x_return_status OUT NOCOPY VARCHAR2,
819: x_msg_count OUT NOCOPY NUMBER,
820: x_msg_data OUT NOCOPY VARCHAR2
821: )

Line 839: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

835: AND NVL(D.END_DATE_ACTIVE,SYSDATE) >= SYSDATE
836: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
837: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
838: AND MSIB.web_status = ''PUBLISHED''
839: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
840:
841: l_minisite_stmt VARCHAR2(2500) :=
842: 'SELECT MSIB.inventory_item_id
843: FROM mtl_system_items_b MSIB,

Line 853: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

849: AND NVL(D.END_DATE_ACTIVE,SYSDATE) >= SYSDATE
850: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
851: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
852: AND MSIB.web_status = ''PUBLISHED''
853: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
854:
855: l_minisite_section_stmt VARCHAR2(2000) :=
856: ' AND D.top_section_id = :top_section_id3';
857:

Line 873: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

869: WHERE MSIB.organization_id = :org_id2
870: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
871: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
872: AND MSIB.web_status = ''PUBLISHED''
873: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
874:
875: l_mtl_stmt VARCHAR2(2500) :=
876: 'SELECT MSIB.inventory_item_id
877: FROM mtl_system_items_b MSIB

Line 882: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';

878: WHERE MSIB.organization_id = :org_id2
879: AND NVL(MSIB.start_date_active, SYSDATE) <= SYSDATE
880: AND NVL(MSIB.end_date_active, SYSDATE) >= SYSDATE
881: AND MSIB.web_status = ''PUBLISHED''
882: AND MSIB.inventory_item_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_prod_lst AS JTF_NUMBER_TABLE)) t)';
883:
884: l_stmt VARCHAR2(2000);
885: l_rel_items_csr prod_cursor;
886: l_rel_item_id NUMBER;

Line 888: l_prod_lst JTF_NUMBER_TABLE;

884: l_stmt VARCHAR2(2000);
885: l_rel_items_csr prod_cursor;
886: l_rel_item_id NUMBER;
887: l_items_in_clause VARCHAR2(32760);
888: l_prod_lst JTF_NUMBER_TABLE;
889: l_item_id NUMBER;
890: l_limit NUMBER;
891: p_index BINARY_INTEGER;
892: i PLS_INTEGER := 1;

Line 918: x_prod_lst := JTF_Number_Table();

914: AMS_UTILITY_PVT.debug_message('AMS_RUNTIME_PROD_PVT.getFilteredProdsFromList starts');
915: END IF;
916:
917: -- Initialize the return value table
918: x_prod_lst := JTF_Number_Table();
919: l_prod_lst := JTF_NUMBER_TABLE();
920: -- Commented IN Clause BugFix 3776065
921: -- p_Index := p_prod_lst.FIRST;
922: -- FOR pNum IN 1..( p_prod_lst.COUNT - 1 ) LOOP

Line 919: l_prod_lst := JTF_NUMBER_TABLE();

915: END IF;
916:
917: -- Initialize the return value table
918: x_prod_lst := JTF_Number_Table();
919: l_prod_lst := JTF_NUMBER_TABLE();
920: -- Commented IN Clause BugFix 3776065
921: -- p_Index := p_prod_lst.FIRST;
922: -- FOR pNum IN 1..( p_prod_lst.COUNT - 1 ) LOOP
923: -- l_items_in_clause := l_items_in_clause || TO_CHAR( p_prod_lst( p_Index ) ) || ', ';

Line 1128: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

1124: p_bus_prior_order IN VARCHAR2,
1125: p_filter_ref_code IN VARCHAR2,
1126: p_price_list_id IN NUMBER := NULL,
1127: p_max_ret_num IN NUMBER := NULL,
1128: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
1129: x_return_status OUT NOCOPY VARCHAR2,
1130: x_msg_count OUT NOCOPY NUMBER,
1131: x_msg_data OUT NOCOPY VARCHAR2
1132: )

Line 1140: l_quote_prod_lst JTF_NUMBER_TABLE;

1136:
1137: l_return_status VARCHAR2( 10 );
1138: l_msg_count NUMBER;
1139: l_msg_data VARCHAR2( 1000 );
1140: l_quote_prod_lst JTF_NUMBER_TABLE;
1141: l_prod_lst JTF_NUMBER_TABLE;
1142: l_null CHAR(1);
1143: l_incl_top_section VARCHAR2(1) := NULL;
1144: l_item_id NUMBER;

Line 1141: l_prod_lst JTF_NUMBER_TABLE;

1137: l_return_status VARCHAR2( 10 );
1138: l_msg_count NUMBER;
1139: l_msg_data VARCHAR2( 1000 );
1140: l_quote_prod_lst JTF_NUMBER_TABLE;
1141: l_prod_lst JTF_NUMBER_TABLE;
1142: l_null CHAR(1);
1143: l_incl_top_section VARCHAR2(1) := NULL;
1144: l_item_id NUMBER;
1145: l_random NUMBER;

Line 1199: l_quote_prod_lst := JTF_NUMBER_TABLE();

1195: END IF;
1196:
1197: -- 2. Collect Shopping Cart items
1198: -- GetXSellForQuote Start
1199: l_quote_prod_lst := JTF_NUMBER_TABLE();
1200:
1201: select inventory_item_id
1202: bulk collect into l_quote_prod_lst
1203: from aso_quote_lines_all_v

Line 1207: x_prod_lst := JTF_Number_Table();

1203: from aso_quote_lines_all_v
1204: where quote_header_id = p_quote_id;
1205:
1206: IF SQL%ROWCOUNT = 0 THEN
1207: x_prod_lst := JTF_Number_Table();
1208: IF (AMS_DEBUG_HIGH_ON) THEN
1209:
1210: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
1211: END IF;

Line 1213: x_prod_lst := JTF_Number_Table();

1209:
1210: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
1211: END IF;
1212: ELSIF l_quote_prod_lst.COUNT = 0 THEN
1213: x_prod_lst := JTF_Number_Table();
1214: IF (AMS_DEBUG_HIGH_ON) THEN
1215:
1216: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
1217: END IF;

Line 1320: p_prod_lst IN JTF_NUMBER_TABLE,

1316: p_application_id IN NUMBER,
1317: p_party_id IN NUMBER,
1318: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1319: p_currency_code IN VARCHAR2 := NULL,
1320: p_prod_lst IN JTF_NUMBER_TABLE,
1321: p_msite_id IN NUMBER,
1322: p_top_section_id IN NUMBER,
1323: p_org_id IN NUMBER,
1324: p_rel_type_code IN VARCHAR2,

Line 1330: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

1326: p_bus_prior_order IN VARCHAR2,
1327: p_filter_ref_code IN VARCHAR2,
1328: p_price_list_id IN NUMBER := NULL,
1329: p_max_ret_num IN NUMBER := NULL,
1330: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
1331: x_return_status OUT NOCOPY VARCHAR2,
1332: x_msg_count OUT NOCOPY NUMBER,
1333: x_msg_data OUT NOCOPY VARCHAR2
1334: )

Line 1342: l_prod_lst JTF_NUMBER_TABLE;

1338:
1339: l_return_status VARCHAR2( 10 );
1340: l_msg_count NUMBER;
1341: l_msg_data VARCHAR2( 1000 );
1342: l_prod_lst JTF_NUMBER_TABLE;
1343: l_null CHAR(1);
1344: l_incl_top_section VARCHAR2(1) := NULL;
1345: l_item_id NUMBER;
1346: l_random NUMBER;

Line 1508: p_prod_lst IN JTF_NUMBER_TABLE,

1504: p_application_id IN NUMBER,
1505: p_party_id IN NUMBER,
1506: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1507: p_currency_code IN VARCHAR2 := NULL,
1508: p_prod_lst IN JTF_NUMBER_TABLE,
1509: p_org_id IN NUMBER,
1510: p_bus_prior IN VARCHAR2,
1511: p_bus_prior_order IN VARCHAR2,
1512: p_price_list_id IN NUMBER := NULL,

Line 1514: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

1510: p_bus_prior IN VARCHAR2,
1511: p_bus_prior_order IN VARCHAR2,
1512: p_price_list_id IN NUMBER := NULL,
1513: p_max_ret_num IN NUMBER := NULL,
1514: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
1515: x_return_status OUT NOCOPY VARCHAR2,
1516: x_msg_count OUT NOCOPY NUMBER,
1517: x_msg_data OUT NOCOPY VARCHAR2
1518: )

Line 1578: x_prod_lst := JTF_Number_Table();

1574: IF (AMS_DEBUG_HIGH_ON) THEN
1575: AMS_UTILITY_PVT.debug_message('Order of Sorting is : '||l_order);
1576: END IF;
1577:
1578: x_prod_lst := JTF_Number_Table();
1579: p_in_prod_lst := JTF_VARCHAR2_TABLE_100();
1580:
1581: IF(p_bus_prior = 'PROD_LIST_PRICE' AND p_price_list_id IS NOT NULL AND p_prod_lst.COUNT > 1) THEN
1582: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1754: p_itmid_tbl IN JTF_NUMBER_TABLE,

1750: p_application_id IN NUMBER,
1751: p_party_id IN NUMBER,
1752: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1753: p_currency_code IN VARCHAR2 := NULL,
1754: p_itmid_tbl IN JTF_NUMBER_TABLE,
1755: p_organization_id IN NUMBER,
1756: p_category_set_id IN NUMBER,
1757: p_retrieve_price IN VARCHAR2 := FND_API.G_FALSE,
1758: p_price_list_id IN NUMBER := NULL,

Line 1763: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,

1759: p_price_request_type IN VARCHAR2 := NULL,
1760: p_price_event IN VARCHAR2 := NULL,
1761: x_item_csr OUT NOCOPY prod_cursor,
1762: x_category_id_csr OUT NOCOPY prod_cursor,
1763: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1764: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1765: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
1766: x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
1767: x_price_return_status OUT NOCOPY VARCHAR2,

Line 1764: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,

1760: p_price_event IN VARCHAR2 := NULL,
1761: x_item_csr OUT NOCOPY prod_cursor,
1762: x_category_id_csr OUT NOCOPY prod_cursor,
1763: x_listprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1764: x_bestprice_tbl OUT nocopy JTF_NUMBER_TABLE,
1765: x_price_status_code_tbl OUT nocopy JTF_VARCHAR2_TABLE_100,
1766: x_price_status_text_tbl OUT nocopy JTF_VARCHAR2_TABLE_300,
1767: x_price_return_status OUT NOCOPY VARCHAR2,
1768: x_price_return_status_text OUT NOCOPY VARCHAR2,

Line 1792: ' AND MSIV.INVENTORY_ITEM_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_itmid_tbl AS JTF_NUMBER_TABLE)) t)';

1788: ' WHERE MSIV.ORGANIZATION_ID = :org_id' ||
1789: ' AND MSIV.WEB_STATUS = ''PUBLISHED'''||
1790: ' AND NVL(MSIV.START_DATE_ACTIVE, SYSDATE) <= SYSDATE ' ||
1791: ' AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE ' ||
1792: ' AND MSIV.INVENTORY_ITEM_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_itmid_tbl AS JTF_NUMBER_TABLE)) t)';
1793:
1794: l_category_stmt VARCHAR2(4000) :=
1795: 'SELECT MSIV.INVENTORY_ITEM_ID, MIC.CATEGORY_ID' ||
1796: ' FROM MTL_SYSTEM_ITEMS_VL MSIV, MTL_ITEM_CATEGORIES MIC' ||

Line 1803: ' AND MSIV.INVENTORY_ITEM_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_itmid_tbl AS JTF_NUMBER_TABLE)) t)';

1799: ' AND NVL(MSIV.END_DATE_ACTIVE, SYSDATE) >= SYSDATE' ||
1800: ' AND MSIV.INVENTORY_ITEM_ID = MIC.INVENTORY_ITEM_ID' ||
1801: ' AND MSIV.ORGANIZATION_ID = MIC.ORGANIZATION_ID' ||
1802: ' AND MIC.CATEGORY_SET_ID = :category_set' ||
1803: ' AND MSIV.INVENTORY_ITEM_ID IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_itmid_tbl AS JTF_NUMBER_TABLE)) t)';
1804:
1805: i PLS_INTEGER := 1;
1806: found BOOLEAN;
1807: l_items_in_clause VARCHAR2(32760);

Line 1808: l_itmid_tbl JTF_NUMBER_TABLE;

1804:
1805: i PLS_INTEGER := 1;
1806: found BOOLEAN;
1807: l_items_in_clause VARCHAR2(32760);
1808: l_itmid_tbl JTF_NUMBER_TABLE;
1809: l_index BINARY_INTEGER;
1810: l_itmid NUMBER;
1811: l_uomcode VARCHAR2(3);
1812: l_uomcode_tbl JTF_VARCHAR2_TABLE_100;

Line 1963: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

1959: p_top_section_id IN NUMBER,
1960: p_org_id IN NUMBER,
1961: p_rel_type_code IN VARCHAR2,
1962: p_max_ret_num IN NUMBER := NULL,
1963: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
1964: x_return_status OUT NOCOPY VARCHAR2,
1965: x_msg_count OUT NOCOPY NUMBER,
1966: x_msg_data OUT NOCOPY VARCHAR2
1967: )

Line 1974: l_quote_prod_lst JTF_NUMBER_TABLE;

1970: l_api_version CONSTANT NUMBER := 1.0;
1971: l_return_status VARCHAR2( 10 );
1972: l_msg_count NUMBER;
1973: l_msg_data VARCHAR2( 1000 );
1974: l_quote_prod_lst JTF_NUMBER_TABLE;
1975: l_prod_lst JTF_NUMBER_TABLE;
1976: l_null CHAR(1);
1977: l_incl_top_section VARCHAR2(1) := NULL;
1978: l_item_id NUMBER;

Line 1975: l_prod_lst JTF_NUMBER_TABLE;

1971: l_return_status VARCHAR2( 10 );
1972: l_msg_count NUMBER;
1973: l_msg_data VARCHAR2( 1000 );
1974: l_quote_prod_lst JTF_NUMBER_TABLE;
1975: l_prod_lst JTF_NUMBER_TABLE;
1976: l_null CHAR(1);
1977: l_incl_top_section VARCHAR2(1) := NULL;
1978: l_item_id NUMBER;
1979: l_random NUMBER;

Line 2032: l_quote_prod_lst := JTF_NUMBER_TABLE();

2028: -- 2. Collect Shopping Cart items
2029:
2030: -- GetXSellForQuote Start
2031:
2032: l_quote_prod_lst := JTF_NUMBER_TABLE();
2033: select inventory_item_id
2034: bulk collect into l_quote_prod_lst
2035: from aso_quote_lines_all_v
2036: where quote_header_id = p_quote_id;

Line 2039: x_prod_lst := JTF_Number_Table();

2035: from aso_quote_lines_all_v
2036: where quote_header_id = p_quote_id;
2037:
2038: IF (SQL%ROWCOUNT = 0) THEN
2039: x_prod_lst := JTF_Number_Table();
2040: IF (AMS_DEBUG_HIGH_ON) THEN
2041: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
2042: END IF;
2043:

Line 2045: x_prod_lst := JTF_Number_Table();

2041: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
2042: END IF;
2043:
2044: ELSIF (l_quote_prod_lst.COUNT = 0) THEN
2045: x_prod_lst := JTF_Number_Table();
2046: IF (AMS_DEBUG_HIGH_ON) THEN
2047: AMS_UTILITY_PVT.debug_message('No Items found for Quote Id : '||TO_CHAR(p_quote_id));
2048: END IF;
2049: ELSE

Line 2131: p_prod_lst IN JTF_NUMBER_TABLE,

2127: p_application_id IN NUMBER,
2128: p_party_id IN NUMBER,
2129: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
2130: p_currency_code IN VARCHAR2 := NULL,
2131: p_prod_lst IN JTF_NUMBER_TABLE,
2132: p_msite_id IN NUMBER,
2133: p_top_section_id IN NUMBER,
2134: p_org_id IN NUMBER,
2135: p_rel_type_code IN VARCHAR2,

Line 2137: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,

2133: p_top_section_id IN NUMBER,
2134: p_org_id IN NUMBER,
2135: p_rel_type_code IN VARCHAR2,
2136: p_max_ret_num IN NUMBER := NULL,
2137: x_prod_lst OUT NOCOPY JTF_NUMBER_TABLE,
2138: x_return_status OUT NOCOPY VARCHAR2,
2139: x_msg_count OUT NOCOPY NUMBER,
2140: x_msg_data OUT NOCOPY VARCHAR2
2141: )

Line 2149: l_prod_lst JTF_NUMBER_TABLE;

2145:
2146: l_return_status VARCHAR2( 10 );
2147: l_msg_count NUMBER;
2148: l_msg_data VARCHAR2( 1000 );
2149: l_prod_lst JTF_NUMBER_TABLE;
2150: l_null CHAR(1);
2151: l_incl_top_section VARCHAR2(1) := NULL;
2152: l_item_id NUMBER;
2153: l_random NUMBER;