APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PR_SPO_INTERFACE

Line 24: FROM igs_pr_spo_interface

20: p_batch_date DATE := TO_DATE (p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
21: --
22: CURSOR error_pr IS
23: SELECT *
24: FROM igs_pr_spo_interface
25: WHERE user_id = p_user_id
26: AND trunc(batch_date) = trunc(p_batch_date)
27: AND error_code IS NOT NULL
28: AND NVL (progression_outcome_type, '--') <> '-';

Line 141: FROM igs_pr_spo_interface

137: p_batch_date DATE := TO_DATE (p_batch_datetime, 'YYYY/MM/DD HH24:MI:SS');
138: --
139: CURSOR error_pr IS
140: SELECT *
141: FROM igs_pr_spo_interface
142: WHERE user_id = p_user_id
143: AND TRUNC (batch_date) = TRUNC (p_batch_date)
144: AND ERROR_CODE IS NOT NULL
145: AND NVL (progression_outcome_type, '--') <> '-';

Line 406: FROM igs_pr_spo_interface spoi

402: spoi.error_code,
403: spoi.ROWID,
404: spoi.yop_grade,
405: spoi.yop_mark
406: FROM igs_pr_spo_interface spoi
407: WHERE spoi.user_id = p_user_id
408: AND trunc(spoi.batch_date) = trunc(p_batch_date)
409: AND NVL (spoi.progression_outcome_type, '--') <> '-';
410: --

Line 444: UPDATE igs_pr_spo_interface

440: v_spoi_rec.user_id
441: );
442: --
443: IF (l_validuser <> 'Y') THEN
444: UPDATE igs_pr_spo_interface
445: SET error_code = 'IGS_EN_PERSON_NO_RESP'
446: WHERE ROWID = v_spoi_rec.ROWID;
447: ELSE
448: v_error_code := NULL;

Line 478: UPDATE igs_pr_spo_interface

474: IF (v_error_code IS NOT NULL) THEN
475: --
476: -- Update the interface record with the error code
477: --
478: UPDATE igs_pr_spo_interface
479: SET error_code = v_error_code
480: WHERE ROWID = v_spoi_rec.ROWID;
481: END IF;
482: END IF;

Line 580: UPDATE igs_pr_spo_interface

576: );
577: retcode := 2;
578: errbuf := message_name;
579: IF (errbuf IS NOT NULL) THEN
580: UPDATE igs_pr_spo_interface
581: SET error_code = errbuf
582: WHERE rowid = v_spoi_rec.rowid;
583: END IF;
584: END;

Line 664: UPDATE igs_pr_spo_interface

660: );
661: retcode := 2;
662: errbuf := message_name;
663: IF (errbuf IS NOT NULL) THEN
664: UPDATE igs_pr_spo_interface
665: SET error_code = errbuf
666: WHERE rowid = v_spoi_rec.rowid;
667: END IF;
668: END;

Line 748: UPDATE igs_pr_spo_interface

744: );
745: retcode := 2;
746: errbuf := message_name;
747: IF (errbuf IS NOT NULL) THEN
748: UPDATE igs_pr_spo_interface
749: SET error_code = errbuf
750: WHERE rowid = v_spoi_rec.rowid;
751: END IF;
752: END;