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

Line 8: p_num_tbl IN jtf_number_table

4: l_true VARCHAR2(1) := FND_API.G_TRUE;
5:
6: FUNCTION Find_Index(
7: p_id IN NUMBER,
8: p_num_tbl IN jtf_number_table
9: )
10: RETURN NUMBER
11: IS
12: l_index NUMBER := 0;

Line 29: p_id_tbl IN jtf_number_table,

25:
26:
27: FUNCTION Find_Index(
28: p_id IN NUMBER,
29: p_id_tbl IN jtf_number_table,
30: p_index_tbl IN jtf_number_table
31: )
32: RETURN NUMBER
33: IS

Line 30: p_index_tbl IN jtf_number_table

26:
27: FUNCTION Find_Index(
28: p_id IN NUMBER,
29: p_id_tbl IN jtf_number_table,
30: p_index_tbl IN jtf_number_table
31: )
32: RETURN NUMBER
33: IS
34: l_index NUMBER := 0;

Line 96: FUNCTION Get_Line_IDs_From_Headers(p_list_header_id_tbl IN jtf_number_table)

92: RETURN l_index;
93: END Find_Same_Item_In_Lst_Line_Tbl;
94:
95:
96: FUNCTION Get_Line_IDs_From_Headers(p_list_header_id_tbl IN jtf_number_table)
97: RETURN jtf_number_table
98: IS
99: TYPE Csr_Type IS REF CURSOR;
100: line_csr Csr_Type;

Line 97: RETURN jtf_number_table

93: END Find_Same_Item_In_Lst_Line_Tbl;
94:
95:
96: FUNCTION Get_Line_IDs_From_Headers(p_list_header_id_tbl IN jtf_number_table)
97: RETURN jtf_number_table
98: IS
99: TYPE Csr_Type IS REF CURSOR;
100: line_csr Csr_Type;
101: rel_line_csr Csr_Type;

Line 105: l_list_line_id_tbl jtf_number_table := jtf_number_table();

101: rel_line_csr Csr_Type;
102: l_line_id NUMBER;
103: l_rel_line_id NUMBER;
104: l_item_type_code VARCHAR2(30);
105: l_list_line_id_tbl jtf_number_table := jtf_number_table();
106: l_list_header_id NUMBER;
107: BEGIN
108: FOR i IN p_list_header_id_tbl.FIRST..p_list_header_id_tbl.LAST LOOP
109: l_list_header_id := p_list_header_id_tbl(i);

Line 155: p_list_line_id_tbl IN jtf_number_table,

151: * This also construct the out paramter x_qte_line_relation_tbl.
152: */
153: PROCEDURE Include_Related_Lines(
154: p_qte_line_rel_tbl IN VARCHAR2 ,
155: p_list_line_id_tbl IN jtf_number_table,
156: x_list_line_id_tbl OUT NOCOPY jtf_number_table,
157: x_qte_line_relation_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
158: x_list_line_relation_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type)
159: IS

Line 156: x_list_line_id_tbl OUT NOCOPY jtf_number_table,

152: */
153: PROCEDURE Include_Related_Lines(
154: p_qte_line_rel_tbl IN VARCHAR2 ,
155: p_list_line_id_tbl IN jtf_number_table,
156: x_list_line_id_tbl OUT NOCOPY jtf_number_table,
157: x_qte_line_relation_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
158: x_list_line_relation_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type)
159: IS
160: TYPE rel_line_csr_type IS REF CURSOR;

Line 167: x_list_line_id_tbl := jtf_number_table();

163: l_rel_line_id NUMBER;
164: l_relationship_type_code VARCHAR2(30);
165: k PLS_INTEGER := 1; -- index for x_qte_line_relation_tbl
166: BEGIN
167: x_list_line_id_tbl := jtf_number_table();
168:
169: FOR i IN p_list_line_id_tbl.FIRST..p_list_line_id_tbl.LAST LOOP
170: x_list_line_id_tbl.EXTEND;
171: x_list_line_id_tbl(x_list_line_id_tbl.LAST) := p_list_line_id_tbl(i);

Line 234: p_list_header_id_tbl IN jtf_number_table,

230: * procedure is called to create a list from lists.
231: */
232: PROCEDURE Get_Line_Rels_From_Lines(
233: p_to_create_quote IN BOOLEAN ,
234: p_list_header_id_tbl IN jtf_number_table,
235: p_list_line_id_tbl IN jtf_number_table,
236: p_line_index_tbl IN jtf_number_table,
237: x_qte_line_rel_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
238: x_list_line_rel_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type

Line 235: p_list_line_id_tbl IN jtf_number_table,

231: */
232: PROCEDURE Get_Line_Rels_From_Lines(
233: p_to_create_quote IN BOOLEAN ,
234: p_list_header_id_tbl IN jtf_number_table,
235: p_list_line_id_tbl IN jtf_number_table,
236: p_line_index_tbl IN jtf_number_table,
237: x_qte_line_rel_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
238: x_list_line_rel_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type
239: )

Line 236: p_line_index_tbl IN jtf_number_table,

232: PROCEDURE Get_Line_Rels_From_Lines(
233: p_to_create_quote IN BOOLEAN ,
234: p_list_header_id_tbl IN jtf_number_table,
235: p_list_line_id_tbl IN jtf_number_table,
236: p_line_index_tbl IN jtf_number_table,
237: x_qte_line_rel_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_Tbl_Type,
238: x_list_line_rel_tbl OUT NOCOPY SL_Line_Rel_Tbl_Type
239: )
240: IS

Line 296: p_list_line_id_tbl IN jtf_number_table ,

292: END Get_Line_Rels_From_Lines;
293:
294:
295: PROCEDURE Set_List_Lines_From_List_Lines(
296: p_list_line_id_tbl IN jtf_number_table ,
297: p_list_header_id IN NUMBER ,
298: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
299: x_list_line_tbl OUT NOCOPY IBE_Shop_List_PVT.SL_Line_Tbl_Type,
300: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,

Line 300: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,

296: p_list_line_id_tbl IN jtf_number_table ,
297: p_list_header_id IN NUMBER ,
298: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
299: x_list_line_tbl OUT NOCOPY IBE_Shop_List_PVT.SL_Line_Tbl_Type,
300: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
301: x_list_line_index_tbl OUT NOCOPY jtf_number_table
302: )
303: IS
304: TYPE Csr_Type IS REF CURSOR;

Line 301: x_list_line_index_tbl OUT NOCOPY jtf_number_table

297: p_list_header_id IN NUMBER ,
298: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
299: x_list_line_tbl OUT NOCOPY IBE_Shop_List_PVT.SL_Line_Tbl_Type,
300: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
301: x_list_line_index_tbl OUT NOCOPY jtf_number_table
302: )
303: IS
304: TYPE Csr_Type IS REF CURSOR;
305: l_csr Csr_Type;

Line 335: l_list_line_id_tbl jtf_number_table := jtf_number_table();

331: l_attribute14 VARCHAR2(150);
332: l_attribute15 VARCHAR2(150);
333:
334: l_list_line_id NUMBER;
335: l_list_line_id_tbl jtf_number_table := jtf_number_table();
336: i PLS_INTEGER := 1; -- index for x_qte_line_tbl
337: j PLS_INTEGER := 1; -- index for x_qte_line_detail_tbl
338: l_list_line_tbl_index PLS_INTEGER;
339: l_line_id NUMBER;

Line 344: x_list_line_id_map_tbl := jtf_number_table();

340: BEGIN
341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_Util.Debug('Set_List_Lines_From_List_Lines(+)...');
343: END IF;
344: x_list_line_id_map_tbl := jtf_number_table();
345: x_list_line_index_tbl := jtf_number_table();
346:
347: FOR k IN 1..p_list_line_id_tbl.COUNT LOOP
348: SELECT shp_list_item_id,

Line 345: x_list_line_index_tbl := jtf_number_table();

341: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
342: IBE_Util.Debug('Set_List_Lines_From_List_Lines(+)...');
343: END IF;
344: x_list_line_id_map_tbl := jtf_number_table();
345: x_list_line_index_tbl := jtf_number_table();
346:
347: FOR k IN 1..p_list_line_id_tbl.COUNT LOOP
348: SELECT shp_list_item_id,
349: inventory_item_id,

Line 531: p_shp_list_ids IN jtf_number_table,

527: END IF;
528: END Set_List_Lines_From_List_Lines;
529:
530: PROCEDURE Delete_Config_From_Shp_List(
531: p_shp_list_ids IN jtf_number_table,
532: p_shp_list_line_ids IN jtf_number_table,
533: p_usage_exists IN OUT NOCOPY NUMBER,
534: p_error_message IN OUT NOCOPY VARCHAR2,
535: p_return_value IN OUT NOCOPY NUMBER

Line 532: p_shp_list_line_ids IN jtf_number_table,

528: END Set_List_Lines_From_List_Lines;
529:
530: PROCEDURE Delete_Config_From_Shp_List(
531: p_shp_list_ids IN jtf_number_table,
532: p_shp_list_line_ids IN jtf_number_table,
533: p_usage_exists IN OUT NOCOPY NUMBER,
534: p_error_message IN OUT NOCOPY VARCHAR2,
535: p_return_value IN OUT NOCOPY NUMBER
536: )

Line 595: p_shop_list_ids IN jtf_number_table ,

591: p_commit IN VARCHAR2 := FND_API.G_FALSE,
592: x_return_status OUT NOCOPY VARCHAR2 ,
593: x_msg_count OUT NOCOPY NUMBER ,
594: x_msg_data OUT NOCOPY VARCHAR2 ,
595: p_shop_list_ids IN jtf_number_table ,
596: p_obj_ver_numbers IN jtf_number_table
597: )
598: IS
599: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete';

Line 596: p_obj_ver_numbers IN jtf_number_table

592: x_return_status OUT NOCOPY VARCHAR2 ,
593: x_msg_count OUT NOCOPY NUMBER ,
594: x_msg_data OUT NOCOPY VARCHAR2 ,
595: p_shop_list_ids IN jtf_number_table ,
596: p_obj_ver_numbers IN jtf_number_table
597: )
598: IS
599: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete';
600: L_API_VERSION CONSTANT NUMBER := 1.0;

Line 745: p_shop_list_ids IN jtf_number_table ,

741: p_commit IN VARCHAR2 := FND_API.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2 ,
743: x_msg_count OUT NOCOPY NUMBER ,
744: x_msg_data OUT NOCOPY VARCHAR2 ,
745: p_shop_list_ids IN jtf_number_table ,
746: p_obj_ver_numbers IN jtf_number_table
747: )
748: IS
749: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_All_Lines';

Line 746: p_obj_ver_numbers IN jtf_number_table

742: x_return_status OUT NOCOPY VARCHAR2 ,
743: x_msg_count OUT NOCOPY NUMBER ,
744: x_msg_data OUT NOCOPY VARCHAR2 ,
745: p_shop_list_ids IN jtf_number_table ,
746: p_obj_ver_numbers IN jtf_number_table
747: )
748: IS
749: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_All_Lines';
750: L_API_VERSION CONSTANT NUMBER := 1.0;

Line 895: l_shp_list_item_id_tbl jtf_number_table;

891: p_object_version_number IN NUMBER,
892: p_Shp_List_Item_Id IN NUMBER
893: )
894: IS
895: l_shp_list_item_id_tbl jtf_number_table;
896: l_index NUMBER;
897: l_count NUMBER;
898: l_shp_list_item_id NUMBER;
899: l_shop_list_rel_line_id NUMBER;

Line 919: l_shp_list_item_id_tbl := jtf_number_table();

915: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
916: IBE_Util.Debug('IBE_Shop_List_PVT.Delete_Line(+)...');
917: END IF;
918:
919: l_shp_list_item_id_tbl := jtf_number_table();
920:
921: SELECT COUNT(*) into l_count
922: FROM IBE_SH_SHLITEM_RELS
923: WHERE SHP_LIST_ITEM_ID = p_Shp_List_Item_Id;

Line 978: p_shop_list_line_ids IN jtf_number_table ,

974: p_commit IN VARCHAR2 := FND_API.G_FALSE,
975: x_return_status OUT NOCOPY VARCHAR2 ,
976: x_msg_count OUT NOCOPY NUMBER ,
977: x_msg_data OUT NOCOPY VARCHAR2 ,
978: p_shop_list_line_ids IN jtf_number_table ,
979: p_obj_ver_numbers IN jtf_number_table
980: )
981: IS
982: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Lines';

Line 979: p_obj_ver_numbers IN jtf_number_table

975: x_return_status OUT NOCOPY VARCHAR2 ,
976: x_msg_count OUT NOCOPY NUMBER ,
977: x_msg_data OUT NOCOPY VARCHAR2 ,
978: p_shop_list_line_ids IN jtf_number_table ,
979: p_obj_ver_numbers IN jtf_number_table
980: )
981: IS
982: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Lines';
983: L_API_VERSION CONSTANT NUMBER := 1.0;

Line 1621: p_sl_line_ids IN jtf_number_table ,

1617: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1618: x_return_status OUT NOCOPY VARCHAR2 ,
1619: x_msg_count OUT NOCOPY NUMBER ,
1620: x_msg_data OUT NOCOPY VARCHAR2 ,
1621: p_sl_line_ids IN jtf_number_table ,
1622: p_sl_line_ovns IN jtf_number_table := NULL ,
1623: p_mode IN VARCHAR2 := 'MERGE' ,
1624: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1625: p_sl_header_rec IN SL_Header_Rec_Type ,

Line 1622: p_sl_line_ovns IN jtf_number_table := NULL ,

1618: x_return_status OUT NOCOPY VARCHAR2 ,
1619: x_msg_count OUT NOCOPY NUMBER ,
1620: x_msg_data OUT NOCOPY VARCHAR2 ,
1621: p_sl_line_ids IN jtf_number_table ,
1622: p_sl_line_ovns IN jtf_number_table := NULL ,
1623: p_mode IN VARCHAR2 := 'MERGE' ,
1624: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
1625: p_sl_header_rec IN SL_Header_Rec_Type ,
1626: x_sl_header_id OUT NOCOPY NUMBER

Line 1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();

1629: L_API_NAME CONSTANT VARCHAR2(30) := 'Save_List_From_Items';
1630: L_API_VERSION CONSTANT NUMBER := 1.0;
1631: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
1632:
1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();
1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();
1635: l_list_header_id_tbl jtf_number_table;
1636: l_obj_ver_num_tbl jtf_number_table;
1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();

Line 1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();

1630: L_API_VERSION CONSTANT NUMBER := 1.0;
1631: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
1632:
1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();
1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();
1635: l_list_header_id_tbl jtf_number_table;
1636: l_obj_ver_num_tbl jtf_number_table;
1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();
1638: l_sl_header_rec SL_Header_Rec_Type;

Line 1635: l_list_header_id_tbl jtf_number_table;

1631: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
1632:
1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();
1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();
1635: l_list_header_id_tbl jtf_number_table;
1636: l_obj_ver_num_tbl jtf_number_table;
1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();
1638: l_sl_header_rec SL_Header_Rec_Type;
1639: l_sl_line_tbl SL_Line_Tbl_Type;

Line 1636: l_obj_ver_num_tbl jtf_number_table;

1632:
1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();
1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();
1635: l_list_header_id_tbl jtf_number_table;
1636: l_obj_ver_num_tbl jtf_number_table;
1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();
1638: l_sl_header_rec SL_Header_Rec_Type;
1639: l_sl_line_tbl SL_Line_Tbl_Type;
1640: l_sl_line_rel_tbl SL_Line_Rel_Tbl_Type;

Line 1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();

1633: l_list_line_id_map_tbl jtf_number_table := jtf_number_table();
1634: l_list_line_index_tbl jtf_number_table := jtf_number_table();
1635: l_list_header_id_tbl jtf_number_table;
1636: l_obj_ver_num_tbl jtf_number_table;
1637: l_list_line_id_tbl jtf_number_table := jtf_number_table();
1638: l_sl_header_rec SL_Header_Rec_Type;
1639: l_sl_line_tbl SL_Line_Tbl_Type;
1640: l_sl_line_rel_tbl SL_Line_Rel_Tbl_Type;
1641: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line 1677: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines

1673: l_sl_header_rec := p_sl_header_rec;
1674:
1675: IF (l_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1676: IF (p_mode = 'REPLACE') THEN
1677: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1678: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1679: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1680:
1681: IBE_Shop_List_PVT.Delete_All_Lines(

Line 1678: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);

1674:
1675: IF (l_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1676: IF (p_mode = 'REPLACE') THEN
1677: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1678: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1679: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1680:
1681: IBE_Shop_List_PVT.Delete_All_Lines(
1682: p_api_version => p_api_version,

Line 1679: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);

1675: IF (l_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1676: IF (p_mode = 'REPLACE') THEN
1677: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1678: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1679: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1680:
1681: IBE_Shop_List_PVT.Delete_All_Lines(
1682: p_api_version => p_api_version,
1683: p_init_msg_list => p_init_msg_list,

Line 1879: l_list_header_id_tbl jtf_number_table;

1875:
1876: i NUMBER := 1; -- index for l_sl_line_tbl
1877: j NUMBER := 1; -- index for l_sl_line_rel_tbl
1878:
1879: l_list_header_id_tbl jtf_number_table;
1880: l_obj_ver_num_tbl jtf_number_table;
1881:
1882: l_quote_line_id NUMBER;
1883: l_inventory_item_id NUMBER;

Line 1880: l_obj_ver_num_tbl jtf_number_table;

1876: i NUMBER := 1; -- index for l_sl_line_tbl
1877: j NUMBER := 1; -- index for l_sl_line_rel_tbl
1878:
1879: l_list_header_id_tbl jtf_number_table;
1880: l_obj_ver_num_tbl jtf_number_table;
1881:
1882: l_quote_line_id NUMBER;
1883: l_inventory_item_id NUMBER;
1884: l_quantity NUMBER;

Line 1911: l_quote_line_id_tbl jtf_number_table := jtf_number_table();

1907: l_attribute14 VARCHAR2(150);
1908: l_attribute15 VARCHAR2(150);
1909: l_pricing_line_type_indicator VARCHAR2(3);
1910:
1911: l_quote_line_id_tbl jtf_number_table := jtf_number_table();
1912: l_quote_line_index_tbl jtf_number_table := jtf_number_table();
1913:
1914: l_related_quote_line_id NUMBER;
1915: l_relationship_type_code VARCHAR2(30);

Line 1912: l_quote_line_index_tbl jtf_number_table := jtf_number_table();

1908: l_attribute15 VARCHAR2(150);
1909: l_pricing_line_type_indicator VARCHAR2(3);
1910:
1911: l_quote_line_id_tbl jtf_number_table := jtf_number_table();
1912: l_quote_line_index_tbl jtf_number_table := jtf_number_table();
1913:
1914: l_related_quote_line_id NUMBER;
1915: l_relationship_type_code VARCHAR2(30);
1916:

Line 1917: l_PRG_configHdrId_tbl jtf_number_table := jtf_number_table();

1913:
1914: l_related_quote_line_id NUMBER;
1915: l_relationship_type_code VARCHAR2(30);
1916:
1917: l_PRG_configHdrId_tbl jtf_number_table := jtf_number_table();
1918: l_PRGchildren_lineId_tbl jtf_number_table := jtf_number_table();
1919: l_checkPRGChild NUMBER := 0;
1920:
1921: BEGIN

Line 1918: l_PRGchildren_lineId_tbl jtf_number_table := jtf_number_table();

1914: l_related_quote_line_id NUMBER;
1915: l_relationship_type_code VARCHAR2(30);
1916:
1917: l_PRG_configHdrId_tbl jtf_number_table := jtf_number_table();
1918: l_PRGchildren_lineId_tbl jtf_number_table := jtf_number_table();
1919: l_checkPRGChild NUMBER := 0;
1920:
1921: BEGIN
1922: -- Standard Start of API savepoint

Line 1975: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines

1971: l_sl_header_rec := p_sl_header_rec;
1972:
1973: IF (p_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1974: IF (p_mode = 'REPLACE') THEN
1975: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1976: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1977: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1978:
1979: IBE_Shop_List_PVT.Delete_All_Lines(

Line 1976: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);

1972:
1973: IF (p_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1974: IF (p_mode = 'REPLACE') THEN
1975: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1976: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1977: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1978:
1979: IBE_Shop_List_PVT.Delete_All_Lines(
1980: p_api_version => p_api_version,

Line 1977: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);

1973: IF (p_sl_header_rec.shp_list_id <> FND_API.G_MISS_NUM) THEN
1974: IF (p_mode = 'REPLACE') THEN
1975: -- create jtf_number_table of list id and obj. ver num to pass to Delete_All_Lines
1976: l_list_header_id_tbl := jtf_number_table(l_sl_header_rec.shp_list_id);
1977: l_obj_ver_num_tbl := jtf_number_table(l_sl_header_rec.object_version_number);
1978:
1979: IBE_Shop_List_PVT.Delete_All_Lines(
1980: p_api_version => p_api_version,
1981: p_init_msg_list => p_init_msg_list,

Line 2341: p_list_line_id_tbl IN jtf_number_table ,

2337: p_data => x_msg_data);
2338: END Save_List_From_Quote;
2339:
2340: PROCEDURE Set_Qte_Lines_From_List_Lines(
2341: p_list_line_id_tbl IN jtf_number_table ,
2342: p_quote_header_id IN NUMBER ,
2343: p_price_list_id IN NUMBER ,
2344: p_currency_code IN VARCHAR2 ,
2345: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,

Line 2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,

2345: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
2346: p_minisite_id IN NUMBER := FND_API.G_MISS_CHAR ,
2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,
2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,
2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,
2352: x_contMDL OUT NOCOPY VARCHAR2
2353: )

Line 2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,

2346: p_minisite_id IN NUMBER := FND_API.G_MISS_CHAR ,
2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,
2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,
2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,
2352: x_contMDL OUT NOCOPY VARCHAR2
2353: )
2354: IS

Line 2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,

2347: x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Tbl_Type ,
2348: x_qte_line_detail_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type,
2349: x_list_line_id_map_tbl OUT NOCOPY jtf_number_table ,
2350: x_qte_line_index_tbl OUT NOCOPY jtf_number_table ,
2351: x_ql_line_codes OUT NOCOPY jtf_number_table ,
2352: x_contMDL OUT NOCOPY VARCHAR2
2353: )
2354: IS
2355: TYPE Csr_Type IS REF CURSOR;

Line 2386: l_list_line_id_tbl jtf_number_table := jtf_number_table();

2382: l_attribute14 VARCHAR2(150);
2383: l_attribute15 VARCHAR2(150);
2384:
2385: l_quote_line_id NUMBER;
2386: l_list_line_id_tbl jtf_number_table := jtf_number_table();
2387: i PLS_INTEGER := 1; -- index for x_qte_line_tbl
2388: j PLS_INTEGER := 1; -- index for x_qte_line_detail_tbl
2389: l_qte_line_tbl_index PLS_INTEGER;
2390: l_line_id NUMBER;

Line 2397: x_list_line_id_map_tbl := jtf_number_table();

2393: BEGIN
2394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2395: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(+)...');
2396: END IF;
2397: x_list_line_id_map_tbl := jtf_number_table();
2398: x_qte_line_index_tbl := jtf_number_table();
2399:
2400: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2401: x_ql_line_codes := jtf_number_table();

Line 2398: x_qte_line_index_tbl := jtf_number_table();

2394: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
2395: IBE_Util.Debug('Set_Qte_Lines_From_List_Lines(+)...');
2396: END IF;
2397: x_list_line_id_map_tbl := jtf_number_table();
2398: x_qte_line_index_tbl := jtf_number_table();
2399:
2400: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2401: x_ql_line_codes := jtf_number_table();
2402:

Line 2401: x_ql_line_codes := jtf_number_table();

2397: x_list_line_id_map_tbl := jtf_number_table();
2398: x_qte_line_index_tbl := jtf_number_table();
2399:
2400: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2401: x_ql_line_codes := jtf_number_table();
2402:
2403: -- added on 5/30/03: SBM -- for checking to see if the cart has a MDL item
2404: x_contMDL := 'N';
2405: FOR k IN 1..p_list_line_id_tbl.COUNT LOOP

Line 2678: p_sl_line_ids IN jtf_number_table ,

2674: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
2675: x_return_status OUT NOCOPY VARCHAR2 ,
2676: x_msg_count OUT NOCOPY NUMBER ,
2677: x_msg_data OUT NOCOPY VARCHAR2 ,
2678: p_sl_line_ids IN jtf_number_table ,
2679: p_sl_line_ovns IN jtf_number_table := NULL ,
2680: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
2681: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
2682: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 2679: p_sl_line_ovns IN jtf_number_table := NULL ,

2675: x_return_status OUT NOCOPY VARCHAR2 ,
2676: x_msg_count OUT NOCOPY NUMBER ,
2677: x_msg_data OUT NOCOPY VARCHAR2 ,
2678: p_sl_line_ids IN jtf_number_table ,
2679: p_sl_line_ovns IN jtf_number_table := NULL ,
2680: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
2681: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
2682: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
2683: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 2701: l_list_line_id_tbl jtf_number_table;

2697: L_API_NAME CONSTANT VARCHAR2(30) := 'Save_Quote_From_List_Items';
2698: L_API_VERSION CONSTANT NUMBER := 1.0;
2699: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
2700:
2701: l_list_line_id_tbl jtf_number_table;
2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;

Line 2702: l_list_line_id_map_tbl jtf_number_table;

2698: L_API_VERSION CONSTANT NUMBER := 1.0;
2699: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
2700:
2701: l_list_line_id_tbl jtf_number_table;
2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;

Line 2703: l_qte_line_index_tbl jtf_number_table;

2699: L_USER_ID CONSTANT NUMBER := FND_GLOBAL.User_ID;
2700:
2701: l_list_line_id_tbl jtf_number_table;
2702: l_list_line_id_map_tbl jtf_number_table;
2703: l_qte_line_index_tbl jtf_number_table;
2704: l_qte_line_tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2705: l_qte_line_detail_tbl ASO_Quote_Pub.Qte_Line_Dtl_Tbl_Type;
2706: l_qte_line_relation_tbl ASO_Quote_Pub.Line_Rltship_Tbl_Type;
2707: l_list_line_relation_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type;

Line 2712: l_ql_line_codes jtf_number_table;

2708: lx_quote_header_id NUMBER;
2709: lx_last_update_date DATE;
2710:
2711: -- add 3/26/03: to be used for ibe_quote_save_pvt.save api
2712: l_ql_line_codes jtf_number_table;
2713: lx_Qte_Line_Tbl ASO_Quote_Pub.Qte_Line_Tbl_Type;
2714:
2715: -- added on 5/21/03: SBM --
2716: l_qte_line_detail_indx number;