APPS.QP_PRICE_FORMULA_PUB dependencies on FND_API

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

11:
12: -- Formula record type
13:
14: TYPE Formula_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

12: -- Formula record type
13:
14: TYPE Formula_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

13:
14: TYPE Formula_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

14: TYPE Formula_Rec_Type IS RECORD
15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

15: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

16: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

17: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

18: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

19: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

20: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

21: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

22: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

23: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM

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

24: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE

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

25: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

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

26: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE

Line 31: , created_by NUMBER := FND_API.G_MISS_NUM

27: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */

Line 32: , creation_date DATE := FND_API.G_MISS_DATE

28: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR

29: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 34: , end_date_active DATE := FND_API.G_MISS_DATE

30: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
31: , created_by NUMBER := FND_API.G_MISS_NUM
32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE

Line 36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR

32: , creation_date DATE := FND_API.G_MISS_DATE
33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 37: , last_updated_by NUMBER := FND_API.G_MISS_NUM

33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM

Line 38: , last_update_date DATE := FND_API.G_MISS_DATE

34: , end_date_active DATE := FND_API.G_MISS_DATE
35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE

Line 39: , last_update_login NUMBER := FND_API.G_MISS_NUM

35: /* Increased the length of formula field for bug 1539041 */
36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

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

36: , formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 41: , price_formula_id NUMBER := FND_API.G_MISS_NUM

37: , last_updated_by NUMBER := FND_API.G_MISS_NUM
38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 42: , start_date_active DATE := FND_API.G_MISS_DATE

38: , last_update_date DATE := FND_API.G_MISS_DATE
39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
46: );

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

39: , last_update_login NUMBER := FND_API.G_MISS_NUM
40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
46: );
47:

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

40: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
46: );
47:
48: TYPE Formula_Tbl_Type IS TABLE OF Formula_Rec_Type

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

41: , price_formula_id NUMBER := FND_API.G_MISS_NUM
42: , start_date_active DATE := FND_API.G_MISS_DATE
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
46: );
47:
48: TYPE Formula_Tbl_Type IS TABLE OF Formula_Rec_Type
49: INDEX BY BINARY_INTEGER;

Line 54: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR

50:
51: -- Formula value record type
52:
53: TYPE Formula_Val_Rec_Type IS RECORD
54: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
55: ); /* increased the size of the price_formula to 2000, to fix the bug 1539041 */
56:
57: TYPE Formula_Val_Tbl_Type IS TABLE OF Formula_Val_Rec_Type
58: INDEX BY BINARY_INTEGER;

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

59:
60: -- Formula_Lines record type
61:
62: TYPE Formula_Lines_Rec_Type IS RECORD
63: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

60: -- Formula_Lines record type
61:
62: TYPE Formula_Lines_Rec_Type IS RECORD
63: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR

61:
62: TYPE Formula_Lines_Rec_Type IS RECORD
63: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

62: TYPE Formula_Lines_Rec_Type IS RECORD
63: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

63: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

64: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

65: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

66: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

67: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

68: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

69: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

70: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

71: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM

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

72: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE

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

73: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE

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

74: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 79: , created_by NUMBER := FND_API.G_MISS_NUM

75: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE

Line 80: , creation_date DATE := FND_API.G_MISS_DATE

76: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 81: , end_date_active DATE := FND_API.G_MISS_DATE

77: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM

Line 82: , last_updated_by NUMBER := FND_API.G_MISS_NUM

78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM

Line 83: , last_update_date DATE := FND_API.G_MISS_DATE

79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM

Line 84: , last_update_login NUMBER := FND_API.G_MISS_NUM

80: , creation_date DATE := FND_API.G_MISS_DATE
81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 85: , numeric_constant NUMBER := FND_API.G_MISS_NUM

81: , end_date_active DATE := FND_API.G_MISS_DATE
82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM

Line 86: , price_formula_id NUMBER := FND_API.G_MISS_NUM

82: , last_updated_by NUMBER := FND_API.G_MISS_NUM
83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM

Line 87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM

83: , last_update_date DATE := FND_API.G_MISS_DATE
84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

84: , last_update_login NUMBER := FND_API.G_MISS_NUM
85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM

85: , numeric_constant NUMBER := FND_API.G_MISS_NUM
86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE

Line 90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM

86: , price_formula_id NUMBER := FND_API.G_MISS_NUM
87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM

Line 91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

87: , price_formula_line_id NUMBER := FND_API.G_MISS_NUM
88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR

88: , formula_line_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 93: , start_date_active DATE := FND_API.G_MISS_DATE

89: , price_list_line_id NUMBER := FND_API.G_MISS_NUM
90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 94: , step_number NUMBER := FND_API.G_MISS_NUM

90: , price_modifier_list_id NUMBER := FND_API.G_MISS_NUM
91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

91: , pricing_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: );

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

92: , pricing_attribute_context VARCHAR2(30) := FND_API.G_MISS_CHAR
93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: );
100:

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

93: , start_date_active DATE := FND_API.G_MISS_DATE
94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: );
100:
101: TYPE Formula_Lines_Tbl_Type IS TABLE OF Formula_Lines_Rec_Type

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

94: , step_number NUMBER := FND_API.G_MISS_NUM
95: , reqd_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
96: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: );
100:
101: TYPE Formula_Lines_Tbl_Type IS TABLE OF Formula_Lines_Rec_Type
102: INDEX BY BINARY_INTEGER;

Line 107: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR

103:
104: -- Formula_Lines value record type
105:
106: TYPE Formula_Lines_Val_Rec_Type IS RECORD
107: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
108: /* Increased the length of price_formula to 2000, to fix the bug 1539041 */
109: , price_formula_line VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , price_formula_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

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

105:
106: TYPE Formula_Lines_Val_Rec_Type IS RECORD
107: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
108: /* Increased the length of price_formula to 2000, to fix the bug 1539041 */
109: , price_formula_line VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , price_formula_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , price_modifier_list VARCHAR2(240) := FND_API.G_MISS_CHAR
113: );

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

106: TYPE Formula_Lines_Val_Rec_Type IS RECORD
107: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
108: /* Increased the length of price_formula to 2000, to fix the bug 1539041 */
109: , price_formula_line VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , price_formula_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , price_modifier_list VARCHAR2(240) := FND_API.G_MISS_CHAR
113: );
114:

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

107: ( price_formula VARCHAR2(2000) := FND_API.G_MISS_CHAR
108: /* Increased the length of price_formula to 2000, to fix the bug 1539041 */
109: , price_formula_line VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , price_formula_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , price_modifier_list VARCHAR2(240) := FND_API.G_MISS_CHAR
113: );
114:
115: TYPE Formula_Lines_Val_Tbl_Type IS TABLE OF Formula_Lines_Val_Rec_Type

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

108: /* Increased the length of price_formula to 2000, to fix the bug 1539041 */
109: , price_formula_line VARCHAR2(240) := FND_API.G_MISS_CHAR
110: , price_formula_line_type VARCHAR2(240) := FND_API.G_MISS_CHAR
111: , price_list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
112: , price_modifier_list VARCHAR2(240) := FND_API.G_MISS_CHAR
113: );
114:
115: TYPE Formula_Lines_Val_Tbl_Type IS TABLE OF Formula_Lines_Val_Rec_Type
116: INDEX BY BINARY_INTEGER;

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

172: * @rep:displayname Process Price Formula
173: */
174: PROCEDURE Process_Price_Formula
175: ( p_api_version_number IN NUMBER
176: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
178: , p_commit IN VARCHAR2 := FND_API.G_FALSE
179: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

173: */
174: PROCEDURE Process_Price_Formula
175: ( p_api_version_number IN NUMBER
176: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
178: , p_commit IN VARCHAR2 := FND_API.G_FALSE
179: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
181: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

174: PROCEDURE Process_Price_Formula
175: ( p_api_version_number IN NUMBER
176: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
177: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
178: , p_commit IN VARCHAR2 := FND_API.G_FALSE
179: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
181: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
182: , p_FORMULA_rec IN Formula_Rec_Type :=

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

210: -- End of Comments
211:
212: PROCEDURE Lock_Price_Formula
213: ( p_api_version_number IN NUMBER
214: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
215: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
216: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
218: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

211:
212: PROCEDURE Lock_Price_Formula
213: ( p_api_version_number IN NUMBER
214: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
215: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
216: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
217: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
218: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
219: , p_FORMULA_rec IN Formula_Rec_Type :=

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

247: -- End of Comments
248:
249: PROCEDURE Get_Price_Formula
250: ( p_api_version_number IN NUMBER
251: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
252: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
253: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

248:
249: PROCEDURE Get_Price_Formula
250: ( p_api_version_number IN NUMBER
251: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
252: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
253: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
256: , p_price_formula_id IN NUMBER :=

Line 257: FND_API.G_MISS_NUM

253: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
256: , p_price_formula_id IN NUMBER :=
257: FND_API.G_MISS_NUM
258: , p_price_formula IN VARCHAR2 :=
259: FND_API.G_MISS_CHAR
260: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ Formula_Rec_Type
261: , x_FORMULA_val_rec OUT NOCOPY /* file.sql.39 change */ Formula_Val_Rec_Type

Line 259: FND_API.G_MISS_CHAR

255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
256: , p_price_formula_id IN NUMBER :=
257: FND_API.G_MISS_NUM
258: , p_price_formula IN VARCHAR2 :=
259: FND_API.G_MISS_CHAR
260: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ Formula_Rec_Type
261: , x_FORMULA_val_rec OUT NOCOPY /* file.sql.39 change */ Formula_Val_Rec_Type
262: , x_FORMULA_LINES_tbl OUT NOCOPY /* file.sql.39 change */ Formula_Lines_Tbl_Type
263: , x_FORMULA_LINES_val_tbl OUT NOCOPY /* file.sql.39 change */ Formula_Lines_Val_Tbl_Type