APPS.IBE_SHOP_LIST_PVT dependencies on FND_API

Line 10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,

6: /*
7: * Types declaration for Shopping List Header
8: */
9: TYPE SL_Header_Rec_Type IS RECORD(
10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,

Line 11: request_id NUMBER := FND_API.G_MISS_NUM ,

7: * Types declaration for Shopping List Header
8: */
9: TYPE SL_Header_Rec_Type IS RECORD(
10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,

Line 12: program_application_id NUMBER := FND_API.G_MISS_NUM ,

8: */
9: TYPE SL_Header_Rec_Type IS RECORD(
10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,

Line 13: program_id NUMBER := FND_API.G_MISS_NUM ,

9: TYPE SL_Header_Rec_Type IS RECORD(
10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,

Line 14: program_update_date DATE := FND_API.G_MISS_DATE,

10: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

Line 15: object_version_number NUMBER := FND_API.G_MISS_NUM ,

11: request_id NUMBER := FND_API.G_MISS_NUM ,
12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,

Line 16: created_by NUMBER := FND_API.G_MISS_NUM ,

12: program_application_id NUMBER := FND_API.G_MISS_NUM ,
13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,

Line 17: creation_date DATE := FND_API.G_MISS_DATE,

13: program_id NUMBER := FND_API.G_MISS_NUM ,
14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,

Line 18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

14: program_update_date DATE := FND_API.G_MISS_DATE,
15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,

Line 19: last_update_date DATE := FND_API.G_MISS_DATE,

15: object_version_number NUMBER := FND_API.G_MISS_NUM ,
16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 20: last_update_login NUMBER := FND_API.G_MISS_NUM ,

16: created_by NUMBER := FND_API.G_MISS_NUM ,
17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 21: party_id NUMBER := FND_API.G_MISS_NUM ,

17: creation_date DATE := FND_API.G_MISS_DATE,
18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,

18: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,

19: last_update_date DATE := FND_API.G_MISS_DATE,
20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,

20: last_update_login NUMBER := FND_API.G_MISS_NUM ,
21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

21: party_id NUMBER := FND_API.G_MISS_NUM ,
22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

22: cust_account_id NUMBER := FND_API.G_MISS_NUM ,
23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

23: shopping_list_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

24: description VARCHAR2(240) := FND_API.G_MISS_CHAR,
25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

25: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

26: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

27: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

28: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

29: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

30: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

31: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

32: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

33: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: org_id NUMBER := FND_API.G_MISS_NUM

Line 38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

34: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: org_id NUMBER := FND_API.G_MISS_NUM
42: );

Line 39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

35: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: org_id NUMBER := FND_API.G_MISS_NUM
42: );
43:

Line 40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

36: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: org_id NUMBER := FND_API.G_MISS_NUM
42: );
43:
44: G_MISS_SL_HEADER_REC SL_Header_Rec_Type;

Line 41: org_id NUMBER := FND_API.G_MISS_NUM

37: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41: org_id NUMBER := FND_API.G_MISS_NUM
42: );
43:
44: G_MISS_SL_HEADER_REC SL_Header_Rec_Type;
45:

Line 55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: /*
52: * Types declaration for Shopping List Line
53: */
54: TYPE SL_Line_Rec_Type IS RECORD(
55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,

Line 56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,

52: * Types declaration for Shopping List Line
53: */
54: TYPE SL_Line_Rec_Type IS RECORD(
55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

Line 57: object_version_number NUMBER := FND_API.G_MISS_NUM ,

53: */
54: TYPE SL_Line_Rec_Type IS RECORD(
55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,

Line 58: creation_date DATE := FND_API.G_MISS_DATE,

54: TYPE SL_Line_Rec_Type IS RECORD(
55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,

Line 59: created_by NUMBER := FND_API.G_MISS_NUM ,

55: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,

Line 60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

56: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,

Line 61: last_update_date DATE := FND_API.G_MISS_DATE,

57: object_version_number NUMBER := FND_API.G_MISS_NUM ,
58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,

Line 62: last_update_login NUMBER := FND_API.G_MISS_NUM ,

58: creation_date DATE := FND_API.G_MISS_DATE,
59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,

Line 63: request_id NUMBER := FND_API.G_MISS_NUM ,

59: created_by NUMBER := FND_API.G_MISS_NUM ,
60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,

Line 64: program_id NUMBER := FND_API.G_MISS_NUM ,

60: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,

Line 65: program_application_id NUMBER := FND_API.G_MISS_NUM ,

61: last_update_date DATE := FND_API.G_MISS_DATE,
62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,

Line 66: program_update_date DATE := FND_API.G_MISS_DATE,

62: last_update_login NUMBER := FND_API.G_MISS_NUM ,
63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,

63: request_id NUMBER := FND_API.G_MISS_NUM ,
64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,

Line 68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,

64: program_id NUMBER := FND_API.G_MISS_NUM ,
65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,

Line 69: organization_id NUMBER := FND_API.G_MISS_NUM ,

65: program_application_id NUMBER := FND_API.G_MISS_NUM ,
66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,

Line 70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

66: program_update_date DATE := FND_API.G_MISS_DATE,
67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 71: quantity NUMBER := FND_API.G_MISS_NUM ,

67: shp_list_id NUMBER := FND_API.G_MISS_NUM ,
68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 72: config_header_id NUMBER := FND_API.G_MISS_NUM ,

68: inventory_item_id NUMBER := FND_API.G_MISS_NUM ,
69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,

69: organization_id NUMBER := FND_API.G_MISS_NUM ,
70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,

70: uom_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,

71: quantity NUMBER := FND_API.G_MISS_NUM ,
72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

72: config_header_id NUMBER := FND_API.G_MISS_NUM ,
73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

73: config_revision_num NUMBER := FND_API.G_MISS_NUM ,
74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

74: complete_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

75: valid_configuration_flag VARCHAR2(3) := FND_API.G_MISS_CHAR,
76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

76: item_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

77: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: org_id NUMBER := FND_API.G_MISS_NUM

Line 90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: org_id NUMBER := FND_API.G_MISS_NUM
94: );

Line 91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: org_id NUMBER := FND_API.G_MISS_NUM
94: );
95:

Line 92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: org_id NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: G_MISS_SL_LINE_REC SL_Line_Rec_Type;

Line 93: org_id NUMBER := FND_API.G_MISS_NUM

89: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: org_id NUMBER := FND_API.G_MISS_NUM
94: );
95:
96: G_MISS_SL_LINE_REC SL_Line_Rec_Type;
97:

Line 108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

104: /*
105: * Types declaration for Shopping List Line Relationship
106: */
107: TYPE SL_Line_Rel_Rec_Type IS RECORD(
108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,

Line 109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,

105: * Types declaration for Shopping List Line Relationship
106: */
107: TYPE SL_Line_Rel_Rec_Type IS RECORD(
108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,

Line 110: request_id NUMBER := FND_API.G_MISS_NUM ,

106: */
107: TYPE SL_Line_Rel_Rec_Type IS RECORD(
108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,

Line 111: program_application_id NUMBER := FND_API.G_MISS_NUM ,

107: TYPE SL_Line_Rel_Rec_Type IS RECORD(
108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,

Line 112: program_id NUMBER := FND_API.G_MISS_NUM ,

108: operation_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,

Line 113: program_update_date DATE := FND_API.G_MISS_DATE,

109: shlitem_rel_id NUMBER := FND_API.G_MISS_NUM ,
110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

Line 114: object_version_number NUMBER := FND_API.G_MISS_NUM ,

110: request_id NUMBER := FND_API.G_MISS_NUM ,
111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,

Line 115: created_by NUMBER := FND_API.G_MISS_NUM ,

111: program_application_id NUMBER := FND_API.G_MISS_NUM ,
112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,

Line 116: creation_date DATE := FND_API.G_MISS_DATE,

112: program_id NUMBER := FND_API.G_MISS_NUM ,
113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,

Line 117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,

113: program_update_date DATE := FND_API.G_MISS_DATE,
114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,

Line 118: last_update_date DATE := FND_API.G_MISS_DATE,

114: object_version_number NUMBER := FND_API.G_MISS_NUM ,
115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,

Line 119: last_update_login NUMBER := FND_API.G_MISS_NUM ,

115: created_by NUMBER := FND_API.G_MISS_NUM ,
116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,

Line 120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,

116: creation_date DATE := FND_API.G_MISS_DATE,
117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,
124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 121: line_index NUMBER := FND_API.G_MISS_NUM ,

117: last_updated_by NUMBER := FND_API.G_MISS_NUM ,
118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,
124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125: );

Line 122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,

118: last_update_date DATE := FND_API.G_MISS_DATE,
119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,
124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125: );
126:

Line 123: related_line_index NUMBER := FND_API.G_MISS_NUM ,

119: last_update_login NUMBER := FND_API.G_MISS_NUM ,
120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,
124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125: );
126:
127: G_MISS_SL_LINE_REL_REC SL_Line_Rel_Rec_Type;

Line 124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

120: shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
121: line_index NUMBER := FND_API.G_MISS_NUM ,
122: related_shp_list_item_id NUMBER := FND_API.G_MISS_NUM ,
123: related_line_index NUMBER := FND_API.G_MISS_NUM ,
124: relationship_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
125: );
126:
127: G_MISS_SL_LINE_REL_REC SL_Line_Rel_Rec_Type;
128:

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

133:
134:
135: PROCEDURE Delete(
136: p_api_version IN NUMBER := 1 ,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2 ,
140: x_msg_count OUT NOCOPY NUMBER ,
141: x_msg_data OUT NOCOPY VARCHAR2 ,

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

134:
135: PROCEDURE Delete(
136: p_api_version IN NUMBER := 1 ,
137: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
138: p_commit IN VARCHAR2 := FND_API.G_FALSE,
139: x_return_status OUT NOCOPY VARCHAR2 ,
140: x_msg_count OUT NOCOPY NUMBER ,
141: x_msg_data OUT NOCOPY VARCHAR2 ,
142: p_shop_list_ids IN jtf_number_table ,

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

145:
146:
147: PROCEDURE Delete_All_Lines(
148: p_api_version IN NUMBER := 1 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2 ,
152: x_msg_count OUT NOCOPY NUMBER ,
153: x_msg_data OUT NOCOPY VARCHAR2 ,

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

146:
147: PROCEDURE Delete_All_Lines(
148: p_api_version IN NUMBER := 1 ,
149: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
150: p_commit IN VARCHAR2 := FND_API.G_FALSE,
151: x_return_status OUT NOCOPY VARCHAR2 ,
152: x_msg_count OUT NOCOPY NUMBER ,
153: x_msg_data OUT NOCOPY VARCHAR2 ,
154: p_shop_list_ids IN jtf_number_table ,

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

157:
158:
159: PROCEDURE Delete_Lines(
160: p_api_version IN NUMBER := 1 ,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2 ,
164: x_msg_count OUT NOCOPY NUMBER ,
165: x_msg_data OUT NOCOPY VARCHAR2 ,

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

158:
159: PROCEDURE Delete_Lines(
160: p_api_version IN NUMBER := 1 ,
161: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
162: p_commit IN VARCHAR2 := FND_API.G_FALSE,
163: x_return_status OUT NOCOPY VARCHAR2 ,
164: x_msg_count OUT NOCOPY NUMBER ,
165: x_msg_data OUT NOCOPY VARCHAR2 ,
166: p_shop_list_line_ids IN jtf_number_table ,

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

169:
170:
171: PROCEDURE Save(
172: p_api_version IN NUMBER := 1 ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
176: x_msg_count OUT NOCOPY NUMBER ,
177: x_msg_data OUT NOCOPY VARCHAR2 ,

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

170:
171: PROCEDURE Save(
172: p_api_version IN NUMBER := 1 ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
176: x_msg_count OUT NOCOPY NUMBER ,
177: x_msg_data OUT NOCOPY VARCHAR2 ,
178: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

174: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
175: x_return_status OUT NOCOPY VARCHAR2 ,
176: x_msg_count OUT NOCOPY NUMBER ,
177: x_msg_data OUT NOCOPY VARCHAR2 ,
178: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
179: p_sl_header_rec IN SL_Header_Rec_Type ,
180: p_sl_line_tbl IN SL_Line_Tbl_Type := G_MISS_SL_LINE_TBL ,
181: p_sl_line_rel_tbl IN SL_Line_Rel_Tbl_Type := G_MISS_SL_LINE_REL_TBL,
182: x_sl_header_id OUT NOCOPY NUMBER

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

184:
185:
186: PROCEDURE Save_List_From_Items(
187: p_api_version IN NUMBER := 1 ,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,

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

185:
186: PROCEDURE Save_List_From_Items(
187: p_api_version IN NUMBER := 1 ,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: p_sl_line_ids IN jtf_number_table ,

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

192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: p_sl_line_ids IN jtf_number_table ,
194: p_sl_line_ovns IN jtf_number_table := NULL ,
195: p_mode IN VARCHAR2 := 'MERGE' ,
196: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
197: p_sl_header_rec IN SL_Header_Rec_Type ,
198: x_sl_header_id OUT NOCOPY NUMBER
199: );
200:

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

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

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

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

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

205: x_return_status OUT NOCOPY VARCHAR2 ,
206: x_msg_count OUT NOCOPY NUMBER ,
207: x_msg_data OUT NOCOPY VARCHAR2 ,
208: p_quote_header_id IN NUMBER ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_mode IN VARCHAR2 := 'MERGE' ,
213: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

206: x_msg_count OUT NOCOPY NUMBER ,
207: x_msg_data OUT NOCOPY VARCHAR2 ,
208: p_quote_header_id IN NUMBER ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_mode IN VARCHAR2 := 'MERGE' ,
213: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_sl_header_rec IN SL_Header_Rec_Type ,

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

207: x_msg_data OUT NOCOPY VARCHAR2 ,
208: p_quote_header_id IN NUMBER ,
209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_mode IN VARCHAR2 := 'MERGE' ,
213: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_sl_header_rec IN SL_Header_Rec_Type ,
215: x_sl_header_id OUT NOCOPY NUMBER

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

209: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
210: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
211: p_last_update_date IN DATE := FND_API.G_MISS_DATE,
212: p_mode IN VARCHAR2 := 'MERGE' ,
213: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR,
214: p_sl_header_rec IN SL_Header_Rec_Type ,
215: x_sl_header_id OUT NOCOPY NUMBER
216: );
217:

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

217:
218:
219: PROCEDURE Save_Quote_From_List_Items(
220: p_api_version IN NUMBER := 1 ,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223: x_return_status OUT NOCOPY VARCHAR2 ,
224: x_msg_count OUT NOCOPY NUMBER ,
225: x_msg_data OUT NOCOPY VARCHAR2 ,

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

218:
219: PROCEDURE Save_Quote_From_List_Items(
220: p_api_version IN NUMBER := 1 ,
221: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
222: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
223: x_return_status OUT NOCOPY VARCHAR2 ,
224: x_msg_count OUT NOCOPY NUMBER ,
225: x_msg_data OUT NOCOPY VARCHAR2 ,
226: p_sl_line_ids IN jtf_number_table ,

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

224: x_msg_count OUT NOCOPY NUMBER ,
225: x_msg_data OUT NOCOPY VARCHAR2 ,
226: p_sl_line_ids IN jtf_number_table ,
227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_mode IN VARCHAR2 := 'MERGE' ,

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

225: x_msg_data OUT NOCOPY VARCHAR2 ,
226: p_sl_line_ids IN jtf_number_table ,
227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_mode IN VARCHAR2 := 'MERGE' ,
233: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,

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

226: p_sl_line_ids IN jtf_number_table ,
227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_mode IN VARCHAR2 := 'MERGE' ,
233: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_control_rec IN ASO_Quote_Pub.control_rec_type ,

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

227: p_sl_line_ovns IN jtf_number_table := NULL ,
228: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM ,
229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_mode IN VARCHAR2 := 'MERGE' ,
233: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_control_rec IN ASO_Quote_Pub.control_rec_type ,
235: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,

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

229: p_recipient_party_id IN NUMBER := FND_API.G_MISS_NUM ,
230: p_recipient_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
231: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
232: p_mode IN VARCHAR2 := 'MERGE' ,
233: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_control_rec IN ASO_Quote_Pub.control_rec_type ,
235: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,
236: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR ,
237: p_email_address IN jtf_varchar2_table_2000 := NULL ,

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

232: p_mode IN VARCHAR2 := 'MERGE' ,
233: p_combine_same_item IN VARCHAR2 := FND_API.G_MISS_CHAR ,
234: p_control_rec IN ASO_Quote_Pub.control_rec_type ,
235: p_q_header_rec IN ASO_Quote_Pub.qte_header_rec_type,
236: p_password IN VARCHAR2 := FND_API.G_MISS_CHAR ,
237: p_email_address IN jtf_varchar2_table_2000 := NULL ,
238: p_privilege_type IN jtf_varchar2_table_100 := NULL ,
239: p_url IN VARCHAR2 ,
240: p_comments IN VARCHAR2 ,

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

237: p_email_address IN jtf_varchar2_table_2000 := NULL ,
238: p_privilege_type IN jtf_varchar2_table_100 := NULL ,
239: p_url IN VARCHAR2 ,
240: p_comments IN VARCHAR2 ,
241: p_promocode IN VARCHAR2 := FND_API.G_MISS_CHAR ,
242: x_q_header_id OUT NOCOPY NUMBER
243: );
244:
245: END IBE_Shop_List_PVT;