1 PACKAGE IGS_AD_ACT_ASSESSMENTS_PKG AS
2 /* $Header: IGSADD1S.pls 120.2 2006/04/12 03:05:35 akadam noship $ */
3 /* ------------------------------------------------------------------------------------------------------------------------
4 || Created By : Stammine
5 || Created On : 18-Nov-2004
6 || Purpose : Import ACT Assessment Details Process
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 ---------------------------------------------------------------------------------------------------------------------------*/
10 --*****************************************************************************
11 -- GLOBAL VARIABLES AND CONSTANTS
12 --
13 G_SSN_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
14 G_ACT_Person_Id_Type IGS_PE_PERSON_ID_TYP.PERSON_ID_TYPE%TYPE;
15 G_Score_Source_id IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
16 G_Transcript_Source IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
17 G_Grading_Scale IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
18 G_Unit_Difficulty IGS_AD_CODE_CLASSES.CODE_ID%TYPE;
19 --*****************************************************************************
20
21 /* This function is used to generate the batch_id into the ASSESSMENT Table through SQL Loader Process */
22 FUNCTION get_batch_id RETURN NUMBER;
23
24
25 /* This function checks the Required setups for importing the data From ACT data store to Interface Tables.
26 Returns the Error code 2 if the Required setup is not met.
27 Returns 1 if the Required setup is met.
28 This function also set the global variables to respective values requried while inserting into Interface Tables. */
29
30 FUNCTION Check_Setups (
31 p_ACT_Batch_Id IN IGS_AD_ACT_ASSESSMENTS.ACT_BATCH_ID%type,
32 p_Reporting_Year IN IGS_AD_ACT_ASSESSMENTS.REPORTING_YEAR%type,
33 p_Test_Type IN IGS_AD_ACT_ASSESSMENTS.TEST_TYPE%type,
34 p_Test_Date IN IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
35 p_ACT_Id IN IGS_AD_ACT_ASSESSMENTS.act_identifier%type)
36 RETURN NUMBER;
37
38 /* This Procedure Import the Act Data into the OSS tables.
39 Process Stores the ACT Data into Interface tables and
40 call the Import Process to import data from Interface tables to OSS functional Tables. */
41
42 PROCEDURE Insert_ACT_to_Interface (
43 ERRBUF OUT NOCOPY VARCHAR2,
44 RETCODE OUT NOCOPY NUMBER,
45 p_ACT_Batch_Id IN IGS_AD_ACT_ASSESSMENTS.ACT_BATCH_ID%type,
46 p_Source_Type_Id IN NUMBER,
47 p_Match_Set_Id IN NUMBER,
48 p_Reporting_Year IN IGS_AD_ACT_ASSESSMENTS.REPORTING_YEAR%type,
49 p_Test_Type IN IGS_AD_ACT_ASSESSMENTS.TEST_TYPE%type,
50 p_Test_Date IN IGS_AD_ACT_ASSESSMENTS.TEST_DATE_TXT%type,
51 p_ACT_Id IN IGS_AD_ACT_ASSESSMENTS.ACT_IDENTIFIER%type,
52 P_ADDR_USAGE_CD IN IGS_AD_ADDRUSAGE_INT_ALL.SITE_USE_CODE%type) ;
53
54 END IGS_AD_ACT_ASSESSMENTS_PKG;