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_WRAPPER_PVT dependencies on FND_API

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

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'IBE_Shop_List_Wrapper_PVT';
5:
6: PROCEDURE Save(
7: p_api_version IN NUMBER := 1 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,

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

5:
6: PROCEDURE Save(
7: p_api_version IN NUMBER := 1 ,
8: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

9: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

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

11: x_msg_count OUT NOCOPY NUMBER ,
12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,

12: x_msg_data OUT NOCOPY VARCHAR2 ,
13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

13: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

14: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

15: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

16: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

Line 21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

17: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

18: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

19: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

20: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

21: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

22: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

23: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

24: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

25: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

27: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

28: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

29: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

30: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

31: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

32: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

33: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

34: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

35: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

36: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

37: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

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

38: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,

Line 43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

39: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,

Line 44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

40: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,

Line 45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

41: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
42: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
43: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
44: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
45: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
46: p_l_shp_list_item_id IN jtf_number_table := NULL ,
47: p_l_object_version_number IN jtf_number_table := NULL ,
48: p_l_creation_date IN jtf_date_table := NULL ,
49: p_l_created_by IN jtf_number_table := NULL ,

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

102:
103:
104: PROCEDURE Save_List_From_Items(
105: p_api_version IN NUMBER := 1 ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,

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

103:
104: PROCEDURE Save_List_From_Items(
105: p_api_version IN NUMBER := 1 ,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
108: x_return_status OUT NOCOPY VARCHAR2 ,
109: x_msg_count OUT NOCOPY NUMBER ,
110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,

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

110: x_msg_data OUT NOCOPY VARCHAR2 ,
111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

111: p_sl_line_ids IN jtf_number_table ,
112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

112: p_sl_line_ovns IN jtf_number_table := NULL ,
113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,

113: p_mode IN VARCHAR2 := 'MERGE' ,
114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

114: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

115: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

116: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

117: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

Line 122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

118: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

119: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

120: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

121: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

122: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

123: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

124: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

125: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

126: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

127: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

128: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

129: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

130: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

131: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

132: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

133: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

134: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

135: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

136: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

137: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

138: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

139: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
147: x_sl_header_id OUT NOCOPY NUMBER

Line 144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

140: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
147: x_sl_header_id OUT NOCOPY NUMBER
148: );

Line 145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

141: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
147: x_sl_header_id OUT NOCOPY NUMBER
148: );
149:

Line 146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

142: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
143: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
144: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
145: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
146: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
147: x_sl_header_id OUT NOCOPY NUMBER
148: );
149:
150:

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

149:
150:
151: PROCEDURE Save_List_From_Quote(
152: p_api_version IN NUMBER := 1 ,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,

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

150:
151: PROCEDURE Save_List_From_Quote(
152: p_api_version IN NUMBER := 1 ,
153: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
154: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: p_quote_header_id IN NUMBER ,

Line 159: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,

155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: p_quote_header_id IN NUMBER ,
159: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
160: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: p_quote_header_id IN NUMBER ,
159: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
160: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

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

157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: p_quote_header_id IN NUMBER ,
159: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
160: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

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

159: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
160: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,

160: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

161: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,

162: p_mode IN VARCHAR2 := 'MERGE' ,
163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

163: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

164: p_h_shp_list_id IN NUMBER := FND_API.G_MISS_NUM ,
165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,

165: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

166: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

Line 171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

167: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

168: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

169: p_h_object_version_number IN NUMBER := FND_API.G_MISS_NUM ,
170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

170: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

171: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

172: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

173: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,

174: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

175: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

176: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

177: p_h_shopping_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

178: p_h_description IN VARCHAR2 := FND_API.G_MISS_CHAR,
179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

179: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

180: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

181: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

182: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

183: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

184: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

185: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

186: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

187: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

188: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
196: x_sl_header_id OUT NOCOPY NUMBER

Line 193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

189: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
196: x_sl_header_id OUT NOCOPY NUMBER
197: );

Line 194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

190: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
196: x_sl_header_id OUT NOCOPY NUMBER
197: );
198:

Line 195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

191: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
192: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
193: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
194: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
195: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
196: x_sl_header_id OUT NOCOPY NUMBER
197: );
198:
199:

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

198:
199:
200: PROCEDURE Save_Quote_From_List_Items(
201: p_api_version IN NUMBER := 1 ,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,

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

199:
200: PROCEDURE Save_Quote_From_List_Items(
201: p_api_version IN NUMBER := 1 ,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
204: x_return_status OUT NOCOPY VARCHAR2 ,
205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,

Line 209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,

205: x_msg_count OUT NOCOPY NUMBER ,
206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,

Line 210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,

206: x_msg_data OUT NOCOPY VARCHAR2 ,
207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

207: p_sl_line_ids IN jtf_number_table ,
208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,

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

208: p_sl_line_ovns IN jtf_number_table := NULL ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

210: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,

211: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

212: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

213: p_mode IN VARCHAR2 := 'MERGE' ,
214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

214: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing

Line 219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,

215: p_c_last_update_date IN DATE := FND_API.G_MISS_DATE,
216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

216: p_c_auto_version_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

Line 221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

217: p_c_pricing_request_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
218: p_c_header_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

Line 223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,

219: p_c_line_pricing_event IN VARCHAR2 := FND_API.G_MISS_CHAR,
220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

Line 224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,

220: p_c_cal_tax_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

Line 225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,

221: p_c_cal_freight_charge_flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,

222: p_c_price_mode IN VARCHAR2 := 'ENTIRE_QUOTE' , -- change line logic pricing
223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,

223: p_h_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,

224: p_h_creation_date IN DATE := FND_API.G_MISS_DATE,
225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

Line 229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,

225: p_h_created_by IN NUMBER := FND_API.G_MISS_NUM ,
226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,

226: p_h_last_updated_by IN NUMBER := FND_API.G_MISS_NUM ,
227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,

227: p_h_last_update_date IN DATE := FND_API.G_MISS_DATE,
228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,

228: p_h_last_update_login IN NUMBER := FND_API.G_MISS_NUM ,
229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,

Line 233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,

229: p_h_request_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

230: p_h_program_application_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,

231: p_h_program_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

Line 236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,

232: p_h_program_update_date IN DATE := FND_API.G_MISS_DATE,
233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

Line 237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,

233: p_h_org_id IN NUMBER := FND_API.G_MISS_NUM ,
234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

234: p_h_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,

235: p_h_quote_number IN NUMBER := FND_API.G_MISS_NUM ,
236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,

236: p_h_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

237: p_h_quote_status_id IN NUMBER := FND_API.G_MISS_NUM ,
238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,

238: p_h_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,

239: p_h_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,

240: p_h_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,

241: p_h_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

242: p_h_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,

243: p_h_party_id IN NUMBER := FND_API.G_MISS_NUM ,
244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

244: p_h_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

245: p_h_org_contact_id IN NUMBER := FND_API.G_MISS_NUM ,
246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing

Line 250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

246: p_h_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,

247: p_h_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,

248: p_h_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing

249: p_h_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,

Line 254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,

250: p_h_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,

Line 255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

251: p_h_phone_id IN NUMBER := FND_API.G_MISS_NUM ,
252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,

Line 256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

252: p_h_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,

Line 257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,

253: p_h_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR, -- change line logic pricing
254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,

Line 258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,

254: p_h_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,

Line 259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,

255: p_h_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,

Line 260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,

256: p_h_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,

Line 261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,

257: p_h_total_list_price IN NUMBER := FND_API.G_MISS_NUM ,
258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,

258: p_h_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM ,
259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,

Line 263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,

259: p_h_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM ,
260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,

260: p_h_total_tax IN NUMBER := FND_API.G_MISS_NUM ,
261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

Line 265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,

261: p_h_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM ,
262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,

262: p_h_surcharge IN NUMBER := FND_API.G_MISS_NUM ,
263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

263: p_h_total_quote_price IN NUMBER := FND_API.G_MISS_NUM ,
264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,

264: p_h_payment_amount IN NUMBER := FND_API.G_MISS_NUM ,
265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

265: p_h_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

266: p_h_exchange_rate IN NUMBER := FND_API.G_MISS_NUM ,
267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,

267: p_h_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,

268: p_h_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

269: p_h_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

270: p_h_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,

271: p_h_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

272: p_h_employee_person_id IN NUMBER := FND_API.G_MISS_NUM ,
273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,

273: p_h_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,

274: -- p_h_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,

275: p_h_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,

276: p_h_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,

277: p_h_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,

278: p_h_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

279: p_h_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

280: p_h_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

281: p_h_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,

282: p_h_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,

283: p_h_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,

284: p_h_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,

285: p_h_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,

286: p_h_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,

287: p_h_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,

288: p_h_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,

289: p_h_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,

290: p_h_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,

291: p_h_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,

292: p_h_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM ,
293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,

293: p_h_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM ,
294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,

294: p_h_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

295: p_h_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

296: p_h_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

297: p_h_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

298: p_h_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,

299: p_h_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,

300: p_h_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,

301: p_h_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

302: p_h_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,

303: p_h_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

304: p_h_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,

305: p_h_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM ,
306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,

306: p_h_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,

307: p_h_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM ,
308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,

308: p_h_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,

309: p_h_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

310: p_h_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,

Line 315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,

311: p_h_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM ,
312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,

312: p_h_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,

Line 317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,

313: p_h_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,

Line 318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,

314: p_h_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,

315: p_h_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM ,
316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,

Line 320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,

316: p_h_order_type_id IN NUMBER := FND_API.G_MISS_NUM ,
317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,

Line 321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,

317: p_h_order_id IN NUMBER := FND_API.G_MISS_NUM ,
318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,
325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

318: p_h_order_number IN NUMBER := FND_API.G_MISS_NUM ,
319: p_h_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
320: p_h_ordered_date IN DATE := FND_API.G_MISS_DATE,
321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,
325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,

321: p_h_resource_id IN NUMBER := FND_API.G_MISS_NUM ,
322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,
325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: x_q_header_id OUT NOCOPY NUMBER
329: );

Line 326: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,

322: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,
325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: x_q_header_id OUT NOCOPY NUMBER
329: );
330:

Line 327: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR,

323: p_email_address IN jtf_varchar2_table_2000 := NULL,
324: p_privilege_type IN jtf_varchar2_table_100 := NULL,
325: p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
326: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR,
327: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR,
328: x_q_header_id OUT NOCOPY NUMBER
329: );
330:
331: END IBE_Shop_List_Wrapper_PVT;