DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_MGMT_PVT dependencies on IBE_SHOP_LIST_PVT

Line 18: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,

14: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
16: p_mode IN VARCHAR2 := 'MERGE' ,
17: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
18: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,
19: x_sl_header_id OUT NOCOPY NUMBER ,
20: p_item_type_code IN JTF_Varchar2_Table_100
21: ) IS
22:

Line 23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type

19: x_sl_header_id OUT NOCOPY NUMBER ,
20: p_item_type_code IN JTF_Varchar2_Table_100
21: ) IS
22:
23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
25: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
26: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
27: L_ORG_ID CONSTANT NUMBER := FND_Profile.Value('ORG_ID');

Line 24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;

20: p_item_type_code IN JTF_Varchar2_Table_100
21: ) IS
22:
23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
25: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
26: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
27: L_ORG_ID CONSTANT NUMBER := FND_Profile.Value('ORG_ID');
28: BEGIN

Line 25: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type

21: ) IS
22:
23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
25: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
26: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
27: L_ORG_ID CONSTANT NUMBER := FND_Profile.Value('ORG_ID');
28: BEGIN
29: FOR i IN 1..p_inventory_item_id.COUNT LOOP

Line 26: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;

22:
23: l_sl_line_tbl IBE_Shop_List_PVT.SL_Line_Tbl_Type
24: := IBE_Shop_List_PVT.G_MISS_SL_LINE_TBL;
25: l_sl_line_rel_tbl IBE_Shop_List_PVT.SL_Line_Rel_Tbl_Type
26: := IBE_Shop_List_PVT.G_MISS_SL_LINE_REL_TBL;
27: L_ORG_ID CONSTANT NUMBER := FND_Profile.Value('ORG_ID');
28: BEGIN
29: FOR i IN 1..p_inventory_item_id.COUNT LOOP
30: BEGIN

Line 43: IBE_Shop_List_PVT.Save(

39: NULL;
40: END;
41: END LOOP;
42:
43: IBE_Shop_List_PVT.Save(
44: p_api_version => p_api_version,
45: p_init_msg_list => p_init_msg_list,
46: p_commit => p_commit,
47: x_return_status => x_return_status,

Line 82: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;

78:
79: x_sl_header_id OUT NOCOPY NUMBER ,
80: p_item_type_code IN JTF_Varchar2_Table_100
81: ) IS
82: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;
83:
84:
85: BEGIN
86:

Line 140: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;

136: p_shp_list_id IN NUMBER ,
137: p_item_type_code IN JTF_Varchar2_Table_100
138:
139: ) IS
140: p_sl_header_rec IBE_Shop_List_PVT.SL_Header_Rec_Type := IBE_Shop_List_PVT.G_MISS_SL_HEADER_REC;
141:
142:
143: BEGIN
144: