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.OE_PRICING_CONT_PUB dependencies on FND_API

Line 8: ( agreement_id NUMBER := FND_API.G_MISS_NUM

4:
5: -- Contract record type
6:
7: TYPE Contract_Rec_Type IS RECORD
8: ( agreement_id NUMBER := FND_API.G_MISS_NUM
9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

5: -- Contract record type
6:
7: TYPE Contract_Rec_Type IS RECORD
8: ( agreement_id NUMBER := FND_API.G_MISS_NUM
9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

6:
7: TYPE Contract_Rec_Type IS RECORD
8: ( agreement_id NUMBER := FND_API.G_MISS_NUM
9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

7: TYPE Contract_Rec_Type IS RECORD
8: ( agreement_id NUMBER := FND_API.G_MISS_NUM
9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

8: ( agreement_id NUMBER := FND_API.G_MISS_NUM
9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

9: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

10: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

11: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

12: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

13: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

14: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

15: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

16: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

17: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM

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

18: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE

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

19: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM

Line 24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

20: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 25: , created_by NUMBER := FND_API.G_MISS_NUM

21: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE

Line 26: , creation_date DATE := FND_API.G_MISS_DATE

22: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 27: , discount_id NUMBER := FND_API.G_MISS_NUM

23: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM

Line 28: , last_updated_by NUMBER := FND_API.G_MISS_NUM

24: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

Line 29: , last_update_date DATE := FND_API.G_MISS_DATE

25: , created_by NUMBER := FND_API.G_MISS_NUM
26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 30: , last_update_login NUMBER := FND_API.G_MISS_NUM

26: , creation_date DATE := FND_API.G_MISS_DATE
27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 31: , price_list_id NUMBER := FND_API.G_MISS_NUM

27: , discount_id NUMBER := FND_API.G_MISS_NUM
28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

28: , last_updated_by NUMBER := FND_API.G_MISS_NUM
29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
36: );

Line 33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

29: , last_update_date DATE := FND_API.G_MISS_DATE
30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
36: );
37:

Line 34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

30: , last_update_login NUMBER := FND_API.G_MISS_NUM
31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
36: );
37:
38: TYPE Contract_Tbl_Type IS TABLE OF Contract_Rec_Type

Line 35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

31: , price_list_id NUMBER := FND_API.G_MISS_NUM
32: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
33: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
35: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
36: );
37:
38: TYPE Contract_Tbl_Type IS TABLE OF Contract_Rec_Type
39: INDEX BY BINARY_INTEGER;

Line 44: ( agreement VARCHAR2(240) := FND_API.G_MISS_CHAR

40:
41: -- Contract value record type
42:
43: TYPE Contract_Val_Rec_Type IS RECORD
44: ( agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
47: );
48:

Line 45: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR

41: -- Contract value record type
42:
43: TYPE Contract_Val_Rec_Type IS RECORD
44: ( agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
47: );
48:
49: TYPE Contract_Val_Tbl_Type IS TABLE OF Contract_Val_Rec_Type

Line 46: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

42:
43: TYPE Contract_Val_Rec_Type IS RECORD
44: ( agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
47: );
48:
49: TYPE Contract_Val_Tbl_Type IS TABLE OF Contract_Val_Rec_Type
50: INDEX BY BINARY_INTEGER;

Line 55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM

51:
52: -- Agreement record type
53:
54: TYPE Agreement_Rec_Type IS RECORD
55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM

52: -- Agreement record type
53:
54: TYPE Agreement_Rec_Type IS RECORD
55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 57: , agreement_id NUMBER := FND_API.G_MISS_NUM

53:
54: TYPE Agreement_Rec_Type IS RECORD
55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR

54: TYPE Agreement_Rec_Type IS RECORD
55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

55: ( accounting_rule_id NUMBER := FND_API.G_MISS_NUM
56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

56: , agreement_contact_id NUMBER := FND_API.G_MISS_NUM
57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

57: , agreement_id NUMBER := FND_API.G_MISS_NUM
58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

58: , agreement_num VARCHAR2(50) := FND_API.G_MISS_CHAR
59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

59: , agreement_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

60: , attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR
61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

61: , attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR
62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

62: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

63: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

64: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

65: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

66: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

67: , attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR
68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR

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

68: , attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR
69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

69: , attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR
70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM

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

70: , attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE

Line 75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR

71: , attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

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

72: , attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE

Line 77: , created_by NUMBER := FND_API.G_MISS_NUM

73: , attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 78: , creation_date DATE := FND_API.G_MISS_DATE

74: , attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM

Line 79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

75: , comments VARCHAR2(30) := FND_API.G_MISS_CHAR
76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM

Line 80: , end_date_active DATE := FND_API.G_MISS_DATE

76: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

Line 81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR

77: , created_by NUMBER := FND_API.G_MISS_NUM
78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM

78: , creation_date DATE := FND_API.G_MISS_DATE
79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE

Line 83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM

79: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM

80: , end_date_active DATE := FND_API.G_MISS_DATE
81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153

Line 85: , last_updated_by NUMBER := FND_API.G_MISS_NUM

81: , freight_terms_code VARCHAR2(30) := FND_API.G_MISS_CHAR
82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 86: , last_update_date DATE := FND_API.G_MISS_DATE

82: , invoice_contact_id NUMBER := FND_API.G_MISS_NUM
83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 87: , last_update_login NUMBER := FND_API.G_MISS_NUM

83: , invoice_to_org_id NUMBER := FND_API.G_MISS_NUM
84: , invoicing_rule_id NUMBER := FND_API.G_MISS_NUM
85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

85: , last_updated_by NUMBER := FND_API.G_MISS_NUM
86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

Line 90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

86: , last_update_date DATE := FND_API.G_MISS_DATE
87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 92: , price_list_id NUMBER := FND_API.G_MISS_NUM

88: -- Bug 1815153
89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE

Line 93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

89: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR

90: , override_arule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM

Line 95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR

91: , override_irule_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 96: , revision_date DATE := FND_API.G_MISS_DATE

92: , price_list_id NUMBER := FND_API.G_MISS_NUM
93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE

Line 97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR

93: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE

Line 98: , salesrep_id NUMBER := FND_API.G_MISS_NUM

94: , purchase_order_num VARCHAR2(50) := FND_API.G_MISS_CHAR
95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM

Line 99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR

95: , revision VARCHAR2(50) := FND_API.G_MISS_CHAR
96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 100: , signature_date DATE := FND_API.G_MISS_DATE

96: , revision_date DATE := FND_API.G_MISS_DATE
97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 101: , start_date_active DATE := FND_API.G_MISS_DATE

97: , revision_reason_code VARCHAR2(30) := FND_API.G_MISS_CHAR
98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 102: , term_id NUMBER := FND_API.G_MISS_NUM

98: , salesrep_id NUMBER := FND_API.G_MISS_NUM
99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

99: , ship_method_code VARCHAR2(30) := FND_API.G_MISS_CHAR
100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

100: , signature_date DATE := FND_API.G_MISS_DATE
101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

101: , start_date_active DATE := FND_API.G_MISS_DATE
102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

102: , term_id NUMBER := FND_API.G_MISS_NUM
103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

103: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

104: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

105: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

106: , tp_attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

107: , tp_attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

108: , tp_attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

109: , tp_attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

110: , tp_attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

111: , tp_attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

112: , tp_attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

113: , tp_attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

114: , tp_attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

115: , tp_attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC

Line 120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

116: , tp_attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC
124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM

Line 121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR

117: , tp_attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC
124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM
125: --added by rchellam for OKC

Line 122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR

118: , tp_attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , tp_attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC
124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM
125: --added by rchellam for OKC
126: , invoice_to_customer_id NUMBER := FND_API.G_MISS_NUM

Line 124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM

120: , tp_attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , tp_attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR
122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC
124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM
125: --added by rchellam for OKC
126: , invoice_to_customer_id NUMBER := FND_API.G_MISS_NUM
127: -- Added for bug#4029589
128: );

Line 126: , invoice_to_customer_id NUMBER := FND_API.G_MISS_NUM

122: , agreement_source_code VARCHAR2(30) := FND_API.G_MISS_CHAR
123: --added by rchellam for OKC
124: , orig_system_agr_id NUMBER := FND_API.G_MISS_NUM
125: --added by rchellam for OKC
126: , invoice_to_customer_id NUMBER := FND_API.G_MISS_NUM
127: -- Added for bug#4029589
128: );
129:
130: TYPE Agreement_Tbl_Type IS TABLE OF Agreement_Rec_Type

Line 136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

132:
133: -- Agreement value record type
134:
135: TYPE Agreement_Val_Rec_Type IS RECORD
136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR

133: -- Agreement value record type
134:
135: TYPE Agreement_Val_Rec_Type IS RECORD
136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR

134:
135: TYPE Agreement_Val_Rec_Type IS RECORD
136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR

135: TYPE Agreement_Val_Rec_Type IS RECORD
136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR

136: ( accounting_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */

Line 141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR

137: , agreement_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR

138: , agreement VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR

139: , agreement_type VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */

140: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

141: , freight_terms VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR

142: , invoice_contact VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR

143: , invoice_to_site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

144: /* , invoice_to_org VARCHAR2(240) := FND_API.G_MISS_CHAR */
145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR

145: , invoicing_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC

Line 150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR

146: , override_arule VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC
154: );

Line 151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR

147: , override_irule VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC
154: );
155:

Line 152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR

148: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC
154: );
155:
156: TYPE Agreement_Val_Tbl_Type IS TABLE OF Agreement_Val_Rec_Type

Line 153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC

149: , revision_reason VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , salesrep VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , ship_method VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , term VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , agreement_source VARCHAR2(240) := FND_API.G_MISS_CHAR --added by rchellam for OKC
154: );
155:
156: TYPE Agreement_Val_Tbl_Type IS TABLE OF Agreement_Val_Rec_Type
157: INDEX BY BINARY_INTEGER;

Line 162: ( amount NUMBER := FND_API.G_MISS_NUM

158:
159: -- Discount_Header record type
160:
161: TYPE Discount_Header_Rec_Type IS RECORD
162: ( amount NUMBER := FND_API.G_MISS_NUM
163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

159: -- Discount_Header record type
160:
161: TYPE Discount_Header_Rec_Type IS RECORD
162: ( amount NUMBER := FND_API.G_MISS_NUM
163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

160:
161: TYPE Discount_Header_Rec_Type IS RECORD
162: ( amount NUMBER := FND_API.G_MISS_NUM
163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

161: TYPE Discount_Header_Rec_Type IS RECORD
162: ( amount NUMBER := FND_API.G_MISS_NUM
163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

162: ( amount NUMBER := FND_API.G_MISS_NUM
163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

163: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

164: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

165: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

166: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

167: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

168: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

169: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

170: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

171: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

172: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM

Line 177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

173: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE

Line 178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

174: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

175: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM

Line 180: , created_by NUMBER := FND_API.G_MISS_NUM

176: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 181: , creation_date DATE := FND_API.G_MISS_DATE

177: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

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

178: , automatic_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE

Line 183: , discount_id NUMBER := FND_API.G_MISS_NUM

179: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

180: , created_by NUMBER := FND_API.G_MISS_NUM
181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

181: , creation_date DATE := FND_API.G_MISS_DATE
182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE

Line 186: , end_date_active DATE := FND_API.G_MISS_DATE

182: , description VARCHAR2(240) := FND_API.G_MISS_CHAR
183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR

183: , discount_id NUMBER := FND_API.G_MISS_NUM
184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 188: , last_updated_by NUMBER := FND_API.G_MISS_NUM

184: , discount_lines_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 189: , last_update_date DATE := FND_API.G_MISS_DATE

185: , discount_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 190: , last_update_login NUMBER := FND_API.G_MISS_NUM

186: , end_date_active DATE := FND_API.G_MISS_DATE
187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM

Line 191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

187: , gsa_indicator VARCHAR2(1) := FND_API.G_MISS_CHAR
188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM

Line 192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

188: , last_updated_by NUMBER := FND_API.G_MISS_NUM
189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

Line 193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

189: , last_update_date DATE := FND_API.G_MISS_DATE
190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 194: , percent NUMBER := FND_API.G_MISS_NUM

190: , last_update_login NUMBER := FND_API.G_MISS_NUM
191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM

Line 195: , price_list_id NUMBER := FND_API.G_MISS_NUM

191: , manual_discount_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE

Line 196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM

192: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 197: , program_application_id NUMBER := FND_API.G_MISS_NUM

193: , override_allowed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM

Line 198: , program_id NUMBER := FND_API.G_MISS_NUM

194: , percent NUMBER := FND_API.G_MISS_NUM
195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE

Line 199: , program_update_date DATE := FND_API.G_MISS_DATE

195: , price_list_id NUMBER := FND_API.G_MISS_NUM
196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR

196: , pricing_contract_id NUMBER := FND_API.G_MISS_NUM
197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 201: , request_id NUMBER := FND_API.G_MISS_NUM

197: , program_application_id NUMBER := FND_API.G_MISS_NUM
198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 202: , start_date_active DATE := FND_API.G_MISS_DATE

198: , program_id NUMBER := FND_API.G_MISS_NUM
199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
206: );

Line 203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

199: , program_update_date DATE := FND_API.G_MISS_DATE
200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
206: );
207:

Line 204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

200: , prorate_flag VARCHAR2(30) := FND_API.G_MISS_CHAR
201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
206: );
207:
208: TYPE Discount_Header_Tbl_Type IS TABLE OF Discount_Header_Rec_Type

Line 205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

201: , request_id NUMBER := FND_API.G_MISS_NUM
202: , start_date_active DATE := FND_API.G_MISS_DATE
203: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
204: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
205: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
206: );
207:
208: TYPE Discount_Header_Tbl_Type IS TABLE OF Discount_Header_Rec_Type
209: INDEX BY BINARY_INTEGER;

Line 214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR

210:
211: -- Discount_Header value record type
212:
213: TYPE Discount_Header_Val_Rec_Type IS RECORD
214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR

211: -- Discount_Header value record type
212:
213: TYPE Discount_Header_Val_Rec_Type IS RECORD
214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR

212:
213: TYPE Discount_Header_Val_Rec_Type IS RECORD
214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR

213: TYPE Discount_Header_Val_Rec_Type IS RECORD
214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR

214: ( automatic_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
222: );

Line 219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR

215: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
222: );
223:

Line 220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR

216: , discount_lines VARCHAR2(240) := FND_API.G_MISS_CHAR
217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
222: );
223:
224: TYPE Discount_Header_Val_Tbl_Type IS TABLE OF Discount_Header_Val_Rec_Type

Line 221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR

217: , discount_type VARCHAR2(240) := FND_API.G_MISS_CHAR
218: , manual_discount VARCHAR2(240) := FND_API.G_MISS_CHAR
219: , override_allowed VARCHAR2(240) := FND_API.G_MISS_CHAR
220: , price_list VARCHAR2(240) := FND_API.G_MISS_CHAR
221: , prorate VARCHAR2(240) := FND_API.G_MISS_CHAR
222: );
223:
224: TYPE Discount_Header_Val_Tbl_Type IS TABLE OF Discount_Header_Val_Rec_Type
225: INDEX BY BINARY_INTEGER;

Line 231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

227:
228: -- Discount_Cust record type
229:
230: TYPE Discount_Cust_Rec_Type IS RECORD
231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

228: -- Discount_Cust record type
229:
230: TYPE Discount_Cust_Rec_Type IS RECORD
231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

229:
230: TYPE Discount_Cust_Rec_Type IS RECORD
231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

230: TYPE Discount_Cust_Rec_Type IS RECORD
231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

231: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

232: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

233: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

234: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

235: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

236: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

237: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

238: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

239: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM

Line 244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

240: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE

Line 245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

241: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

242: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */

Line 247: , created_by NUMBER := FND_API.G_MISS_NUM

243: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

Line 248: , creation_date DATE := FND_API.G_MISS_DATE

244: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM

Line 249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR

245: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM

Line 250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */

246: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE

Line 251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM

247: , created_by NUMBER := FND_API.G_MISS_NUM
248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM

248: , creation_date DATE := FND_API.G_MISS_DATE
249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE

Line 253: , discount_id NUMBER := FND_API.G_MISS_NUM

249: , customer_class_code VARCHAR2(30) := FND_API.G_MISS_CHAR
250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 254: , end_date_active DATE := FND_API.G_MISS_DATE

250: /* , customer_id NUMBER := FND_API.G_MISS_NUM */
251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 255: , last_updated_by NUMBER := FND_API.G_MISS_NUM

251: , sold_to_org_id NUMBER := FND_API.G_MISS_NUM
252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM

Line 256: , last_update_date DATE := FND_API.G_MISS_DATE

252: , discount_customer_id NUMBER := FND_API.G_MISS_NUM
253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE

Line 257: , last_update_login NUMBER := FND_API.G_MISS_NUM

253: , discount_id NUMBER := FND_API.G_MISS_NUM
254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM

Line 258: , program_application_id NUMBER := FND_API.G_MISS_NUM

254: , end_date_active DATE := FND_API.G_MISS_DATE
255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */

Line 259: , program_id NUMBER := FND_API.G_MISS_NUM

255: , last_updated_by NUMBER := FND_API.G_MISS_NUM
256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM

Line 260: , program_update_date DATE := FND_API.G_MISS_DATE

256: , last_update_date DATE := FND_API.G_MISS_DATE
257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE

Line 261: , request_id NUMBER := FND_API.G_MISS_NUM

257: , last_update_login NUMBER := FND_API.G_MISS_NUM
258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 262: /, site_use_id NUMBER := FND_API.G_MISS_NUM /

258: , program_application_id NUMBER := FND_API.G_MISS_NUM
259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 263: , site_org_id NUMBER := FND_API.G_MISS_NUM

259: , program_id NUMBER := FND_API.G_MISS_NUM
260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 264: , start_date_active DATE := FND_API.G_MISS_DATE

260: , program_update_date DATE := FND_API.G_MISS_DATE
261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
268: );

Line 265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

261: , request_id NUMBER := FND_API.G_MISS_NUM
262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
268: );
269:

Line 266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

262: /*, site_use_id NUMBER := FND_API.G_MISS_NUM */
263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
268: );
269:
270: TYPE Discount_Cust_Tbl_Type IS TABLE OF Discount_Cust_Rec_Type

Line 267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

263: , site_org_id NUMBER := FND_API.G_MISS_NUM
264: , start_date_active DATE := FND_API.G_MISS_DATE
265: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
266: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
267: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
268: );
269:
270: TYPE Discount_Cust_Tbl_Type IS TABLE OF Discount_Cust_Rec_Type
271: INDEX BY BINARY_INTEGER;

Line 276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR

272:
273: -- Discount_Cust value record type
274:
275: TYPE Discount_Cust_Val_Rec_Type IS RECORD
276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR

273: -- Discount_Cust value record type
274:
275: TYPE Discount_Cust_Val_Rec_Type IS RECORD
276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
281: );

Line 278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR

274:
275: TYPE Discount_Cust_Val_Rec_Type IS RECORD
276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
281: );
282:

Line 279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR

275: TYPE Discount_Cust_Val_Rec_Type IS RECORD
276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
281: );
282:
283: TYPE Discount_Cust_Val_Tbl_Type IS TABLE OF Discount_Cust_Val_Rec_Type

Line 280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR

276: ( customer_class VARCHAR2(240) := FND_API.G_MISS_CHAR
277: , customer VARCHAR2(240) := FND_API.G_MISS_CHAR
278: , discount_customer VARCHAR2(240) := FND_API.G_MISS_CHAR
279: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
280: , site_use VARCHAR2(240) := FND_API.G_MISS_CHAR
281: );
282:
283: TYPE Discount_Cust_Val_Tbl_Type IS TABLE OF Discount_Cust_Val_Rec_Type
284: INDEX BY BINARY_INTEGER;

Line 289: ( amount NUMBER := FND_API.G_MISS_NUM

285:
286: -- Discount_Line record type
287:
288: TYPE Discount_Line_Rec_Type IS RECORD
289: ( amount NUMBER := FND_API.G_MISS_NUM
290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

286: -- Discount_Line record type
287:
288: TYPE Discount_Line_Rec_Type IS RECORD
289: ( amount NUMBER := FND_API.G_MISS_NUM
290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

287:
288: TYPE Discount_Line_Rec_Type IS RECORD
289: ( amount NUMBER := FND_API.G_MISS_NUM
290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

288: TYPE Discount_Line_Rec_Type IS RECORD
289: ( amount NUMBER := FND_API.G_MISS_NUM
290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

289: ( amount NUMBER := FND_API.G_MISS_NUM
290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

290: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

291: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

292: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

293: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

294: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

295: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

296: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

297: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

298: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM

Line 303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

299: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE

Line 304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

300: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM

Line 305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

301: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM

Line 306: , created_by NUMBER := FND_API.G_MISS_NUM

302: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM

Line 307: , creation_date DATE := FND_API.G_MISS_DATE

303: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE

Line 308: , customer_item_id NUMBER := FND_API.G_MISS_NUM

304: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM

Line 309: , discount_id NUMBER := FND_API.G_MISS_NUM

305: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 310: , discount_line_id NUMBER := FND_API.G_MISS_NUM

306: , created_by NUMBER := FND_API.G_MISS_NUM
307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 311: , end_date_active DATE := FND_API.G_MISS_DATE

307: , creation_date DATE := FND_API.G_MISS_DATE
308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE

Line 312: , entity_id NUMBER := FND_API.G_MISS_NUM

308: , customer_item_id NUMBER := FND_API.G_MISS_NUM
309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR

309: , discount_id NUMBER := FND_API.G_MISS_NUM
310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM

Line 314: , last_updated_by NUMBER := FND_API.G_MISS_NUM

310: , discount_line_id NUMBER := FND_API.G_MISS_NUM
311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM

Line 315: , last_update_date DATE := FND_API.G_MISS_DATE

311: , end_date_active DATE := FND_API.G_MISS_DATE
312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 316: , last_update_login NUMBER := FND_API.G_MISS_NUM

312: , entity_id NUMBER := FND_API.G_MISS_NUM
313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM

Line 317: , percent NUMBER := FND_API.G_MISS_NUM

313: , entity_value VARCHAR2(240) := FND_API.G_MISS_CHAR
314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE

Line 318: , price NUMBER := FND_API.G_MISS_NUM

314: , last_updated_by NUMBER := FND_API.G_MISS_NUM
315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM

Line 319: , program_application_id NUMBER := FND_API.G_MISS_NUM

315: , last_update_date DATE := FND_API.G_MISS_DATE
316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE

Line 320: , program_id NUMBER := FND_API.G_MISS_NUM

316: , last_update_login NUMBER := FND_API.G_MISS_NUM
317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 321: , program_update_date DATE := FND_API.G_MISS_DATE

317: , percent NUMBER := FND_API.G_MISS_NUM
318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 322: , request_id NUMBER := FND_API.G_MISS_NUM

318: , price NUMBER := FND_API.G_MISS_NUM
319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 323: , start_date_active DATE := FND_API.G_MISS_DATE

319: , program_application_id NUMBER := FND_API.G_MISS_NUM
320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
327: );

Line 324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

320: , program_id NUMBER := FND_API.G_MISS_NUM
321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
327: );
328:

Line 325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

321: , program_update_date DATE := FND_API.G_MISS_DATE
322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
327: );
328:
329: TYPE Discount_Line_Tbl_Type IS TABLE OF Discount_Line_Rec_Type

Line 326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

322: , request_id NUMBER := FND_API.G_MISS_NUM
323: , start_date_active DATE := FND_API.G_MISS_DATE
324: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
325: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
326: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
327: );
328:
329: TYPE Discount_Line_Tbl_Type IS TABLE OF Discount_Line_Rec_Type
330: INDEX BY BINARY_INTEGER;

Line 335: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR

331:
332: -- Discount_Line value record type
333:
334: TYPE Discount_Line_Val_Rec_Type IS RECORD
335: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
336: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
337: , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
338: , entity VARCHAR2(240) := FND_API.G_MISS_CHAR
339: );

Line 336: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR

332: -- Discount_Line value record type
333:
334: TYPE Discount_Line_Val_Rec_Type IS RECORD
335: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
336: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
337: , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
338: , entity VARCHAR2(240) := FND_API.G_MISS_CHAR
339: );
340:

Line 337: , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR

333:
334: TYPE Discount_Line_Val_Rec_Type IS RECORD
335: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
336: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
337: , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
338: , entity VARCHAR2(240) := FND_API.G_MISS_CHAR
339: );
340:
341: TYPE Discount_Line_Val_Tbl_Type IS TABLE OF Discount_Line_Val_Rec_Type

Line 338: , entity VARCHAR2(240) := FND_API.G_MISS_CHAR

334: TYPE Discount_Line_Val_Rec_Type IS RECORD
335: ( customer_item VARCHAR2(240) := FND_API.G_MISS_CHAR
336: , discount VARCHAR2(240) := FND_API.G_MISS_CHAR
337: , discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
338: , entity VARCHAR2(240) := FND_API.G_MISS_CHAR
339: );
340:
341: TYPE Discount_Line_Val_Tbl_Type IS TABLE OF Discount_Line_Val_Rec_Type
342: INDEX BY BINARY_INTEGER;

Line 347: ( amount NUMBER := FND_API.G_MISS_NUM

343:
344: -- Price_Break record type
345:
346: TYPE Price_Break_Rec_Type IS RECORD
347: ( amount NUMBER := FND_API.G_MISS_NUM
348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR

344: -- Price_Break record type
345:
346: TYPE Price_Break_Rec_Type IS RECORD
347: ( amount NUMBER := FND_API.G_MISS_NUM
348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR

Line 349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR

345:
346: TYPE Price_Break_Rec_Type IS RECORD
347: ( amount NUMBER := FND_API.G_MISS_NUM
348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

346: TYPE Price_Break_Rec_Type IS RECORD
347: ( amount NUMBER := FND_API.G_MISS_NUM
348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR

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

347: ( amount NUMBER := FND_API.G_MISS_NUM
348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

348: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

349: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

350: , attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR
351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

351: , attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR
352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

352: , attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR
353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

353: , attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR
354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

354: , attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

355: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

356: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM

Line 361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

357: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE

Line 362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

358: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM

Line 363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

359: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE

Line 364: , created_by NUMBER := FND_API.G_MISS_NUM

360: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 365: , creation_date DATE := FND_API.G_MISS_DATE

361: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE

Line 366: , discount_line_id NUMBER := FND_API.G_MISS_NUM

362: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 367: , end_date_active DATE := FND_API.G_MISS_DATE

363: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 368: , last_updated_by NUMBER := FND_API.G_MISS_NUM

364: , created_by NUMBER := FND_API.G_MISS_NUM
365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM

Line 369: , last_update_date DATE := FND_API.G_MISS_DATE

365: , creation_date DATE := FND_API.G_MISS_DATE
366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM

Line 370: , last_update_login NUMBER := FND_API.G_MISS_NUM

366: , discount_line_id NUMBER := FND_API.G_MISS_NUM
367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM

Line 371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

367: , end_date_active DATE := FND_API.G_MISS_DATE
368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM

Line 372: , percent NUMBER := FND_API.G_MISS_NUM

368: , last_updated_by NUMBER := FND_API.G_MISS_NUM
369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 373: , price NUMBER := FND_API.G_MISS_NUM

369: , last_update_date DATE := FND_API.G_MISS_DATE
370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM

Line 374: , price_break_high NUMBER := FND_API.G_MISS_NUM

370: , last_update_login NUMBER := FND_API.G_MISS_NUM
371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE

Line 375: , price_break_low NUMBER := FND_API.G_MISS_NUM

371: , method_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM

Line 376: , program_application_id NUMBER := FND_API.G_MISS_NUM

372: , percent NUMBER := FND_API.G_MISS_NUM
373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE

Line 377: , program_id NUMBER := FND_API.G_MISS_NUM

373: , price NUMBER := FND_API.G_MISS_NUM
374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 378: , program_update_date DATE := FND_API.G_MISS_DATE

374: , price_break_high NUMBER := FND_API.G_MISS_NUM
375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 379: , request_id NUMBER := FND_API.G_MISS_NUM

375: , price_break_low NUMBER := FND_API.G_MISS_NUM
376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 380: , start_date_active DATE := FND_API.G_MISS_DATE

376: , program_application_id NUMBER := FND_API.G_MISS_NUM
377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR

377: , program_id NUMBER := FND_API.G_MISS_NUM
378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM

Line 382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

378: , program_update_date DATE := FND_API.G_MISS_DATE
379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM
386: );

Line 383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

379: , request_id NUMBER := FND_API.G_MISS_NUM
380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM
386: );
387:

Line 384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

380: , start_date_active DATE := FND_API.G_MISS_DATE
381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM
386: );
387:
388: TYPE Price_Break_Tbl_Type IS TABLE OF Price_Break_Rec_Type

Line 385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM

381: , unit_code VARCHAR2(3) := FND_API.G_MISS_CHAR
382: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
383: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
384: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
385: , Discount_Line_index NUMBER := FND_API.G_MISS_NUM
386: );
387:
388: TYPE Price_Break_Tbl_Type IS TABLE OF Price_Break_Rec_Type
389: INDEX BY BINARY_INTEGER;

Line 394: ( discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR

390:
391: -- Price_Break value record type
392:
393: TYPE Price_Break_Val_Rec_Type IS RECORD
394: ( discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
395: , method_type VARCHAR2(240) := FND_API.G_MISS_CHAR
396: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
397: );
398:

Line 395: , method_type VARCHAR2(240) := FND_API.G_MISS_CHAR

391: -- Price_Break value record type
392:
393: TYPE Price_Break_Val_Rec_Type IS RECORD
394: ( discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
395: , method_type VARCHAR2(240) := FND_API.G_MISS_CHAR
396: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
397: );
398:
399: TYPE Price_Break_Val_Tbl_Type IS TABLE OF Price_Break_Val_Rec_Type

Line 396: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR

392:
393: TYPE Price_Break_Val_Rec_Type IS RECORD
394: ( discount_line VARCHAR2(240) := FND_API.G_MISS_CHAR
395: , method_type VARCHAR2(240) := FND_API.G_MISS_CHAR
396: , unit VARCHAR2(240) := FND_API.G_MISS_CHAR
397: );
398:
399: TYPE Price_Break_Val_Tbl_Type IS TABLE OF Price_Break_Val_Rec_Type
400: INDEX BY BINARY_INTEGER;

Line 468: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

464: -- End of Comments
465:
466: PROCEDURE Process_Agreement
467: ( p_api_version_number IN NUMBER
468: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
469: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
470: , p_commit IN VARCHAR2 := FND_API.G_FALSE
471: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 469: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

465:
466: PROCEDURE Process_Agreement
467: ( p_api_version_number IN NUMBER
468: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
469: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
470: , p_commit IN VARCHAR2 := FND_API.G_FALSE
471: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
473: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

466: PROCEDURE Process_Agreement
467: ( p_api_version_number IN NUMBER
468: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
469: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
470: , p_commit IN VARCHAR2 := FND_API.G_FALSE
471: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
472: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
473: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
474: , p_Agreement_rec IN Agreement_Rec_Type :=

Line 519: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

515: -- End of Comments
516:
517: PROCEDURE Lock_Agreement
518: ( p_api_version_number IN NUMBER
519: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
520: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
521: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
522: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
523: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 520: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

516:
517: PROCEDURE Lock_Agreement
518: ( p_api_version_number IN NUMBER
519: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
520: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
521: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
522: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
523: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
524: , p_Agreement_rec IN Agreement_Rec_Type :=

Line 568: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

564: -- End of Comments
565:
566: PROCEDURE Get_Agreement
567: ( p_api_version_number IN NUMBER
568: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
569: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
570: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
571: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 569: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

565:
566: PROCEDURE Get_Agreement
567: ( p_api_version_number IN NUMBER
568: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
569: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
570: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
571: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
573: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM

Line 573: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM

569: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
570: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
571: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
573: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
574: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type

Line 574: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR

570: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
571: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
573: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
574: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */

571: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
572: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
573: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
574: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
575: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
576: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
577: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
578: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
579: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type