APPS.QP_ATTR_MAP_PUB dependencies on FND_API

Line 7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR

3:
4: -- Pte record type
5:
6: TYPE Pte_Rec_Type IS RECORD
7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

4: -- Pte record type
5:
6: TYPE Pte_Rec_Type IS RECORD
7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 9: , end_date_active DATE := FND_API.G_MISS_DATE

5:
6: TYPE Pte_Rec_Type IS RECORD
7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE

Line 10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR

6: TYPE Pte_Rec_Type IS RECORD
7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR

7: ( description VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR

8: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 13: , start_date_active DATE := FND_API.G_MISS_DATE

9: , end_date_active DATE := FND_API.G_MISS_DATE
10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
17: );

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

10: , lookup_code VARCHAR2(30) := FND_API.G_MISS_CHAR
11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
17: );
18:

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

11: , lookup_type VARCHAR2(30) := FND_API.G_MISS_CHAR
12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
17: );
18:
19: TYPE Pte_Tbl_Type IS TABLE OF Pte_Rec_Type

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

12: , meaning VARCHAR2(80) := FND_API.G_MISS_CHAR
13: , start_date_active DATE := FND_API.G_MISS_DATE
14: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
15: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
17: );
18:
19: TYPE Pte_Tbl_Type IS TABLE OF Pte_Rec_Type
20: INDEX BY BINARY_INTEGER;

Line 25: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR

21:
22: -- Pte value record type
23:
24: TYPE Pte_Val_Rec_Type IS RECORD
25: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , lookup VARCHAR2(240) := FND_API.G_MISS_CHAR
27: );
28:
29: TYPE Pte_Val_Tbl_Type IS TABLE OF Pte_Val_Rec_Type

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

22: -- Pte value record type
23:
24: TYPE Pte_Val_Rec_Type IS RECORD
25: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
26: , lookup VARCHAR2(240) := FND_API.G_MISS_CHAR
27: );
28:
29: TYPE Pte_Val_Tbl_Type IS TABLE OF Pte_Val_Rec_Type
30: INDEX BY BINARY_INTEGER;

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

31:
32: -- Rqt record type
33:
34: TYPE Rqt_Rec_Type IS RECORD
35: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

32: -- Rqt record type
33:
34: TYPE Rqt_Rec_Type IS RECORD
35: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

33:
34: TYPE Rqt_Rec_Type IS RECORD
35: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

34: TYPE Rqt_Rec_Type IS RECORD
35: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

35: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

36: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

37: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

38: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

39: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

40: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

41: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

42: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

43: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM

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

44: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE

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

45: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

46: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 51: , created_by NUMBER := FND_API.G_MISS_NUM

47: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE

Line 52: , creation_date DATE := FND_API.G_MISS_DATE

48: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

49: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 54: , last_updated_by NUMBER := FND_API.G_MISS_NUM

50: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 55: , last_update_date DATE := FND_API.G_MISS_DATE

51: , created_by NUMBER := FND_API.G_MISS_NUM
52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 56: , last_update_login NUMBER := FND_API.G_MISS_NUM

52: , creation_date DATE := FND_API.G_MISS_DATE
53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR

Line 57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR

53: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR

54: , last_updated_by NUMBER := FND_API.G_MISS_NUM
55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM

Line 59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR

55: , last_update_date DATE := FND_API.G_MISS_DATE
56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE

Line 60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR

56: , last_update_login NUMBER := FND_API.G_MISS_NUM
57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 61: , program_application_id NUMBER := FND_API.G_MISS_NUM

57: , line_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 62: , program_id NUMBER := FND_API.G_MISS_NUM

58: , line_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 63: , program_update_date DATE := FND_API.G_MISS_DATE

59: , order_level_global_struct VARCHAR2(80) := FND_API.G_MISS_CHAR
60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

60: , order_level_view_name VARCHAR2(80) := FND_API.G_MISS_CHAR
61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

61: , program_application_id NUMBER := FND_API.G_MISS_NUM
62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

62: , program_id NUMBER := FND_API.G_MISS_NUM
63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

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

63: , program_update_date DATE := FND_API.G_MISS_DATE
64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
71: );

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

64: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
71: );
72:

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

65: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
71: );
72:
73: TYPE Rqt_Tbl_Type IS TABLE OF Rqt_Rec_Type

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

66: , request_type_desc VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , row_id VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
69: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
71: );
72:
73: TYPE Rqt_Tbl_Type IS TABLE OF Rqt_Rec_Type
74: INDEX BY BINARY_INTEGER;

Line 79: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR

75:
76: -- Rqt value record type
77:
78: TYPE Rqt_Val_Rec_Type IS RECORD
79: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , row VARCHAR2(240) := FND_API.G_MISS_CHAR
83: );

Line 80: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR

76: -- Rqt value record type
77:
78: TYPE Rqt_Val_Rec_Type IS RECORD
79: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , row VARCHAR2(240) := FND_API.G_MISS_CHAR
83: );
84:

Line 81: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR

77:
78: TYPE Rqt_Val_Rec_Type IS RECORD
79: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , row VARCHAR2(240) := FND_API.G_MISS_CHAR
83: );
84:
85: TYPE Rqt_Val_Tbl_Type IS TABLE OF Rqt_Val_Rec_Type

Line 82: , row VARCHAR2(240) := FND_API.G_MISS_CHAR

78: TYPE Rqt_Val_Rec_Type IS RECORD
79: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
80: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
81: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
82: , row VARCHAR2(240) := FND_API.G_MISS_CHAR
83: );
84:
85: TYPE Rqt_Val_Tbl_Type IS TABLE OF Rqt_Val_Rec_Type
86: INDEX BY BINARY_INTEGER;

Line 91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR

87:
88: -- Ssc record type
89:
90: TYPE Ssc_Rec_Type IS RECORD
91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

88: -- Ssc record type
89:
90: TYPE Ssc_Rec_Type IS RECORD
91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

89:
90: TYPE Ssc_Rec_Type IS RECORD
91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

90: TYPE Ssc_Rec_Type IS RECORD
91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

91: ( application_short_name VARCHAR2(30) := FND_API.G_MISS_CHAR
92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

92: , attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

93: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

94: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

95: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

96: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

97: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

98: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

99: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

100: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM

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

101: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE

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

102: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

103: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 108: , created_by NUMBER := FND_API.G_MISS_NUM

104: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE

Line 109: , creation_date DATE := FND_API.G_MISS_DATE

105: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM

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

106: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 111: , last_updated_by NUMBER := FND_API.G_MISS_NUM

107: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM

Line 112: , last_update_date DATE := FND_API.G_MISS_DATE

108: , created_by NUMBER := FND_API.G_MISS_NUM
109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE

Line 113: , last_update_login NUMBER := FND_API.G_MISS_NUM

109: , creation_date DATE := FND_API.G_MISS_DATE
110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 114: , program_application_id NUMBER := FND_API.G_MISS_NUM

110: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM

Line 115: , program_id NUMBER := FND_API.G_MISS_NUM

111: , last_updated_by NUMBER := FND_API.G_MISS_NUM
112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 116: , program_update_date DATE := FND_API.G_MISS_DATE

112: , last_update_date DATE := FND_API.G_MISS_DATE
113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

113: , last_update_login NUMBER := FND_API.G_MISS_NUM
114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM

114: , program_application_id NUMBER := FND_API.G_MISS_NUM
115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
122: );

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

115: , program_id NUMBER := FND_API.G_MISS_NUM
116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
122: );
123:

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

116: , program_update_date DATE := FND_API.G_MISS_DATE
117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
122: );
123:
124: TYPE Ssc_Tbl_Type IS TABLE OF Ssc_Rec_Type

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

117: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
119: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
120: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
121: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
122: );
123:
124: TYPE Ssc_Tbl_Type IS TABLE OF Ssc_Rec_Type
125: INDEX BY BINARY_INTEGER;

Line 130: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR

126:
127: -- Ssc value record type
128:
129: TYPE Ssc_Val_Rec_Type IS RECORD
130: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
133: );
134:

Line 131: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR

127: -- Ssc value record type
128:
129: TYPE Ssc_Val_Rec_Type IS RECORD
130: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
133: );
134:
135: TYPE Ssc_Val_Tbl_Type IS TABLE OF Ssc_Val_Rec_Type

Line 132: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR

128:
129: TYPE Ssc_Val_Rec_Type IS RECORD
130: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
131: , pte VARCHAR2(240) := FND_API.G_MISS_CHAR
132: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
133: );
134:
135: TYPE Ssc_Val_Tbl_Type IS TABLE OF Ssc_Val_Rec_Type
136: INDEX BY BINARY_INTEGER;

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

137:
138: -- Psg record type
139:
140: TYPE Psg_Rec_Type IS RECORD
141: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

138: -- Psg record type
139:
140: TYPE Psg_Rec_Type IS RECORD
141: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

139:
140: TYPE Psg_Rec_Type IS RECORD
141: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

140: TYPE Psg_Rec_Type IS RECORD
141: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

141: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

142: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

143: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

144: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

145: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

146: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

147: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

148: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

149: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM

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

150: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE

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

151: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM

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

152: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE

Line 157: , created_by NUMBER := FND_API.G_MISS_NUM

153: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 158: , creation_date DATE := FND_API.G_MISS_DATE

154: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 159: , last_updated_by NUMBER := FND_API.G_MISS_NUM

155: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 160: , last_update_date DATE := FND_API.G_MISS_DATE

156: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 161: , last_update_login NUMBER := FND_API.G_MISS_NUM

157: , created_by NUMBER := FND_API.G_MISS_NUM
158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM

Line 162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

158: , creation_date DATE := FND_API.G_MISS_DATE
159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE

Line 163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

159: , last_updated_by NUMBER := FND_API.G_MISS_NUM
160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 164: , program_application_id NUMBER := FND_API.G_MISS_NUM

160: , last_update_date DATE := FND_API.G_MISS_DATE
161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 165: , program_id NUMBER := FND_API.G_MISS_NUM

161: , last_update_login NUMBER := FND_API.G_MISS_NUM
162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM

Line 166: , program_update_date DATE := FND_API.G_MISS_DATE

162: , limits_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR

Line 167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR

163: , lov_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM

Line 168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR

164: , program_application_id NUMBER := FND_API.G_MISS_NUM
165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 169: , segment_id NUMBER := FND_API.G_MISS_NUM

165: , program_id NUMBER := FND_API.G_MISS_NUM
166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR

166: , program_update_date DATE := FND_API.G_MISS_DATE
167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM

167: , pte_code VARCHAR2(30) := FND_API.G_MISS_CHAR
168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR

168: , seeded_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR

169: , segment_id NUMBER := FND_API.G_MISS_NUM
170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR

170: , segment_level VARCHAR2(10) := FND_API.G_MISS_CHAR
171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
178: );

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

171: , segment_pte_id NUMBER := FND_API.G_MISS_NUM
172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
178: );
179:

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

172: , sourcing_enabled VARCHAR2(1) := FND_API.G_MISS_CHAR
173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
178: );
179:
180: TYPE Psg_Tbl_Type IS TABLE OF Psg_Rec_Type

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

173: , sourcing_status VARCHAR2(1) := FND_API.G_MISS_CHAR
174: , user_sourcing_method VARCHAR2(30) := FND_API.G_MISS_CHAR
175: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
176: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
177: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
178: );
179:
180: TYPE Psg_Tbl_Type IS TABLE OF Psg_Rec_Type
181: INDEX BY BINARY_INTEGER;

Line 186: ( pte VARCHAR2(240) := FND_API.G_MISS_CHAR

182:
183: -- Psg value record type
184:
185: TYPE Psg_Val_Rec_Type IS RECORD
186: ( pte VARCHAR2(240) := FND_API.G_MISS_CHAR
187: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
188: , segment_pte VARCHAR2(240) := FND_API.G_MISS_CHAR
189: );
190:

Line 187: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR

183: -- Psg value record type
184:
185: TYPE Psg_Val_Rec_Type IS RECORD
186: ( pte VARCHAR2(240) := FND_API.G_MISS_CHAR
187: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
188: , segment_pte VARCHAR2(240) := FND_API.G_MISS_CHAR
189: );
190:
191: TYPE Psg_Val_Tbl_Type IS TABLE OF Psg_Val_Rec_Type

Line 188: , segment_pte VARCHAR2(240) := FND_API.G_MISS_CHAR

184:
185: TYPE Psg_Val_Rec_Type IS RECORD
186: ( pte VARCHAR2(240) := FND_API.G_MISS_CHAR
187: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
188: , segment_pte VARCHAR2(240) := FND_API.G_MISS_CHAR
189: );
190:
191: TYPE Psg_Val_Tbl_Type IS TABLE OF Psg_Val_Rec_Type
192: INDEX BY BINARY_INTEGER;

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

193:
194: -- Sou record type
195:
196: TYPE Sou_Rec_Type IS RECORD
197: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

194: -- Sou record type
195:
196: TYPE Sou_Rec_Type IS RECORD
197: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

195:
196: TYPE Sou_Rec_Type IS RECORD
197: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

196: TYPE Sou_Rec_Type IS RECORD
197: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

197: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

198: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

199: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

200: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

201: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

202: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

203: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

204: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM

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

205: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR

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

206: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM

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

207: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM

208: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM

Line 213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR

209: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE

Line 214: , application_id NUMBER := FND_API.G_MISS_NUM

210: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

211: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 216: , created_by NUMBER := FND_API.G_MISS_NUM

212: , attribute_sourcing_id NUMBER := FND_API.G_MISS_NUM
213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE

Line 217: , creation_date DATE := FND_API.G_MISS_DATE

213: , attribute_sourcing_level VARCHAR2(30) := FND_API.G_MISS_CHAR
214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

214: , application_id NUMBER := FND_API.G_MISS_NUM
215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 219: , last_updated_by NUMBER := FND_API.G_MISS_NUM

215: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM

Line 220: , last_update_date DATE := FND_API.G_MISS_DATE

216: , created_by NUMBER := FND_API.G_MISS_NUM
217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE

Line 221: , last_update_login NUMBER := FND_API.G_MISS_NUM

217: , creation_date DATE := FND_API.G_MISS_DATE
218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 222: , program_application_id NUMBER := FND_API.G_MISS_NUM

218: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 223: , program_id NUMBER := FND_API.G_MISS_NUM

219: , last_updated_by NUMBER := FND_API.G_MISS_NUM
220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 224: , program_update_date DATE := FND_API.G_MISS_DATE

220: , last_update_date DATE := FND_API.G_MISS_DATE
221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR

221: , last_update_login NUMBER := FND_API.G_MISS_NUM
222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM

Line 226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

222: , program_application_id NUMBER := FND_API.G_MISS_NUM
223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR

223: , program_id NUMBER := FND_API.G_MISS_NUM
224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR

Line 228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR

224: , program_update_date DATE := FND_API.G_MISS_DATE
225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 229: , segment_id NUMBER := FND_API.G_MISS_NUM

225: , request_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR

226: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR

227: , seeded_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PSG_index NUMBER := FND_API.G_MISS_NUM

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

228: , seeded_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PSG_index NUMBER := FND_API.G_MISS_NUM
236: );

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

229: , segment_id NUMBER := FND_API.G_MISS_NUM
230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PSG_index NUMBER := FND_API.G_MISS_NUM
236: );
237:

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

230: , user_sourcing_type VARCHAR2(30) := FND_API.G_MISS_CHAR
231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PSG_index NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Sou_Tbl_Type IS TABLE OF Sou_Rec_Type

Line 235: , PSG_index NUMBER := FND_API.G_MISS_NUM

231: , user_value_string VARCHAR2(2000) := FND_API.G_MISS_CHAR
232: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
233: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
234: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
235: , PSG_index NUMBER := FND_API.G_MISS_NUM
236: );
237:
238: TYPE Sou_Tbl_Type IS TABLE OF Sou_Rec_Type
239: INDEX BY BINARY_INTEGER;

Line 244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR

240:
241: -- Sou value record type
242:
243: TYPE Sou_Val_Rec_Type IS RECORD
244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR

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

241: -- Sou value record type
242:
243: TYPE Sou_Val_Rec_Type IS RECORD
244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
249: );

Line 246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR

242:
243: TYPE Sou_Val_Rec_Type IS RECORD
244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
249: );
250:

Line 247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR

243: TYPE Sou_Val_Rec_Type IS RECORD
244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
249: );
250:
251: TYPE Sou_Val_Tbl_Type IS TABLE OF Sou_Val_Rec_Type

Line 248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR

244: ( attribute_sourcing VARCHAR2(240) := FND_API.G_MISS_CHAR
245: , enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
246: , request_type VARCHAR2(240) := FND_API.G_MISS_CHAR
247: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
248: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
249: );
250:
251: TYPE Sou_Val_Tbl_Type IS TABLE OF Sou_Val_Rec_Type
252: INDEX BY BINARY_INTEGER;

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

253:
254: -- Fna record type
255:
256: TYPE Fna_Rec_Type IS RECORD
257: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

254: -- Fna record type
255:
256: TYPE Fna_Rec_Type IS RECORD
257: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

255:
256: TYPE Fna_Rec_Type IS RECORD
257: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

256: TYPE Fna_Rec_Type IS RECORD
257: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

257: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

258: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

259: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

260: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

261: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

262: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

263: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR

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

264: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR

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

265: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM

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

266: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE

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

267: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

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

268: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM

Line 273: , created_by NUMBER := FND_API.G_MISS_NUM

269: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM

Line 274: , creation_date DATE := FND_API.G_MISS_DATE

270: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE

Line 275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

271: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM

Line 276: , functional_area_id NUMBER := FND_API.G_MISS_NUM

272: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM

Line 277: , last_updated_by NUMBER := FND_API.G_MISS_NUM

273: , created_by NUMBER := FND_API.G_MISS_NUM
274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM

Line 278: , last_update_date DATE := FND_API.G_MISS_DATE

274: , creation_date DATE := FND_API.G_MISS_DATE
275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE

Line 279: , last_update_login NUMBER := FND_API.G_MISS_NUM

275: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM

Line 280: , program_application_id NUMBER := FND_API.G_MISS_NUM

276: , functional_area_id NUMBER := FND_API.G_MISS_NUM
277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM

Line 281: , program_id NUMBER := FND_API.G_MISS_NUM

277: , last_updated_by NUMBER := FND_API.G_MISS_NUM
278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM

Line 282: , program_update_date DATE := FND_API.G_MISS_DATE

278: , last_update_date DATE := FND_API.G_MISS_DATE
279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM

279: , last_update_login NUMBER := FND_API.G_MISS_NUM
280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM

280: , program_application_id NUMBER := FND_API.G_MISS_NUM
281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

Line 285: , request_id NUMBER := FND_API.G_MISS_NUM

281: , program_id NUMBER := FND_API.G_MISS_NUM
282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR

282: , program_update_date DATE := FND_API.G_MISS_DATE
283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290: , SSC_index NUMBER := FND_API.G_MISS_NUM

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

283: , pte_sourcesystem_fnarea_id NUMBER := FND_API.G_MISS_NUM
284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290: , SSC_index NUMBER := FND_API.G_MISS_NUM
291: );

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

284: , pte_source_system_id NUMBER := FND_API.G_MISS_NUM
285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290: , SSC_index NUMBER := FND_API.G_MISS_NUM
291: );
292:

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

285: , request_id NUMBER := FND_API.G_MISS_NUM
286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290: , SSC_index NUMBER := FND_API.G_MISS_NUM
291: );
292:
293: TYPE Fna_Tbl_Type IS TABLE OF Fna_Rec_Type

Line 290: , SSC_index NUMBER := FND_API.G_MISS_NUM

286: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
287: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
288: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
289: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
290: , SSC_index NUMBER := FND_API.G_MISS_NUM
291: );
292:
293: TYPE Fna_Tbl_Type IS TABLE OF Fna_Rec_Type
294: INDEX BY BINARY_INTEGER;

Line 299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR

295:
296: -- Fna value record type
297:
298: TYPE Fna_Val_Rec_Type IS RECORD
299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR

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

296: -- Fna value record type
297:
298: TYPE Fna_Val_Rec_Type IS RECORD
299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
304: );

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

297:
298: TYPE Fna_Val_Rec_Type IS RECORD
299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
304: );
305:

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

298: TYPE Fna_Val_Rec_Type IS RECORD
299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
304: );
305:
306: TYPE Fna_Val_Tbl_Type IS TABLE OF Fna_Val_Rec_Type

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

299: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
300: , functional_area VARCHAR2(240) := FND_API.G_MISS_CHAR
301: , pte_sourcesystem_fnarea VARCHAR2(240) := FND_API.G_MISS_CHAR
302: , pte_source_system VARCHAR2(240) := FND_API.G_MISS_CHAR
303: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
304: );
305:
306: TYPE Fna_Val_Tbl_Type IS TABLE OF Fna_Val_Rec_Type
307: INDEX BY BINARY_INTEGER;

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

351: -- End of Comments
352:
353: PROCEDURE Process_Attr_Mapping
354: ( p_api_version_number IN NUMBER
355: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
357: , p_commit IN VARCHAR2 := FND_API.G_FALSE
358: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

352:
353: PROCEDURE Process_Attr_Mapping
354: ( p_api_version_number IN NUMBER
355: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
357: , p_commit IN VARCHAR2 := FND_API.G_FALSE
358: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
360: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

353: PROCEDURE Process_Attr_Mapping
354: ( p_api_version_number IN NUMBER
355: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
356: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
357: , p_commit IN VARCHAR2 := FND_API.G_FALSE
358: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
359: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
360: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
361: , p_PTE_rec IN Pte_Rec_Type :=

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

413: -- End of Comments
414:
415: PROCEDURE Process_Attr_Mapping
416: ( p_api_version_number IN NUMBER
417: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
418: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
419: , p_commit IN VARCHAR2 := FND_API.G_FALSE
420: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

414:
415: PROCEDURE Process_Attr_Mapping
416: ( p_api_version_number IN NUMBER
417: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
418: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
419: , p_commit IN VARCHAR2 := FND_API.G_FALSE
420: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
422: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

415: PROCEDURE Process_Attr_Mapping
416: ( p_api_version_number IN NUMBER
417: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
418: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
419: , p_commit IN VARCHAR2 := FND_API.G_FALSE
420: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
421: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
422: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
423: , p_PTE_rec IN Pte_Rec_Type :=

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

473: -- End of Comments
474:
475: PROCEDURE Lock_Attr_Mapping
476: ( p_api_version_number IN NUMBER
477: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
478: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
479: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
480: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
481: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

474:
475: PROCEDURE Lock_Attr_Mapping
476: ( p_api_version_number IN NUMBER
477: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
478: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
479: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
480: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
481: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
482: , p_PTE_rec IN Pte_Rec_Type :=

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

534: -- End of Comments
535:
536: PROCEDURE Lock_Attr_Mapping
537: ( p_api_version_number IN NUMBER
538: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
539: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
540: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
542: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

535:
536: PROCEDURE Lock_Attr_Mapping
537: ( p_api_version_number IN NUMBER
538: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
539: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
540: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
541: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
542: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
543: , p_PTE_rec IN Pte_Rec_Type :=

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

593: -- End of Comments
594:
595: PROCEDURE Get_Attr_Mapping
596: ( p_api_version_number IN NUMBER
597: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
599: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
600: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
601: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

594:
595: PROCEDURE Get_Attr_Mapping
596: ( p_api_version_number IN NUMBER
597: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
598: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
599: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
600: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
601: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602: , p_lookup_code IN VARCHAR2 :=

Line 603: FND_API.G_MISS_CHAR

599: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
600: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
601: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602: , p_lookup_code IN VARCHAR2 :=
603: FND_API.G_MISS_CHAR
604: , p_lookup IN VARCHAR2 :=
605: FND_API.G_MISS_CHAR
606: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
607: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type

Line 605: FND_API.G_MISS_CHAR

601: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
602: , p_lookup_code IN VARCHAR2 :=
603: FND_API.G_MISS_CHAR
604: , p_lookup IN VARCHAR2 :=
605: FND_API.G_MISS_CHAR
606: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
607: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
608: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
609: , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type

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

634: -- End of Comments
635:
636: PROCEDURE Get_Attr_Mapping
637: ( p_api_version_number IN NUMBER
638: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
640: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
641: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
642: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

635:
636: PROCEDURE Get_Attr_Mapping
637: ( p_api_version_number IN NUMBER
638: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
639: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
640: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
641: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
642: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
643: , p_lookup_code IN VARCHAR2 :=

Line 644: FND_API.G_MISS_CHAR

640: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
641: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
642: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
643: , p_lookup_code IN VARCHAR2 :=
644: FND_API.G_MISS_CHAR
645: , p_lookup IN VARCHAR2 :=
646: FND_API.G_MISS_CHAR
647: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
648: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type

Line 646: FND_API.G_MISS_CHAR

642: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
643: , p_lookup_code IN VARCHAR2 :=
644: FND_API.G_MISS_CHAR
645: , p_lookup IN VARCHAR2 :=
646: FND_API.G_MISS_CHAR
647: , x_PTE_rec OUT NOCOPY /* file.sql.39 change */ Pte_Rec_Type
648: , x_PTE_val_rec OUT NOCOPY /* file.sql.39 change */ Pte_Val_Rec_Type
649: , x_RQT_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Tbl_Type
650: , x_RQT_val_tbl OUT NOCOPY /* file.sql.39 change */ Rqt_Val_Tbl_Type