APPS.OKC_XPRT_UTIL_PVT dependencies on CZ_IMP_RULES

Line 139: l_name cz_imp_rules.name%TYPE;

135: l_api_name CONSTANT VARCHAR2(30) := 'check_import_status';
136: l_rec_number NUMBER:= 0;
137: l_rule_number NUMBER:= 0;
138: l_model VARCHAR2(450);
139: l_name cz_imp_rules.name%TYPE;
140: l_message cz_imp_rules.message%TYPE;
141:
142: CURSOR csr_db_logs IS
143: SELECT logtime,

Line 140: l_message cz_imp_rules.message%TYPE;

136: l_rec_number NUMBER:= 0;
137: l_rule_number NUMBER:= 0;
138: l_model VARCHAR2(450);
139: l_name cz_imp_rules.name%TYPE;
140: l_message cz_imp_rules.message%TYPE;
141:
142: CURSOR csr_db_logs IS
143: SELECT logtime,
144: caller,

Line 161: FROM cz_imp_rules

157:
158: CURSOR csr_rule_imp_dtls IS
159: SELECT name,
160: substr(message,1,200) msg
161: FROM cz_imp_rules
162: WHERE rec_status <> 'OK'
163: AND run_id = p_run_id ;
164:
165:

Line 323: -- For Rule Import, if the return status is Error read message from cz_imp_rules

319: END LOOP;
320:
321: fnd_file.put_line(FND_FILE.LOG,'----------------------------------------------------------------');
322:
323: -- For Rule Import, if the return status is Error read message from cz_imp_rules
324: IF p_model_type = 'R' THEN
325: -- Check if any rules had error
326: OPEN csr_rule_imp_dtls;
327: FETCH csr_rule_imp_dtls INTO l_name, l_message;