APPS.QP_QUALIFIER_RULES_PUB dependencies on FND_API

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

11:
12: -- Qualifier_Rules record type
13:
14: TYPE Qualifier_Rules_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: -- Qualifier_Rules record type
13:
14: TYPE Qualifier_Rules_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 Qualifier_Rules_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 Qualifier_Rules_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: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE

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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM

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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 34: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 35: , last_update_date DATE := FND_API.G_MISS_DATE

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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM

Line 36: , last_update_login 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: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE

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

33: , description VARCHAR2(2000) := FND_API.G_MISS_CHAR
34: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

Line 38: , program_application_id NUMBER := FND_API.G_MISS_NUM

34: , last_updated_by NUMBER := FND_API.G_MISS_NUM
35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM

Line 39: , program_id NUMBER := FND_API.G_MISS_NUM

35: , last_update_date DATE := FND_API.G_MISS_DATE
36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 40: , program_update_date DATE := FND_API.G_MISS_DATE

36: , last_update_login NUMBER := FND_API.G_MISS_NUM
37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
43: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
44: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

37: , name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
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: , request_id NUMBER := FND_API.G_MISS_NUM

38: , program_application_id NUMBER := FND_API.G_MISS_NUM
39: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
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: , program_id NUMBER := FND_API.G_MISS_NUM
40: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
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: , program_update_date DATE := FND_API.G_MISS_DATE
41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
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 Qualifier_Rules_Tbl_Type IS TABLE OF Qualifier_Rules_Rec_Type

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

41: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
42: , request_id NUMBER := FND_API.G_MISS_NUM
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 Qualifier_Rules_Tbl_Type IS TABLE OF Qualifier_Rules_Rec_Type
49: INDEX BY BINARY_INTEGER;

Line 54: ( qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

50:
51: -- Qualifier_Rules value record type
52:
53: TYPE Qualifier_Rules_Val_Rec_Type IS RECORD
54: ( qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
55: );
56:
57: TYPE Qualifier_Rules_Val_Tbl_Type IS TABLE OF Qualifier_Rules_Val_Rec_Type
58: INDEX BY BINARY_INTEGER;

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

59:
60: -- Qualifiers record type
61:
62: TYPE Qualifiers_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: -- Qualifiers record type
61:
62: TYPE Qualifiers_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 Qualifiers_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 Qualifiers_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: , comparison_operator_code 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: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM

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: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM

Line 78: , comparison_operator_code 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: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE

Line 79: , context VARCHAR2(30) := 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: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE

Line 80: , created_by NUMBER := FND_API.G_MISS_NUM

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

Line 81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM

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

Line 82: , creation_date DATE := FND_API.G_MISS_DATE

78: , comparison_operator_code VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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

Line 83: , end_date_active DATE := FND_API.G_MISS_DATE

79: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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

Line 84: , excluder_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

80: , created_by NUMBER := FND_API.G_MISS_NUM
81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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: , list_header_id NUMBER := FND_API.G_MISS_NUM

Line 85: , last_updated_by NUMBER := FND_API.G_MISS_NUM

81: , created_from_rule_id NUMBER := FND_API.G_MISS_NUM
82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM

Line 86: , last_update_date DATE := FND_API.G_MISS_DATE

82: , creation_date DATE := FND_API.G_MISS_DATE
83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 87: , last_update_login NUMBER := FND_API.G_MISS_NUM

83: , end_date_active DATE := FND_API.G_MISS_DATE
84: , excluder_flag VARCHAR2(1) := 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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM

Line 88: , list_header_id NUMBER := FND_API.G_MISS_NUM

84: , excluder_flag VARCHAR2(1) := 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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE

Line 89: , list_line_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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 90: , program_application_id 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: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 91: , program_id NUMBER := FND_API.G_MISS_NUM

87: , last_update_login NUMBER := FND_API.G_MISS_NUM
88: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 92: , program_update_date DATE := FND_API.G_MISS_DATE

88: , list_header_id NUMBER := FND_API.G_MISS_NUM
89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR

89: , list_line_id NUMBER := FND_API.G_MISS_NUM
90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR

90: , program_application_id NUMBER := FND_API.G_MISS_NUM
91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM

Line 95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR

91: , program_id NUMBER := FND_API.G_MISS_NUM
92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM

Line 96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR

92: , program_update_date DATE := FND_API.G_MISS_DATE
93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM

Line 97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR

93: , qualifier_attribute VARCHAR2(30) := FND_API.G_MISS_CHAR
94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

Line 98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM

94: , qualifier_attr_value VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM

Line 99: , qualifier_id NUMBER := FND_API.G_MISS_NUM

95: , qualifier_attr_value_to VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE

Line 100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM

96: , qualifier_context VARCHAR2(30) := FND_API.G_MISS_CHAR
97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM

97: , qualifier_datatype VARCHAR2(10) := FND_API.G_MISS_CHAR
98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

Line 102: , request_id NUMBER := FND_API.G_MISS_NUM

98: , qualifier_grouping_no NUMBER := FND_API.G_MISS_NUM
99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

Line 103: , start_date_active DATE := FND_API.G_MISS_DATE

99: , qualifier_id NUMBER := FND_API.G_MISS_NUM
100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

100: , qualifier_precedence NUMBER := FND_API.G_MISS_NUM
101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM

Line 105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM

101: , qualifier_rule_id NUMBER := FND_API.G_MISS_NUM
102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM

Line 106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM

102: , request_id NUMBER := FND_API.G_MISS_NUM
103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

103: , start_date_active DATE := FND_API.G_MISS_DATE
104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM

Line 108: , search_ind NUMBER := FND_API.G_MISS_NUM

104: , list_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM

105: , qual_attr_value_from_number NUMBER := FND_API.G_MISS_NUM
106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

106: , qual_attr_value_to_number NUMBER := FND_API.G_MISS_NUM
107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM

107: , active_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA

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

108: , search_ind NUMBER := FND_API.G_MISS_NUM
109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
116: );

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

109: , qualifier_group_cnt NUMBER := FND_API.G_MISS_NUM
110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
116: );
117:

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

110: , header_quals_exist_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
116: );
117:
118: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type

Line 115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA

111: , distinct_row_count NUMBER := FND_API.G_MISS_NUM
112: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
113: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
114: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , qualify_hier_descendent_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
116: );
117:
118: TYPE Qualifiers_Tbl_Type IS TABLE OF Qualifiers_Rec_Type
119: INDEX BY BINARY_INTEGER;

Line 124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR

120:
121: -- Qualifiers value record type
122:
123: /*TYPE Qualifiers_Val_Rec_Type IS RECORD
124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

121: -- Qualifiers value record type
122:
123: /*TYPE Qualifiers_Val_Rec_Type IS RECORD
124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR

122:
123: /*TYPE Qualifiers_Val_Rec_Type IS RECORD
124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

123: /*TYPE Qualifiers_Val_Rec_Type IS RECORD
124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
131: );*/

Line 128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

124: ( comparison_operator VARCHAR2(240) := FND_API.G_MISS_CHAR
125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
131: );*/
132:

Line 129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR

125: , created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
131: );*/
132:
133: TYPE Qualifiers_Val_Rec_Type IS RECORD

Line 130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

126: , excluder VARCHAR2(240) := FND_API.G_MISS_CHAR
127: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
128: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
129: , qualifier VARCHAR2(240) := FND_API.G_MISS_CHAR
130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
131: );*/
132:
133: TYPE Qualifiers_Val_Rec_Type IS RECORD
134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR

130: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
131: );*/
132:
133: TYPE Qualifiers_Val_Rec_Type IS RECORD
134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR

131: );*/
132:
133: TYPE Qualifiers_Val_Rec_Type IS RECORD
134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR

132:
133: TYPE Qualifiers_Val_Rec_Type IS RECORD
134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , qualifier_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

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

133: TYPE Qualifiers_Val_Rec_Type IS RECORD
134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , qualifier_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
141: );

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

134: ( created_from_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , qualifier_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
141: );
142:

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

135: , list_header VARCHAR2(240) := FND_API.G_MISS_CHAR
136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , qualifier_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
141: );
142:
143: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type

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

136: , list_line VARCHAR2(240) := FND_API.G_MISS_CHAR
137: , qualifier_rule VARCHAR2(240) := FND_API.G_MISS_CHAR
138: , qualifier_attribute_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
139: , qualifier_attr_value_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
140: , qualifier_attr_value_to_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
141: );
142:
143: TYPE Qualifiers_Val_Tbl_Type IS TABLE OF Qualifiers_Val_Rec_Type
144: INDEX BY BINARY_INTEGER;

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

170: Entity_index Number := NULL,
171: -- Request types as defined in qp_globals
172: request_type Varchar2(30) := NULL,
173:
174: return_status VARCHAR2(1) := FND_API.G_MISS_CHAR,
175:
176: -- Keys to identify a unique request.
177: request_unique_key1 VARCHAR2(30) := NULL,
178: request_unique_key2 VARCHAR2(30) := NULL,

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

292: * @rep:displayname Process Qualifier Rule
293: */
294: PROCEDURE Process_Qualifier_Rules
295: ( p_api_version_number IN NUMBER
296: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
297: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
300: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

293: */
294: PROCEDURE Process_Qualifier_Rules
295: ( p_api_version_number IN NUMBER
296: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
297: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
300: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
301: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

294: PROCEDURE Process_Qualifier_Rules
295: ( p_api_version_number IN NUMBER
296: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
297: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
298: , p_commit IN VARCHAR2 := FND_API.G_FALSE
299: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
300: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
301: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
302: , p_QUALIFIER_RULES_rec IN Qualifier_Rules_Rec_Type :=

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

330: -- End of Comments
331:
332: PROCEDURE Lock_Qualifier_Rules
333: ( p_api_version_number IN NUMBER
334: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
335: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
336: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
338: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

331:
332: PROCEDURE Lock_Qualifier_Rules
333: ( p_api_version_number IN NUMBER
334: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
335: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
336: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
337: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
338: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
339: , p_QUALIFIER_RULES_rec IN Qualifier_Rules_Rec_Type :=

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

367: -- End of Comments
368:
369: PROCEDURE Get_Qualifier_Rules
370: ( p_api_version_number IN NUMBER
371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
372: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
373: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
375: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

368:
369: PROCEDURE Get_Qualifier_Rules
370: ( p_api_version_number IN NUMBER
371: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
372: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
373: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
375: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
376: , p_qualifier_rule_id IN NUMBER :=

Line 377: FND_API.G_MISS_NUM

373: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
374: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
375: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
376: , p_qualifier_rule_id IN NUMBER :=
377: FND_API.G_MISS_NUM
378: , p_qualifier_rule IN VARCHAR2 :=
379: FND_API.G_MISS_CHAR
380: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ Qualifier_Rules_Rec_Type
381: , x_QUALIFIER_RULES_val_rec OUT NOCOPY /* file.sql.39 change */ Qualifier_Rules_Val_Rec_Type

Line 379: FND_API.G_MISS_CHAR

375: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
376: , p_qualifier_rule_id IN NUMBER :=
377: FND_API.G_MISS_NUM
378: , p_qualifier_rule IN VARCHAR2 :=
379: FND_API.G_MISS_CHAR
380: , x_QUALIFIER_RULES_rec OUT NOCOPY /* file.sql.39 change */ Qualifier_Rules_Rec_Type
381: , x_QUALIFIER_RULES_val_rec OUT NOCOPY /* file.sql.39 change */ Qualifier_Rules_Val_Rec_Type
382: , x_QUALIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Qualifiers_Tbl_Type
383: , x_QUALIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Qualifiers_Val_Tbl_Type

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

385:
386:
387: PROCEDURE Copy_Qualifier_rule
388: ( p_api_version_number IN NUMBER
389: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
390: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
391: , p_commit IN VARCHAR2 := FND_API.G_FALSE
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

386:
387: PROCEDURE Copy_Qualifier_rule
388: ( p_api_version_number IN NUMBER
389: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
390: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
391: , p_commit IN VARCHAR2 := FND_API.G_FALSE
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

387: PROCEDURE Copy_Qualifier_rule
388: ( p_api_version_number IN NUMBER
389: , p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE
390: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
391: , p_commit IN VARCHAR2 := FND_API.G_FALSE
392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_qualifier_rule_id IN NUMBER :=

Line 396: FND_API.G_MISS_NUM

392: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
393: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_qualifier_rule_id IN NUMBER :=
396: FND_API.G_MISS_NUM
397: , p_qualifier_rule IN VARCHAR2 :=
398: FND_API.G_MISS_CHAR
399: , p_to_qualifier_rule IN VARCHAR2
400: , p_to_description IN VARCHAR2 :=FND_API.G_MISS_CHAR

Line 398: FND_API.G_MISS_CHAR

394: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
395: , p_qualifier_rule_id IN NUMBER :=
396: FND_API.G_MISS_NUM
397: , p_qualifier_rule IN VARCHAR2 :=
398: FND_API.G_MISS_CHAR
399: , p_to_qualifier_rule IN VARCHAR2
400: , p_to_description IN VARCHAR2 :=FND_API.G_MISS_CHAR
401: , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
402: );

Line 400: , p_to_description IN VARCHAR2 :=FND_API.G_MISS_CHAR

396: FND_API.G_MISS_NUM
397: , p_qualifier_rule IN VARCHAR2 :=
398: FND_API.G_MISS_CHAR
399: , p_to_qualifier_rule IN VARCHAR2
400: , p_to_description IN VARCHAR2 :=FND_API.G_MISS_CHAR
401: , x_qualifier_rule_id OUT NOCOPY /* file.sql.39 change */ NUMBER
402: );
403:
404: