PACKAGE: APPS.IGS_AD_IMP_028

Source

1 PACKAGE Igs_Ad_Imp_028 AUTHID CURRENT_USER AS
2 /* $Header: IGSADC8S.pls 115.3 2003/12/09 13:32:35 pbondugu noship $ */
3 
4 /*************************************
5 || Change History
6 ||  who           when		  what
7 ||  pbondugu   22-APR-2003  Admissions Legacy Import to import person legacy data
8 */
9 
10 PROCEDURE prc_pe_qual_details (
11 p_interface_run_id  igs_ad_interface_all.interface_run_id%TYPE,
12 p_rule     VARCHAR2,
13 p_enable_log   VARCHAR2)  ;
14 
15 
16 CURSOR c_uc_qual_cur  (p_interface_run_id  igs_ad_interface_all.interface_run_id%TYPE) IS
17               --Selects qualification details interface records which are in status on '2'
18           SELECT
19             rowid, ucint.*
20           FROM
21             Igs_uc_qual_ints ucint
22           WHERE
23            ucint.interface_run_id = p_interface_run_id
24           AND ucint.status = '2'
25           ORDER BY ucint.person_id;
26 
27 
28 
29 
30 
31 
32 END IGS_AD_IMP_028;