85: -- End of Comments
86:
87: TYPE Score_Rec_Type IS RECORD
88: (
89: score_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
86:
87: TYPE Score_Rec_Type IS RECORD
88: (
89: score_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
87: TYPE Score_Rec_Type IS RECORD
88: (
89: score_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
88: (
89: score_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
89: score_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
90: last_update_date DATE := FND_API.G_MISS_DATE,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
91: last_updated_by NUMBER := FND_API.G_MISS_NUM,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: creation_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
93: created_by NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
94: last_update_login NUMBER := FND_API.G_MISS_NUM,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
95: object_version_number NUMBER := FND_API.G_MISS_NUM,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
96: org_id NUMBER := FND_API.G_MISS_NUM,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
97: model_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
98: user_status_id NUMBER := FND_API.G_MISS_NUM,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
99: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
100: status_date DATE := FND_API.G_MISS_DATE,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
101: owner_user_id NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
102: results_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
103: logs_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
104: scheduled_date DATE := FND_API.G_MISS_DATE,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: scheduled_timezone_id NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
106: score_date DATE := FND_API.G_MISS_DATE,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
107: expiration_date DATE := FND_API.G_MISS_DATE,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
108: total_records NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
109: total_positives NUMBER := FND_API.G_MISS_NUM,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
110: min_records NUMBER := FND_API.G_MISS_NUM,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
111: max_records NUMBER := FND_API.G_MISS_NUM,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
112: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: every_nth_row NUMBER := FND_API.G_MISS_NUM,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
114: pct_random NUMBER := FND_API.G_MISS_NUM,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
115: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
116: country_id NUMBER := FND_API.G_MISS_NUM,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
117: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
118: score_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
119: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
120: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
128: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: );
129: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: );
137:
130: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: );
137:
138: G_MISS_Score_REC Score_Rec_Type;
131: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR
136: );
137:
138: G_MISS_Score_REC Score_Rec_Type;
139: TYPE DM_score_Tbl_Type IS TABLE OF Score_Rec_Type INDEX BY BINARY_INTEGER;
164: -- Pre-Req :
165: -- Parameters:
166: -- IN
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
169: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
171: -- P_Score_Rec IN Score_Rec_Type Required
172: --
165: -- Parameters:
166: -- IN
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
169: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
171: -- P_Score_Rec IN Score_Rec_Type Required
172: --
173: -- OUT:
166: -- IN
167: -- p_api_version IN NUMBER Required
168: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
169: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
170: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
171: -- P_Score_Rec IN Score_Rec_Type Required
172: --
173: -- OUT:
174: -- x_return_status OUT VARCHAR2
181: -- End of Comments
182: --
183: PROCEDURE Lock_Score(
184: p_api_version IN NUMBER,
185: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
186: x_return_status OUT NOCOPY VARCHAR2,
187: x_msg_count OUT NOCOPY NUMBER,
188: x_msg_data OUT NOCOPY VARCHAR2,
189: p_score_id IN NUMBER,
198: -- Pre-Req :
199: -- Parameters:
200: -- IN
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
203: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
205: -- P_Score_Rec IN Score_Rec_Type Required
206: --
199: -- Parameters:
200: -- IN
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
203: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
205: -- P_Score_Rec IN Score_Rec_Type Required
206: --
207: -- OUT:
200: -- IN
201: -- p_api_version IN NUMBER Required
202: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
203: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
204: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
205: -- P_Score_Rec IN Score_Rec_Type Required
206: --
207: -- OUT:
208: -- x_return_status OUT VARCHAR2
215: -- End of Comments
216: --
217: PROCEDURE Create_Score(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
216: --
217: PROCEDURE Create_Score(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
217: PROCEDURE Create_Score(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
220: p_commit IN VARCHAR2 := FND_API.G_FALSE,
221: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
222: x_return_status OUT NOCOPY VARCHAR2,
223: x_msg_count OUT NOCOPY NUMBER,
224: x_msg_data OUT NOCOPY VARCHAR2,
225: p_Score_rec IN Score_Rec_Type := G_MISS_Score_REC,
235: -- Pre-Req :
236: -- Parameters:
237: -- IN
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- P_Score_Rec IN Score_Rec_Type Required
243: --
236: -- Parameters:
237: -- IN
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- P_Score_Rec IN Score_Rec_Type Required
243: --
244: -- OUT:
237: -- IN
238: -- p_api_version IN NUMBER Required
239: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
240: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
241: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
242: -- P_Score_Rec IN Score_Rec_Type Required
243: --
244: -- OUT:
245: -- x_return_status OUT VARCHAR2
252: -- End of Comments
253: --
254: PROCEDURE Update_Score(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
253: --
254: PROCEDURE Update_Score(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
254: PROCEDURE Update_Score(
255: p_api_version IN NUMBER,
256: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
259: x_return_status OUT NOCOPY VARCHAR2,
260: x_msg_count OUT NOCOPY NUMBER,
261: x_msg_data OUT NOCOPY VARCHAR2,
262: p_Score_rec IN Score_Rec_Type,
271: -- Pre-Req :
272: -- Parameters:
273: -- IN
274: -- p_api_version IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_score_ID IN NUMBER
279: -- p_object_version_number IN NUMBER Optional Default = NULL
272: -- Parameters:
273: -- IN
274: -- p_api_version IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_score_ID IN NUMBER
279: -- p_object_version_number IN NUMBER Optional Default = NULL
280: --
273: -- IN
274: -- p_api_version IN NUMBER Required
275: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
276: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
277: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
278: -- p_score_ID IN NUMBER
279: -- p_object_version_number IN NUMBER Optional Default = NULL
280: --
281: -- OUT:
289: -- End of Comments
290: --
291: PROCEDURE Delete_Score(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_commit IN VARCHAR2 := FND_API.G_FALSE,
295: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
290: --
291: PROCEDURE Delete_Score(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_commit IN VARCHAR2 := FND_API.G_FALSE,
295: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
291: PROCEDURE Delete_Score(
292: p_api_version IN NUMBER,
293: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
294: p_commit IN VARCHAR2 := FND_API.G_FALSE,
295: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
296: x_return_status OUT NOCOPY VARCHAR2,
297: x_msg_count OUT NOCOPY NUMBER,
298: x_msg_data OUT NOCOPY VARCHAR2,
299: p_score_id IN NUMBER,
313: -- End of Comments
314:
315: PROCEDURE Validate_Score_rec(
316: p_api_version IN NUMBER,
317: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
318: p_validation_mode IN VARCHAR2,
319: x_return_status OUT NOCOPY VARCHAR2,
320: x_msg_count OUT NOCOPY NUMBER,
321: x_msg_data OUT NOCOPY VARCHAR2,
334: -- End of Comments
335:
336: PROCEDURE Validate_Score(
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_validation_mode IN VARCHAR2,
341: p_Score_rec IN Score_Rec_Type,
342: x_return_status OUT NOCOPY VARCHAR2,
335:
336: PROCEDURE Validate_Score(
337: p_api_version IN NUMBER,
338: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
339: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
340: p_validation_mode IN VARCHAR2,
341: p_Score_rec IN Score_Rec_Type,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,
405: -- the new object. The ID is used by the UI to render the detail
406: -- page which follows a copy operation.
407: PROCEDURE copy_score (
408: p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410: p_commit IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
406: -- page which follows a copy operation.
407: PROCEDURE copy_score (
408: p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410: p_commit IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
407: PROCEDURE copy_score (
408: p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
410: p_commit IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: x_return_status OUT NOCOPY VARCHAR2,
413: x_msg_count OUT NOCOPY NUMBER,
414: x_msg_data OUT NOCOPY VARCHAR2,
415: p_source_object_id IN NUMBER,