9:
10:
11: TYPE SELCRIT_Rec_Type IS RECORD
12: (
13: SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
10:
11: TYPE SELCRIT_Rec_Type IS RECORD
12: (
13: SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
11: TYPE SELCRIT_Rec_Type IS RECORD
12: (
13: SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
12: (
13: SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
13: SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
14: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
15: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
16: , CREATION_DATE DATE := FND_API.G_MISS_DATE
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
17: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
18: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
19: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
20: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
21: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
22: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
23: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
24: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
25: , ATTRIBUTE_ID NUMBER := FND_API.G_MISS_NUM
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
26: , SELECTION_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
27: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
28: , RANK NUMBER := FND_API.G_MISS_NUM
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
29: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
30: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
31: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
32: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
33: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
34: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
35: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
36: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
37: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: );
38: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: );
46:
39: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: );
46:
47: G_MISS_SELCRIT_REC SELCRIT_Rec_Type;
40: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
41: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
42: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
43: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
44: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
45: );
46:
47: G_MISS_SELCRIT_REC SELCRIT_Rec_Type;
48:
48:
49:
50: TYPE RULES_Rec_Type IS RECORD
51: (
52: PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
49:
50: TYPE RULES_Rec_Type IS RECORD
51: (
52: PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
50: TYPE RULES_Rec_Type IS RECORD
51: (
52: PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
51: (
52: PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
52: PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
53: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
54: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , CREATION_DATE DATE := FND_API.G_MISS_DATE
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
56: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
57: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
58: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
59: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
60: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
61: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
62: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
63: , PROCESS_RULE_NAME VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
64: , PARENT_RULE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
65: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
66: , RANK NUMBER := FND_API.G_MISS_NUM
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
67: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
68: , START_DATE DATE := FND_API.G_MISS_DATE
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
69: , END_DATE DATE := FND_API.G_MISS_DATE
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
70: , ACTION VARCHAR2(500) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
71: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
72: , OWNER_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
73: , CURRENCY_CODE VARCHAR2(15) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
74: , LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
75: , SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
76: , DESCRIPTION VARCHAR2(500) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
77: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
78: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
79: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
80: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
81: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
82: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
83: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
84: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
85: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
86: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
87: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: G_MISS_RULES_REC RULES_Rec_Type;
88: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
89: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
90: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
91: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
92: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
93: );
94:
95: G_MISS_RULES_REC RULES_Rec_Type;
96:
96:
97:
98: TYPE ENTYATTMAP_Rec_Type IS RECORD
99: (
100: MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
97:
98: TYPE ENTYATTMAP_Rec_Type IS RECORD
99: (
100: MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
98: TYPE ENTYATTMAP_Rec_Type IS RECORD
99: (
100: MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
99: (
100: MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
100: MAPPING_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
101: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
102: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
103: , CREATION_DATE DATE := FND_API.G_MISS_DATE
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
104: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
105: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
106: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
107: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
108: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
109: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
110: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
111: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
112: , SOURCE_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
113: , SOURCE_ATTR_ID NUMBER := FND_API.G_MISS_NUM
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
114: , TARGET_ATTR_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
115: , TARGET_ATTR_ID NUMBER := FND_API.G_MISS_NUM
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
116: , OPERATOR VARCHAR2(30) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
117: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
118: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
119: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
120: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
121: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
122: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
123: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
124: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
125: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: );
126: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: );
134:
127: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: );
134:
135: G_MISS_ENTYATTMAP_REC ENTYATTMAP_Rec_Type;
128: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
129: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
130: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
131: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
132: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
133: );
134:
135: G_MISS_ENTYATTMAP_REC ENTYATTMAP_Rec_Type;
136:
136:
137:
138: TYPE ENTYRLS_Rec_Type IS RECORD
139: (
140: ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
137:
138: TYPE ENTYRLS_Rec_Type IS RECORD
139: (
140: ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
138: TYPE ENTYRLS_Rec_Type IS RECORD
139: (
140: ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
139: (
140: ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
140: ENTITY_RULE_APPLIED_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
141: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
142: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
143: , CREATION_DATE DATE := FND_API.G_MISS_DATE
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
144: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
145: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
146: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
147: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
148: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
149: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
150: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
151: , ENTITY VARCHAR2(30) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
152: , ENTITY_ID NUMBER := FND_API.G_MISS_NUM
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
153: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
154: , PARENT_PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
155: , LATEST_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
156: , ACTION_VALUE VARCHAR2(15) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
157: , PROCESS_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
158: , WINNING_RULE_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
159: , ENTITY_DETAIL VARCHAR2(100) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
160: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
161: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
162: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
163: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
164: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
165: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
166: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
167: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
168: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176: , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
169: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176: , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
177: );
170: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176: , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
177: );
178:
171: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176: , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
177: );
178:
179: G_MISS_ENTYRLS_REC ENTYRLS_Rec_Type;
172: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
173: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
174: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
175: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
176: , PROCESS_STATUS VARCHAR2(30) := FND_API.G_MISS_CHAR
177: );
178:
179: G_MISS_ENTYRLS_REC ENTYRLS_Rec_Type;
180:
180:
181:
182: TYPE ENTYROUT_Rec_Type IS RECORD
183: (
184: ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
181:
182: TYPE ENTYROUT_Rec_Type IS RECORD
183: (
184: ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
182: TYPE ENTYROUT_Rec_Type IS RECORD
183: (
184: ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
183: (
184: ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
184: ENTITY_ROUTING_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
185: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
186: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
187: , CREATION_DATE DATE := FND_API.G_MISS_DATE
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
188: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
189: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
190: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
191: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
192: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
193: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
194: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
195: , PROCESS_RULE_ID NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
196: , DISTANCE_FROM_CUSTOMER NUMBER := FND_API.G_MISS_NUM
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
197: , DISTANCE_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
198: , MAX_NEAREST_PARTNER NUMBER := FND_API.G_MISS_NUM
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
199: , ROUTING_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
200: , BYPASS_CM_OK_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
201: , CM_TIMEOUT NUMBER := FND_API.G_MISS_NUM
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
202: , CM_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
203: , PARTNER_TIMEOUT NUMBER := FND_API.G_MISS_NUM
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
204: , PARTNER_TIMEOUT_UOM_CODE VARCHAR2(10) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
205: , UNMATCHED_INT_RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
206: , UNMATCHED_CALL_TAP_FLAG VARCHAR2(5) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
207: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
208: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
209: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
210: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
211: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
212: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
213: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
214: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
215: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
223: );
216: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
223: );
224:
217: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
223: );
224:
225: G_MISS_ENTYROUT_REC ENTYROUT_Rec_Type;
218: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
219: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
220: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
221: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
222: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
223: );
224:
225: G_MISS_ENTYROUT_REC ENTYROUT_Rec_Type;
226:
226:
227:
228: TYPE SELATTVAL_Rec_Type IS RECORD
229: (
230: ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
227:
228: TYPE SELATTVAL_Rec_Type IS RECORD
229: (
230: ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
228: TYPE SELATTVAL_Rec_Type IS RECORD
229: (
230: ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
229: (
230: ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
230: ATTR_VALUE_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
231: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
232: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
233: , CREATION_DATE DATE := FND_API.G_MISS_DATE
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
234: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
235: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
236: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
237: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
238: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
239: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
240: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
241: , SELECTION_CRITERIA_ID NUMBER := FND_API.G_MISS_NUM
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
242: , ATTRIBUTE_VALUE VARCHAR2(2000) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
243: , ATTRIBUTE_TO_VALUE VARCHAR2(500) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
244: , ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
245: , ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
246: , ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
247: , ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
248: , ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
249: , ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
250: , ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
251: , ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
252: , ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260: , SCORE NUMBER := FND_API.G_MISS_NUM
253: , ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260: , SCORE NUMBER := FND_API.G_MISS_NUM
261: );
254: , ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260: , SCORE NUMBER := FND_API.G_MISS_NUM
261: );
262:
255: , ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260: , SCORE NUMBER := FND_API.G_MISS_NUM
261: );
262:
263: G_MISS_SELATTVAL_REC SELATTVAL_Rec_Type;
256: , ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR
257: , ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR
258: , ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR
259: , ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
260: , SCORE NUMBER := FND_API.G_MISS_NUM
261: );
262:
263: G_MISS_SELATTVAL_REC SELATTVAL_Rec_Type;
264: