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

Line 12: p_input_lst IN JTF_NUMBER_TABLE,

8:
9:
10: PROCEDURE sortRandom
11: (
12: p_input_lst IN JTF_NUMBER_TABLE,
13: p_max_ret_num IN NUMBER := NULL,
14: x_output_lst OUT NOCOPY JTF_Number_Table
15: )
16: IS

Line 14: x_output_lst OUT NOCOPY JTF_Number_Table

10: PROCEDURE sortRandom
11: (
12: p_input_lst IN JTF_NUMBER_TABLE,
13: p_max_ret_num IN NUMBER := NULL,
14: x_output_lst OUT NOCOPY JTF_Number_Table
15: )
16: IS
17: l_input_lst JTF_NUMBER_TABLE;
18: l_randoms JTF_NUMBER_TABLE;

Line 17: l_input_lst JTF_NUMBER_TABLE;

13: p_max_ret_num IN NUMBER := NULL,
14: x_output_lst OUT NOCOPY JTF_Number_Table
15: )
16: IS
17: l_input_lst JTF_NUMBER_TABLE;
18: l_randoms JTF_NUMBER_TABLE;
19: i PLS_INTEGER := 1;
20: j PLS_INTEGER := 1;
21: limit PLS_INTEGER;

Line 18: l_randoms JTF_NUMBER_TABLE;

14: x_output_lst OUT NOCOPY JTF_Number_Table
15: )
16: IS
17: l_input_lst JTF_NUMBER_TABLE;
18: l_randoms JTF_NUMBER_TABLE;
19: i PLS_INTEGER := 1;
20: j PLS_INTEGER := 1;
21: limit PLS_INTEGER;
22: temp NUMBER;

Line 32: l_input_lst := JTF_NUMBER_TABLE();

28:
29: AMS_UTILITY_PVT.debug_message('random sorting starts');
30:
31: END IF;
32: l_input_lst := JTF_NUMBER_TABLE();
33: x_output_lst := JTF_NUMBER_TABLE();
34: for i in 1..p_input_lst.COUNT
35: loop
36: l_input_lst.EXTEND;

Line 33: x_output_lst := JTF_NUMBER_TABLE();

29: AMS_UTILITY_PVT.debug_message('random sorting starts');
30:
31: END IF;
32: l_input_lst := JTF_NUMBER_TABLE();
33: x_output_lst := JTF_NUMBER_TABLE();
34: for i in 1..p_input_lst.COUNT
35: loop
36: l_input_lst.EXTEND;
37: l_input_lst(i) := p_input_lst(i);

Line 40: l_randoms := JTF_NUMBER_TABLE();

36: l_input_lst.EXTEND;
37: l_input_lst(i) := p_input_lst(i);
38: end loop;
39:
40: l_randoms := JTF_NUMBER_TABLE();
41: IF(p_input_lst.COUNT > 1) THEN
42:
43: --first generate all random numbers
44: for i in 1..p_input_lst.COUNT

Line 107: p_offer_lst IN JTF_NUMBER_TABLE,

103: p_application_id IN NUMBER,
104: p_party_id IN NUMBER,
105: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
106: p_currency_code IN VARCHAR2 := NULL,
107: p_offer_lst IN JTF_NUMBER_TABLE,
108: p_org_id IN NUMBER,
109: p_max_ret_num IN NUMBER,
110: p_bus_prior IN VARCHAR2,
111: x_offer_qp_lst OUT NOCOPY off_rec_type_tbl,

Line 217: p_sched_lst IN JTF_NUMBER_TABLE,

213: p_init_msg_list IN VARCHAR2,
214: p_application_id IN NUMBER,
215: p_party_id IN NUMBER,
216: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
217: p_sched_lst IN JTF_NUMBER_TABLE,
218: p_org_id IN NUMBER,
219: p_bus_prior IN VARCHAR2 := NULL,
220: p_bus_prior_order IN VARCHAR2 := NULL,
221: p_filter_ref_code IN VARCHAR2 := NULL,

Line 223: x_sched_lst OUT NOCOPY JTF_Number_Table,

219: p_bus_prior IN VARCHAR2 := NULL,
220: p_bus_prior_order IN VARCHAR2 := NULL,
221: p_filter_ref_code IN VARCHAR2 := NULL,
222: p_max_ret_num IN NUMBER,
223: x_sched_lst OUT NOCOPY JTF_Number_Table,
224: x_return_status OUT NOCOPY VARCHAR2,
225: x_msg_count OUT NOCOPY NUMBER,
226: x_msg_data OUT NOCOPY VARCHAR2
227: )

Line 240: (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_sched_lst AS JTF_NUMBER_TABLE)) t)';

236: AND acsb.active_flag = ''Y''
237: AND NVL(acsb.start_date_time,SYSDATE) <= SYSDATE
238: AND NVL(acsb.end_date_time,SYSDATE) >= SYSDATE
239: AND acsb.schedule_id IN
240: (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_sched_lst AS JTF_NUMBER_TABLE)) t)';
241:
242: --BugFix 3537558 Replaced the IN values
243:
244: l_sched_prior_stmt_pre VARCHAR2(2000) :=

Line 255: (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_sched_lst AS JTF_NUMBER_TABLE)) t)';

251: AND NVL(acsb.end_date_time,SYSDATE) >= SYSDATE
252: AND LO.lookup_type = ''AMS_PRIORITY''
253: AND NVL(acsb.priority,''LOW'') = LO.lookup_code
254: AND acsb.schedule_id IN
255: (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:p_sched_lst AS JTF_NUMBER_TABLE)) t)';
256:
257: --BugFix 3537558 Replaced the IN values
258:
259: l_sched_stmt_post VARCHAR2(4000) :=

Line 342: l_sched_lst1 JTF_Number_Table;

338: pos PLS_INTEGER := 1;
339: l_random NUMBER;
340: l_found BOOLEAN := FALSE;
341: l_found1 BOOLEAN := FALSE;
342: l_sched_lst1 JTF_Number_Table;
343: l_sched_lst2 JTF_Number_Table;
344:
345: BEGIN
346: -- Standard call to check for call compatibility.

Line 343: l_sched_lst2 JTF_Number_Table;

339: l_random NUMBER;
340: l_found BOOLEAN := FALSE;
341: l_found1 BOOLEAN := FALSE;
342: l_sched_lst1 JTF_Number_Table;
343: l_sched_lst2 JTF_Number_Table;
344:
345: BEGIN
346: -- Standard call to check for call compatibility.
347: IF NOT FND_API.Compatible_API_Call( l_api_version,

Line 374: x_sched_lst := JTF_Number_Table();

370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: -- Initialize the return value table
374: x_sched_lst := JTF_Number_Table();
375: l_sched_lst1 := JTF_Number_Table();
376: l_sched_lst2 := JTF_Number_Table();
377:
378: -- BugFix 3537558 Commented the IN clause values

Line 375: l_sched_lst1 := JTF_Number_Table();

371: END IF;
372:
373: -- Initialize the return value table
374: x_sched_lst := JTF_Number_Table();
375: l_sched_lst1 := JTF_Number_Table();
376: l_sched_lst2 := JTF_Number_Table();
377:
378: -- BugFix 3537558 Commented the IN clause values
379:

Line 376: l_sched_lst2 := JTF_Number_Table();

372:
373: -- Initialize the return value table
374: x_sched_lst := JTF_Number_Table();
375: l_sched_lst1 := JTF_Number_Table();
376: l_sched_lst2 := JTF_Number_Table();
377:
378: -- BugFix 3537558 Commented the IN clause values
379:
380: -- p_Index := p_sched_lst.FIRST;

Line 593: x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,

589: p_bus_prior_order IN VARCHAR2,
590: p_filter_ref_code IN VARCHAR2,
591: p_price_list_id IN NUMBER := NULL,
592: p_max_ret_num IN NUMBER := NULL,
593: x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,
594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2
597: )

Line 699: l_quote_prod_lst JTF_NUMBER_TABLE;

695: )
696: )';
697:
698: l_camp_csr camp_cursor;
699: l_quote_prod_lst JTF_NUMBER_TABLE;
700: l_return_status VARCHAR2( 10 );
701: l_msg_count NUMBER;
702: l_msg_data VARCHAR2( 1000 );
703: l_bus_prior VARCHAR2( 30 ) := NULL;

Line 705: l_sched_lst JTF_NUMBER_TABLE;

701: l_msg_count NUMBER;
702: l_msg_data VARCHAR2( 1000 );
703: l_bus_prior VARCHAR2( 30 ) := NULL;
704: l_sched_id NUMBER;
705: l_sched_lst JTF_NUMBER_TABLE;
706: l_order VARCHAR2(10);
707: p_index BINARY_INTEGER;
708: l_items_in_clause1 VARCHAR2(32760);
709: order_items_in_clause1 VARCHAR2(38);

Line 755: l_quote_prod_lst := JTF_NUMBER_TABLE();

751: IF(p_bus_prior <> 'RANDOM') THEN
752: l_bus_prior := p_bus_prior;
753: END IF;
754:
755: l_quote_prod_lst := JTF_NUMBER_TABLE();
756:
757: IF (p_rel_type_code = 'PROMOTING') THEN
758: select inventory_item_id
759: bulk collect into l_quote_prod_lst

Line 879: x_sched_lst := JTF_Number_Table();

875: l_sched_stmt_post
876: USING p_party_id,p_party_id;
877: END IF;
878:
879: x_sched_lst := JTF_Number_Table();
880: i := 1;
881: LOOP
882: FETCH l_camp_csr INTO l_sched_id;
883: EXIT WHEN l_camp_csr%NOTFOUND;

Line 968: p_prod_lst IN JTF_NUMBER_TABLE,

964: p_application_id IN NUMBER,
965: p_party_id IN NUMBER,
966: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_currency_code IN VARCHAR2 := NULL,
968: p_prod_lst IN JTF_NUMBER_TABLE,
969: p_msite_id IN NUMBER,
970: p_top_section_id IN NUMBER,
971: p_org_id IN NUMBER,
972: p_rel_type_code IN VARCHAR2,

Line 978: x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,

974: p_bus_prior_order IN VARCHAR2,
975: p_filter_ref_code IN VARCHAR2,
976: p_price_list_id IN NUMBER := NULL,
977: p_max_ret_num IN NUMBER := NULL,
978: x_sched_lst OUT NOCOPY JTF_NUMBER_TABLE,
979: x_return_status OUT NOCOPY VARCHAR2,
980: x_msg_count OUT NOCOPY NUMBER,
981: x_msg_data OUT NOCOPY VARCHAR2
982: )

Line 1086: l_prod_lst JTF_NUMBER_TABLE;

1082: )
1083: )';
1084:
1085: l_camp_csr camp_cursor;
1086: l_prod_lst JTF_NUMBER_TABLE;
1087: l_sched_lst JTF_NUMBER_TABLE;
1088: l_return_status VARCHAR2( 10 );
1089: l_msg_count NUMBER;
1090: l_msg_data VARCHAR2( 1000 );

Line 1087: l_sched_lst JTF_NUMBER_TABLE;

1083: )';
1084:
1085: l_camp_csr camp_cursor;
1086: l_prod_lst JTF_NUMBER_TABLE;
1087: l_sched_lst JTF_NUMBER_TABLE;
1088: l_return_status VARCHAR2( 10 );
1089: l_msg_count NUMBER;
1090: l_msg_data VARCHAR2( 1000 );
1091: l_bus_prior VARCHAR2( 30 ) := NULL;

Line 1141: x_sched_lst := JTF_Number_Table();

1137: IF(p_bus_prior <> 'RANDOM') THEN
1138: l_bus_prior := p_bus_prior;
1139: END IF;
1140:
1141: x_sched_lst := JTF_Number_Table();
1142:
1143:
1144: IF (p_rel_type_code = 'PROMOTING') THEN
1145: l_prod_lst := p_prod_lst;

Line 1263: x_sched_lst := JTF_Number_Table();

1259: l_sched_stmt_post
1260: USING p_party_id,p_party_id;
1261: END IF;
1262:
1263: x_sched_lst := JTF_Number_Table();
1264:
1265:
1266: --ListPrice Order for ProductRelationship
1267:

Line 1408: p_offer_lst IN JTF_NUMBER_TABLE,

1404: p_application_id IN NUMBER,
1405: p_party_id IN NUMBER,
1406: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1407: p_currency_code IN VARCHAR2 := NULL,
1408: p_offer_lst IN JTF_NUMBER_TABLE,
1409: p_org_id IN NUMBER,
1410: p_bus_prior IN VARCHAR2 := NULL,
1411: p_bus_prior_order IN VARCHAR2 := NULL,
1412: p_filter_ref_code IN VARCHAR2 := NULL,

Line 1415: x_offer_lst OUT NOCOPY JTF_Number_Table,

1411: p_bus_prior_order IN VARCHAR2 := NULL,
1412: p_filter_ref_code IN VARCHAR2 := NULL,
1413: p_price_list_id IN NUMBER := NULL,
1414: p_max_ret_num IN NUMBER,
1415: x_offer_lst OUT NOCOPY JTF_Number_Table,
1416: x_return_status OUT NOCOPY VARCHAR2,
1417: x_msg_count OUT NOCOPY NUMBER,
1418: x_msg_data OUT NOCOPY VARCHAR2
1419: )

Line 1429: l_offer_lst JTF_NUMBER_TABLE;

1425: l_cust_account_id NUMBER;
1426: l_party_id NUMBER;
1427: --l_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1428: l_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1429: l_offer_lst JTF_NUMBER_TABLE;
1430:
1431: l_in_offer_lst JTF_NUMBER_TABLE;
1432:
1433: --x_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

Line 1431: l_in_offer_lst JTF_NUMBER_TABLE;

1427: --l_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1428: l_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1429: l_offer_lst JTF_NUMBER_TABLE;
1430:
1431: l_in_offer_lst JTF_NUMBER_TABLE;
1432:
1433: --x_offers_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1434: x_offers_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1435:

Line 1440: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )

1436: --fix for SQL Repository issue 11755480
1437: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id
1438: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch
1439: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1440: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )
1441: AND aao.act_offer_used_by_id = csch.schedule_id
1442: AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1)
1443: and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1444: AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40';

Line 1454: --AND qlhv.list_header_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) t)';

1450: --AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
1451: --AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1)
1452: --and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1453: --AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40
1454: --AND qlhv.list_header_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) t)';
1455:
1456: -- BugFix 3684266 Replaced IN clause
1457:
1458: l_offer_csr camp_cursor;

Line 1469: act_offer_lst JTF_Number_Table;

1465: k PLS_INTEGER := 1;
1466: pos PLS_INTEGER := 1;
1467: l_random NUMBER;
1468: l_found BOOLEAN := FALSE;
1469: act_offer_lst JTF_Number_Table;
1470: l_offer_lst1 JTF_Number_Table;
1471: l_offer_lst2 JTF_Number_Table;
1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
1473: l_validate_qp_list_header_id NUMBER;

Line 1470: l_offer_lst1 JTF_Number_Table;

1466: pos PLS_INTEGER := 1;
1467: l_random NUMBER;
1468: l_found BOOLEAN := FALSE;
1469: act_offer_lst JTF_Number_Table;
1470: l_offer_lst1 JTF_Number_Table;
1471: l_offer_lst2 JTF_Number_Table;
1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
1473: l_validate_qp_list_header_id NUMBER;
1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

Line 1471: l_offer_lst2 JTF_Number_Table;

1467: l_random NUMBER;
1468: l_found BOOLEAN := FALSE;
1469: act_offer_lst JTF_Number_Table;
1470: l_offer_lst1 JTF_Number_Table;
1471: l_offer_lst2 JTF_Number_Table;
1472: x_offer_qp_lst AMS_RUNTIME_CAMP_PVT.off_rec_type_tbl;
1473: l_validate_qp_list_header_id NUMBER;
1474: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1475:

Line 1611: l_offer_lst := JTF_NUMBER_TABLE();

1607: END IF;
1608:
1609: x_return_status := FND_API.g_ret_sts_success;
1610:
1611: l_offer_lst := JTF_NUMBER_TABLE();
1612:
1613: l_in_offer_lst := JTF_NUMBER_TABLE();
1614:
1615: IF x_offers_tbl.COUNT = 0 THEN

Line 1613: l_in_offer_lst := JTF_NUMBER_TABLE();

1609: x_return_status := FND_API.g_ret_sts_success;
1610:
1611: l_offer_lst := JTF_NUMBER_TABLE();
1612:
1613: l_in_offer_lst := JTF_NUMBER_TABLE();
1614:
1615: IF x_offers_tbl.COUNT = 0 THEN
1616: IF (AMS_DEBUG_HIGH_ON) THEN
1617:

Line 1634: -- Convert num_tbl_type to JTF_NUMBER_TABLE

1630:
1631: return;
1632: ELSE
1633:
1634: -- Convert num_tbl_type to JTF_NUMBER_TABLE
1635:
1636: FOR i in x_offers_tbl.first .. x_offers_tbl.last
1637: LOOP
1638: l_offer_lst.EXTEND;

Line 1651: act_offer_lst := JTF_Number_Table();

1647: -- Got the Desired list of Offers Now Display priority
1648:
1649: -- Initialize the return value table
1650:
1651: act_offer_lst := JTF_Number_Table();
1652: l_offer_lst1 := JTF_Number_Table();
1653: l_offer_lst2 := JTF_Number_Table();
1654:
1655: l_in_offer_lst := x_offer_lst;

Line 1652: l_offer_lst1 := JTF_Number_Table();

1648:
1649: -- Initialize the return value table
1650:
1651: act_offer_lst := JTF_Number_Table();
1652: l_offer_lst1 := JTF_Number_Table();
1653: l_offer_lst2 := JTF_Number_Table();
1654:
1655: l_in_offer_lst := x_offer_lst;
1656:

Line 1653: l_offer_lst2 := JTF_Number_Table();

1649: -- Initialize the return value table
1650:
1651: act_offer_lst := JTF_Number_Table();
1652: l_offer_lst1 := JTF_Number_Table();
1653: l_offer_lst2 := JTF_Number_Table();
1654:
1655: l_in_offer_lst := x_offer_lst;
1656:
1657: -- BugFix 3684266 Commented IN clause

Line 1785: act_offer_lst := jtf_number_table();

1781:
1782: -- Refine the qp_list_header_ids with activity_offer_id
1783: -- also check for the max to be returned
1784:
1785: act_offer_lst := jtf_number_table();
1786: k:=1;
1787:
1788: FOR i in 1..x_offer_lst.COUNT
1789: LOOP

Line 1876: x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,

1872: p_bus_prior_order IN VARCHAR2,
1873: p_filter_ref_code IN VARCHAR2,
1874: p_price_list_id IN NUMBER := NULL,
1875: p_max_ret_num IN NUMBER := NULL,
1876: x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,
1877: x_return_status OUT NOCOPY VARCHAR2,
1878: x_msg_count OUT NOCOPY NUMBER,
1879: x_msg_data OUT NOCOPY VARCHAR2
1880: )

Line 1885: l_quote_prod_lst JTF_NUMBER_TABLE;

1881: IS
1882: l_api_name CONSTANT VARCHAR2(30) := 'getRelOffersForQuoteAndCust';
1883: l_api_version CONSTANT NUMBER := 1.0;
1884:
1885: l_quote_prod_lst JTF_NUMBER_TABLE;
1886: l_in_offer_lst JTF_NUMBER_TABLE;
1887: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1888: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1889: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

Line 1886: l_in_offer_lst JTF_NUMBER_TABLE;

1882: l_api_name CONSTANT VARCHAR2(30) := 'getRelOffersForQuoteAndCust';
1883: l_api_version CONSTANT NUMBER := 1.0;
1884:
1885: l_quote_prod_lst JTF_NUMBER_TABLE;
1886: l_in_offer_lst JTF_NUMBER_TABLE;
1887: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1888: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1889: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
1890: l_offer_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

Line 1897: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )

1893: --fix for SQL Repository issue 11755493
1894: l_offer_stmt VARCHAR2(2500) := 'Select qlhv.list_header_id
1895: FROM ozf_act_offers aao,qp_list_headers_b qlhv,ams_campaign_schedules_b csch
1896: WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1897: and aao.qp_list_header_id in (SELECT COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) )
1898: AND aao.act_offer_used_by_id = csch.schedule_id
1899: AND qlhv.active_flag =''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1)
1900: and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1901: AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40';

Line 1910: --ND qlhv.list_header_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) t)';

1906: --WHERE aao.arc_act_offer_used_by = ''CSCH'' AND aao.qp_list_header_id = qlhv.list_header_id
1907: --AND aao.act_offer_used_by_id = csch.schedule_id AND camp.campaign_id = csch.campaign_id
1908: --AND qlhv.active_flag = ''Y'' AND TRUNC(sysdate) BETWEEN NVL(TRUNC(qlhv.start_date_active),TRUNC(sysdate)-1) and NVL(TRUNC(qlhv.end_date_active),trunc(sysdate)+1)
1909: --AND qlhv.ask_for_flag = ''Y'' AND csch.status_code = ''ACTIVE'' AND csch.activity_id=40
1910: --ND qlhv.list_header_id IN (SELECT t.COLUMN_VALUE FROM TABLE(CAST(:l_in_offer_lst AS JTF_NUMBER_TABLE)) t)';
1911:
1912: -- BugFix 3684266 Replaced IN clause
1913:
1914: CURSOR c_act_qp_offer(l_qp_list_header_id NUMBER) IS

Line 1934: act_offer_lst JTF_Number_Table;

1930: k PLS_INTEGER := 1;
1931: pos PLS_INTEGER := 1;
1932: l_random NUMBER;
1933: l_found BOOLEAN := FALSE;
1934: act_offer_lst JTF_Number_Table;
1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;

Line 1935: l_offer_lst JTF_Number_Table;

1931: pos PLS_INTEGER := 1;
1932: l_random NUMBER;
1933: l_found BOOLEAN := FALSE;
1934: act_offer_lst JTF_Number_Table;
1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

Line 1936: l_offer_lst1 JTF_Number_Table;

1932: l_random NUMBER;
1933: l_found BOOLEAN := FALSE;
1934: act_offer_lst JTF_Number_Table;
1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1940: l_counter NUMBER := 0;

Line 1937: l_offer_lst2 JTF_Number_Table;

1933: l_found BOOLEAN := FALSE;
1934: act_offer_lst JTF_Number_Table;
1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1940: l_counter NUMBER := 0;
1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;

Line 1938: -- temp_offer_lst JTF_Number_Table;

1934: act_offer_lst JTF_Number_Table;
1935: l_offer_lst JTF_Number_Table;
1936: l_offer_lst1 JTF_Number_Table;
1937: l_offer_lst2 JTF_Number_Table;
1938: -- temp_offer_lst JTF_Number_Table;
1939: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
1940: l_counter NUMBER := 0;
1941: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;
1942:

Line 1977: l_quote_prod_lst := JTF_NUMBER_TABLE();

1973: IF(p_bus_prior <> 'RANDOM') THEN
1974: l_bus_prior := p_bus_prior;
1975: END IF;
1976:
1977: l_quote_prod_lst := JTF_NUMBER_TABLE();
1978:
1979: IF (p_rel_type_code = 'PROMOTING') THEN
1980: select inventory_item_id
1981: bulk collect into l_quote_prod_lst

Line 2096: -- temp_offer_lst := JTF_Number_Table();

2092: IF (AMS_DEBUG_HIGH_ON) THEN
2093: AMS_UTILITY_PVT.debug_message('# of Offers: '|| l_offer_tbl.COUNT);
2094: END IF;
2095:
2096: -- temp_offer_lst := JTF_Number_Table();
2097:
2098: l_in_offer_lst := JTF_Number_Table();
2099:
2100: -- Convert Table to List

Line 2098: l_in_offer_lst := JTF_Number_Table();

2094: END IF;
2095:
2096: -- temp_offer_lst := JTF_Number_Table();
2097:
2098: l_in_offer_lst := JTF_Number_Table();
2099:
2100: -- Convert Table to List
2101: FOR i in l_offer_tbl.first .. l_offer_tbl.last
2102: LOOP

Line 2152: act_offer_lst := JTF_Number_Table();

2148: OPEN l_offer_csr FOR l_offer_stmt using l_in_offer_lst;
2149:
2150: END IF;
2151:
2152: act_offer_lst := JTF_Number_Table();
2153:
2154: i := 1;
2155: LOOP
2156: FETCH l_offer_csr INTO l_offer_id;

Line 2213: act_offer_lst := JTF_Number_Table();

2209: END LOOP;
2210:
2211: -- convert l_qp_rec_type_tbl to act_offer_list
2212:
2213: act_offer_lst := JTF_Number_Table();
2214: l_counter := 0;
2215:
2216: -- Convert Table to List
2217:

Line 2280: p_prod_lst IN JTF_NUMBER_TABLE,

2276: p_application_id IN NUMBER,
2277: p_party_id IN NUMBER,
2278: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
2279: p_currency_code IN VARCHAR2 := NULL,
2280: p_prod_lst IN JTF_NUMBER_TABLE,
2281: p_msite_id IN NUMBER,
2282: p_top_section_id IN NUMBER,
2283: p_org_id IN NUMBER,
2284: p_rel_type_code IN VARCHAR2,

Line 2290: x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,

2286: p_bus_prior_order IN VARCHAR2,
2287: p_filter_ref_code IN VARCHAR2,
2288: p_price_list_id IN NUMBER := NULL,
2289: p_max_ret_num IN NUMBER := NULL,
2290: x_offer_lst OUT NOCOPY JTF_NUMBER_TABLE,
2291: x_return_status OUT NOCOPY VARCHAR2,
2292: x_msg_count OUT NOCOPY NUMBER,
2293: x_msg_data OUT NOCOPY VARCHAR2
2294: )

Line 2299: l_prod_lst JTF_NUMBER_TABLE;

2295: IS
2296:
2297: l_api_name CONSTANT VARCHAR2(30) := 'getRelOffersForProdAndCust';
2298: l_api_version CONSTANT NUMBER := 1.0;
2299: l_prod_lst JTF_NUMBER_TABLE;
2300: l_bus_prior VARCHAR2(30) := NULL;
2301: --l_prod_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2302: --l_offer_tbl AMS_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;
2303: l_prod_tbl OZF_OFFR_ELIG_PROD_DENORM_PVT.num_tbl_type;

Line 2334: act_offer_lst JTF_Number_Table;

2330: k PLS_INTEGER := 1;
2331: pos PLS_INTEGER := 1;
2332: l_random NUMBER;
2333: l_found BOOLEAN := FALSE;
2334: act_offer_lst JTF_Number_Table;
2335: l_offer_lst JTF_Number_Table;
2336: l_offer_lst1 JTF_Number_Table;
2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;

Line 2335: l_offer_lst JTF_Number_Table;

2331: pos PLS_INTEGER := 1;
2332: l_random NUMBER;
2333: l_found BOOLEAN := FALSE;
2334: act_offer_lst JTF_Number_Table;
2335: l_offer_lst JTF_Number_Table;
2336: l_offer_lst1 JTF_Number_Table;
2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;
2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;

Line 2336: l_offer_lst1 JTF_Number_Table;

2332: l_random NUMBER;
2333: l_found BOOLEAN := FALSE;
2334: act_offer_lst JTF_Number_Table;
2335: l_offer_lst JTF_Number_Table;
2336: l_offer_lst1 JTF_Number_Table;
2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;
2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
2340: l_counter NUMBER := 0;

Line 2337: l_offer_lst2 JTF_Number_Table;

2333: l_found BOOLEAN := FALSE;
2334: act_offer_lst JTF_Number_Table;
2335: l_offer_lst JTF_Number_Table;
2336: l_offer_lst1 JTF_Number_Table;
2337: l_offer_lst2 JTF_Number_Table;
2338: l_validate_qp_list_header_id NUMBER;
2339: l_qp_rec_type_tbl AMS_RUNTIME_CAMP_PVT.qp_rec_type_tbl;
2340: l_counter NUMBER := 0;
2341: l_qp_rec_type AMS_RUNTIME_CAMP_PVT.qp_rec_type;

Line 2390: x_offer_lst := JTF_Number_Table();

2386: IF(p_bus_prior <> 'RANDOM') THEN
2387: l_bus_prior := p_bus_prior;
2388: END IF;
2389:
2390: x_offer_lst := JTF_Number_Table();
2391:
2392: IF (p_rel_type_code = 'PROMOTING') THEN
2393: l_prod_lst := p_prod_lst;
2394: ELSE

Line 2570: act_offer_lst := JTF_Number_Table();

2566: -- Got the Offers Now Display Priorities
2567:
2568:
2569: -- Initialize the return value table
2570: act_offer_lst := JTF_Number_Table();
2571: l_offer_lst1 := JTF_Number_Table();
2572: l_offer_lst2 := JTF_Number_Table();
2573:
2574: p_Index := x_offer_lst.FIRST;

Line 2571: l_offer_lst1 := JTF_Number_Table();

2567:
2568:
2569: -- Initialize the return value table
2570: act_offer_lst := JTF_Number_Table();
2571: l_offer_lst1 := JTF_Number_Table();
2572: l_offer_lst2 := JTF_Number_Table();
2573:
2574: p_Index := x_offer_lst.FIRST;
2575:

Line 2572: l_offer_lst2 := JTF_Number_Table();

2568:
2569: -- Initialize the return value table
2570: act_offer_lst := JTF_Number_Table();
2571: l_offer_lst1 := JTF_Number_Table();
2572: l_offer_lst2 := JTF_Number_Table();
2573:
2574: p_Index := x_offer_lst.FIRST;
2575:
2576: FOR pNum IN 1..( x_offer_lst.COUNT - 1 ) LOOP

Line 2625: act_offer_lst := JTF_Number_Table();

2621: OPEN l_offer_csr FOR l_offer_stmt ||
2622: l_offer_in_clause1 ;
2623: END IF;
2624:
2625: act_offer_lst := JTF_Number_Table();
2626:
2627:
2628: --ListPrice Order for ProductRelationship Offers
2629:

Line 2738: act_offer_lst := JTF_Number_Table();

2734: END LOOP;
2735:
2736: -- convert l_qp_rec_type_tbl to act_offer_list
2737:
2738: act_offer_lst := JTF_Number_Table();
2739: l_counter := 0;
2740:
2741: -- Convert Table to List
2742: