3:
4: -- Con record type
5:
6: TYPE Con_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
4: -- Con record type
5:
6: TYPE Con_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
5:
6: TYPE Con_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
6: TYPE Con_Rec_Type IS RECORD
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
7: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
8: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
9: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
10: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
11: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
12: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
13: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
14: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
15: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
16: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
17: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
18: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
19: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
20: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
21: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
22: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
23: , created_by NUMBER := FND_API.G_MISS_NUM
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
24: , creation_date DATE := FND_API.G_MISS_DATE
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
25: , enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
26: , last_updated_by NUMBER := FND_API.G_MISS_NUM
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
27: , last_update_date DATE := FND_API.G_MISS_DATE
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
28: , last_update_login NUMBER := FND_API.G_MISS_NUM
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
29: , prc_context_code VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
30: , prc_context_id NUMBER := FND_API.G_MISS_NUM
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
31: , prc_context_type VARCHAR2(30) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
32: , program_application_id NUMBER := FND_API.G_MISS_NUM
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
33: , program_id NUMBER := FND_API.G_MISS_NUM
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
34: , program_update_date DATE := FND_API.G_MISS_DATE
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
35: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
43: );
36: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
43: );
44:
37: , seeded_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
43: );
44:
45: TYPE Con_Tbl_Type IS TABLE OF Con_Rec_Type
38: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
39: , user_prc_context_name VARCHAR2(240) := FND_API.G_MISS_CHAR
40: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
41: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
42: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
43: );
44:
45: TYPE Con_Tbl_Type IS TABLE OF Con_Rec_Type
46: INDEX BY BINARY_INTEGER;
47:
48: -- Con value record type
49:
50: TYPE Con_Val_Rec_Type IS RECORD
51: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
54: );
55:
48: -- Con value record type
49:
50: TYPE Con_Val_Rec_Type IS RECORD
51: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
54: );
55:
56: TYPE Con_Val_Tbl_Type IS TABLE OF Con_Val_Rec_Type
49:
50: TYPE Con_Val_Rec_Type IS RECORD
51: ( enabled VARCHAR2(240) := FND_API.G_MISS_CHAR
52: , prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
53: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
54: );
55:
56: TYPE Con_Val_Tbl_Type IS TABLE OF Con_Val_Rec_Type
57: INDEX BY BINARY_INTEGER;
58:
59: -- Seg record type
60:
61: TYPE Seg_Rec_Type IS RECORD
62: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
59: -- Seg record type
60:
61: TYPE Seg_Rec_Type IS RECORD
62: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
60:
61: TYPE Seg_Rec_Type IS RECORD
62: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
61: TYPE Seg_Rec_Type IS RECORD
62: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
62: ( attribute1 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
63: , attribute10 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
64: , attribute11 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
65: , attribute12 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
66: , attribute13 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
67: , attribute14 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
68: , attribute15 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
69: , attribute2 VARCHAR2(240) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
70: , attribute3 VARCHAR2(240) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
71: , attribute4 VARCHAR2(240) := FND_API.G_MISS_CHAR
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
72: , attribute5 VARCHAR2(240) := FND_API.G_MISS_CHAR
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
73: , attribute6 VARCHAR2(240) := FND_API.G_MISS_CHAR
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
74: , attribute7 VARCHAR2(240) := FND_API.G_MISS_CHAR
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
75: , attribute8 VARCHAR2(240) := FND_API.G_MISS_CHAR
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
76: , attribute9 VARCHAR2(240) := FND_API.G_MISS_CHAR
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
77: , availability_in_basic VARCHAR2(1) := FND_API.G_MISS_CHAR
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
78: , context VARCHAR2(30) := FND_API.G_MISS_CHAR
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
79: , created_by NUMBER := FND_API.G_MISS_NUM
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
80: , creation_date DATE := FND_API.G_MISS_DATE
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
81: , last_updated_by NUMBER := FND_API.G_MISS_NUM
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
82: , last_update_date DATE := FND_API.G_MISS_DATE
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
83: , last_update_login NUMBER := FND_API.G_MISS_NUM
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
84: , prc_context_id NUMBER := FND_API.G_MISS_NUM
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
85: , program_application_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
86: , program_id NUMBER := FND_API.G_MISS_NUM
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
87: , program_update_date DATE := FND_API.G_MISS_DATE
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
88: , seeded_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
89: , seeded_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
90: , seeded_precedence NUMBER := FND_API.G_MISS_NUM
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
91: , seeded_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
92: , seeded_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
93: , seeded_valueset_id NUMBER := FND_API.G_MISS_NUM
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
94: , segment_code VARCHAR2(30) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
95: , segment_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
96: -- Added application_id by : Abhijit
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
97: , application_id NUMBER := FND_API.G_MISS_NUM
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
98: , segment_mapping_column VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
99: , user_format_type VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
100: , user_precedence NUMBER := FND_API.G_MISS_NUM
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
101: , user_segment_name VARCHAR2(80) := FND_API.G_MISS_CHAR
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
109: );
102: , user_description VARCHAR2(2000) := FND_API.G_MISS_CHAR
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
109: );
110:
103: , user_valueset_id NUMBER := FND_API.G_MISS_NUM
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
109: );
110:
111: TYPE Seg_Tbl_Type IS TABLE OF Seg_Rec_Type
104: , return_status VARCHAR2(1) := FND_API.G_MISS_CHAR
105: , db_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
106: , operation VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , required_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
108: , party_hierarchy_enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR -- Added for TCA
109: );
110:
111: TYPE Seg_Tbl_Type IS TABLE OF Seg_Rec_Type
112: INDEX BY BINARY_INTEGER;
113:
114: -- Seg value record type
115:
116: TYPE Seg_Val_Rec_Type IS RECORD
117: ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
114: -- Seg value record type
115:
116: TYPE Seg_Val_Rec_Type IS RECORD
117: ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
122: );
115:
116: TYPE Seg_Val_Rec_Type IS RECORD
117: ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
122: );
123:
116: TYPE Seg_Val_Rec_Type IS RECORD
117: ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
122: );
123:
124: TYPE Seg_Val_Tbl_Type IS TABLE OF Seg_Val_Rec_Type
117: ( prc_context VARCHAR2(240) := FND_API.G_MISS_CHAR
118: , seeded VARCHAR2(240) := FND_API.G_MISS_CHAR
119: , seeded_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
120: , segment VARCHAR2(240) := FND_API.G_MISS_CHAR
121: , user_valueset VARCHAR2(240) := FND_API.G_MISS_CHAR
122: );
123:
124: TYPE Seg_Val_Tbl_Type IS TABLE OF Seg_Val_Rec_Type
125: INDEX BY BINARY_INTEGER;
152: -- End of Comments
153:
154: PROCEDURE Process_Attributes
155: ( p_api_version_number IN NUMBER
156: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
158: , p_commit IN VARCHAR2 := FND_API.G_FALSE
159: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
153:
154: PROCEDURE Process_Attributes
155: ( p_api_version_number IN NUMBER
156: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
158: , p_commit IN VARCHAR2 := FND_API.G_FALSE
159: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
161: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
154: PROCEDURE Process_Attributes
155: ( p_api_version_number IN NUMBER
156: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
157: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
158: , p_commit IN VARCHAR2 := FND_API.G_FALSE
159: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
161: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
162: , p_CON_rec IN Con_Rec_Type :=
190: -- End of Comments
191:
192: PROCEDURE Lock_Attributes
193: ( p_api_version_number IN NUMBER
194: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
195: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
196: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
198: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
191:
192: PROCEDURE Lock_Attributes
193: ( p_api_version_number IN NUMBER
194: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
195: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
196: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
197: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
198: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
199: , p_CON_rec IN Con_Rec_Type :=
227: -- End of Comments
228:
229: PROCEDURE Get_Attributes
230: ( p_api_version_number IN NUMBER
231: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
232: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
233: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
234: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
235: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
228:
229: PROCEDURE Get_Attributes
230: ( p_api_version_number IN NUMBER
231: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
232: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
233: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
234: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
235: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236: , p_prc_context_id IN NUMBER :=
233: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
234: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
235: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236: , p_prc_context_id IN NUMBER :=
237: FND_API.G_MISS_NUM
238: , p_prc_context IN VARCHAR2 :=
239: FND_API.G_MISS_CHAR
240: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
241: , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
235: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
236: , p_prc_context_id IN NUMBER :=
237: FND_API.G_MISS_NUM
238: , p_prc_context IN VARCHAR2 :=
239: FND_API.G_MISS_CHAR
240: , x_CON_rec OUT NOCOPY /* file.sql.39 change */ Con_Rec_Type
241: , x_CON_val_rec OUT NOCOPY /* file.sql.39 change */ Con_Val_Rec_Type
242: , x_SEG_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Tbl_Type
243: , x_SEG_val_tbl OUT NOCOPY /* file.sql.39 change */ Seg_Val_Tbl_Type