1 PACKAGE IGR_IMP_002 AS
2 /* $Header: IGSRT13S.pls 120.0 2005/06/02 03:33:41 appldev noship $ */
3 /* ------------------------------------------------------------------------------------------------------------------------
4 || Created By : rbezawad
5 || Created On : 27-Feb-05
6 || Purpose : Extract of IGR related references from Admissions Import process packages (IGSAD79B.pls and IGSAD93B.pls)
7 || to get rid of probable compilation errors for non-IGR customers.
8 || Known limitations, enhancements or remarks :
9 || Change History :
10 || WHO WHEN WHAT
11 ---------------------------------------------------------------------------------------------------------------------------*/
12
13 -- Procedure to set the IGS_RC_I_APPL_INT.STATUS value to Warning (status='4') when IGS_RC_I_APPL_INT record
14 -- is processed successfully (status='1') but processing of any of the child interface records is not successful
15 -- (status<>'1'). Also set the IGS_AD_INTERFACE.STATUS to Error (Status='3') when processing any of the child interface
16 -- records (IGS_RC_I_APPL_INT) is not successful (status<>'1').
17 PROCEDURE update_parent_record_status (p_interface_run_id IN NUMBER);
18
19 -- Procedure used to call the procedures in related inquiry source category (INQUIRY_INSTANCE) to import each entity
20 -- (INQUIRY_DETAILS, INQUIRY_ACADEMIC_INTEREST, INQUIRY_PACKAGE_ITEMS, INQUIRY_INFORMATION_TYPES and INQUIRY_CHARACTERISTICS).
21 PROCEDURE prc_ad_category (p_source_type_id IN NUMBER,
22 p_interface_run_id IN NUMBER,
23 p_enable_log IN VARCHAR2,
24 p_schema IN VARCHAR2);
25
26 -- Procedure is used to delete the records from the recruitment interface tables, which are processed successfully.
27 PROCEDURE del_cmpld_rct_records (p_source_type_id IN NUMBER,
28 p_interface_run_id IN NUMBER);
29
30 END IGR_IMP_002;