DBA Data[Home] [Help]

APPS.IBE_SHOP_LIST_MGMT_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

2: /* $Header: IBEVQOCSLS.pls 120.1 2010/11/19 08:39:17 amaheshw noship $ */
3:
4: PROCEDURE Save_New_ShopList(
5: p_api_version IN NUMBER := 1 ,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8: x_return_status OUT NOCOPY VARCHAR2 ,
9: x_msg_count OUT NOCOPY NUMBER ,
10: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

3:
4: PROCEDURE Save_New_ShopList(
5: p_api_version IN NUMBER := 1 ,
6: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
7: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
8: x_return_status OUT NOCOPY VARCHAR2 ,
9: x_msg_count OUT NOCOPY NUMBER ,
10: x_msg_data OUT NOCOPY VARCHAR2 ,
11: p_inventory_item_id IN JTF_Number_Table ,

Line 15: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

11: p_inventory_item_id IN JTF_Number_Table ,
12: p_org_id IN NUMBER ,
13: p_qty IN NUMBER ,
14: p_uom IN JTF_Varchar2_Table_100 ,
15: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
17: p_mode IN VARCHAR2 := 'MERGE' ,
18: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,

Line 16: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

12: p_org_id IN NUMBER ,
13: p_qty IN NUMBER ,
14: p_uom IN JTF_Varchar2_Table_100 ,
15: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
17: p_mode IN VARCHAR2 := 'MERGE' ,
18: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
19: p_sl_header_rec IN IBE_Shop_List_PVT.SL_Header_Rec_Type ,
20: x_sl_header_id OUT NOCOPY NUMBER ,

Line 18: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

Line 26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

22: );
23:
24: PROCEDURE Save_New_ShopList(
25: p_api_version IN NUMBER := 1 ,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
28: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,
30: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 27: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

23:
24: PROCEDURE Save_New_ShopList(
25: p_api_version IN NUMBER := 1 ,
26: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
28: x_return_status OUT NOCOPY VARCHAR2 ,
29: x_msg_count OUT NOCOPY NUMBER ,
30: x_msg_data OUT NOCOPY VARCHAR2 ,
31: p_inventory_item_id IN JTF_Number_Table ,

Line 35: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

31: p_inventory_item_id IN JTF_Number_Table ,
32: p_org_id IN NUMBER ,
33: p_qty IN NUMBER ,
34: p_uom IN JTF_Varchar2_Table_100 ,
35: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
36: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
37: p_mode IN VARCHAR2 := 'MERGE' ,
38: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_party_id IN NUMBER ,

Line 36: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

32: p_org_id IN NUMBER ,
33: p_qty IN NUMBER ,
34: p_uom IN JTF_Varchar2_Table_100 ,
35: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
36: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
37: p_mode IN VARCHAR2 := 'MERGE' ,
38: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_party_id IN NUMBER ,
40: p_cust_account_id IN NUMBER ,

Line 38: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

34: p_uom IN JTF_Varchar2_Table_100 ,
35: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
36: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
37: p_mode IN VARCHAR2 := 'MERGE' ,
38: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_party_id IN NUMBER ,
40: p_cust_account_id IN NUMBER ,
41: p_shopping_list_name IN VARCHAR2 ,
42: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 42: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

38: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_party_id IN NUMBER ,
40: p_cust_account_id IN NUMBER ,
41: p_shopping_list_name IN VARCHAR2 ,
42: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
43:
44: x_sl_header_id OUT NOCOPY NUMBER ,
45: p_item_type_code IN JTF_Varchar2_Table_100
46: );

Line 50: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

46: );
47:
48: PROCEDURE Add_Item_to_ShopList(
49: p_api_version IN NUMBER := 1 ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: x_msg_count OUT NOCOPY NUMBER ,
54: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 51: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

47:
48: PROCEDURE Add_Item_to_ShopList(
49: p_api_version IN NUMBER := 1 ,
50: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
51: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52: x_return_status OUT NOCOPY VARCHAR2 ,
53: x_msg_count OUT NOCOPY NUMBER ,
54: x_msg_data OUT NOCOPY VARCHAR2 ,
55: p_inventory_item_id IN JTF_Number_Table ,

Line 59: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,

55: p_inventory_item_id IN JTF_Number_Table ,
56: p_org_id IN NUMBER ,
57: p_qty IN NUMBER ,
58: p_uom IN JTF_Varchar2_Table_100 ,
59: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
60: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
61: p_mode IN VARCHAR2 := 'MERGE' ,
62: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_party_id IN NUMBER ,

Line 60: p_last_update_date IN DATE := FND_API.G_MISS_DATE,

56: p_org_id IN NUMBER ,
57: p_qty IN NUMBER ,
58: p_uom IN JTF_Varchar2_Table_100 ,
59: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
60: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
61: p_mode IN VARCHAR2 := 'MERGE' ,
62: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_party_id IN NUMBER ,
64: p_cust_account_id IN NUMBER ,

Line 62: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

58: p_uom IN JTF_Varchar2_Table_100 ,
59: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
60: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
61: p_mode IN VARCHAR2 := 'MERGE' ,
62: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_party_id IN NUMBER ,
64: p_cust_account_id IN NUMBER ,
65: p_shopping_list_name IN VARCHAR2 ,
66: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 66: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

62: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
63: p_party_id IN NUMBER ,
64: p_cust_account_id IN NUMBER ,
65: p_shopping_list_name IN VARCHAR2 ,
66: p_list_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
67:
68: x_sl_header_id OUT NOCOPY NUMBER ,
69: p_shp_list_id IN NUMBER ,
70: p_item_type_code IN JTF_Varchar2_Table_100