PACKAGE: APPS.IGS_AD_SBMINTAK_TRGT_PKG

Source

1 package IGS_AD_SBMINTAK_TRGT_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSAI59S.pls 115.3 2002/11/28 22:10:40 nsidana ship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_SUBMISSION_YR in NUMBER,
6   X_SUBMISSION_NUMBER in NUMBER,
7   X_INTAKE_TARGET_TYPE in VARCHAR2,
8   X_PRIORITY_OF_TARGET in NUMBER,
9   X_TARGET in NUMBER,
10   X_MAX_TARGET in NUMBER,
11   X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
12   X_ACTUAL_ENROLMENT in NUMBER,
13   X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
14   X_MODE in VARCHAR2 default 'R'
15   );
16 procedure LOCK_ROW (
17   X_ROWID in VARCHAR2,
18   X_SUBMISSION_YR in NUMBER,
19   X_SUBMISSION_NUMBER in NUMBER,
20   X_INTAKE_TARGET_TYPE in VARCHAR2,
21   X_PRIORITY_OF_TARGET in NUMBER,
22   X_TARGET in NUMBER,
23   X_MAX_TARGET in NUMBER,
24   X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
25   X_ACTUAL_ENROLMENT in NUMBER,
26   X_ACTUAL_ENR_EFFECTIVE_DT in DATE
27 );
28 procedure UPDATE_ROW (
29   X_ROWID in VARCHAR2,
30   X_SUBMISSION_YR in NUMBER,
31   X_SUBMISSION_NUMBER in NUMBER,
32   X_INTAKE_TARGET_TYPE in VARCHAR2,
33   X_PRIORITY_OF_TARGET in NUMBER,
34   X_TARGET in NUMBER,
35   X_MAX_TARGET in NUMBER,
36   X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
37   X_ACTUAL_ENROLMENT in NUMBER,
38   X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
39   X_MODE in VARCHAR2 default 'R'
40   );
41 procedure ADD_ROW (
42   X_ROWID in out NOCOPY VARCHAR2,
43   X_SUBMISSION_YR in NUMBER,
44   X_SUBMISSION_NUMBER in NUMBER,
45   X_INTAKE_TARGET_TYPE in VARCHAR2,
46   X_PRIORITY_OF_TARGET in NUMBER,
47   X_TARGET in NUMBER,
48   X_MAX_TARGET in NUMBER,
49   X_OVERRIDE_S_AMOUNT_TYPE in VARCHAR2,
50   X_ACTUAL_ENROLMENT in NUMBER,
51   X_ACTUAL_ENR_EFFECTIVE_DT in DATE,
52   X_MODE in VARCHAR2 default 'R'
53   );
54 procedure DELETE_ROW (
55   X_ROWID in VARCHAR2
56 );
57 
58 FUNCTION Get_PK_For_Validation (
59     x_submission_yr IN NUMBER,
60     x_submission_number IN NUMBER,
61     x_intake_target_type IN VARCHAR2
62     )
63 RETURN BOOLEAN ;
64 
65 PROCEDURE GET_FK_IGS_ST_GVT_SPSHT_CTL (
66     x_submission_yr IN NUMBER,
67     x_submission_number IN NUMBER
68     );
69 
70 PROCEDURE GET_FK_IGS_AD_INTAK_TRG_TYP(
71     x_intake_target_type IN VARCHAR2
72     );
73 
74   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW(
75     x_override_s_amount_type IN VARCHAR2
76   );
77 
78 -- added to take care of check constraints
79 PROCEDURE CHECK_CONSTRAINTS(
80      column_name IN VARCHAR2 DEFAULT NULL,
81      column_value IN VARCHAR2 DEFAULT NULL
82 );
83 
84 PROCEDURE Before_DML (
85     p_action IN VARCHAR2,
86     x_rowid IN VARCHAR2 DEFAULT NULL,
87     x_actual_enr_effective_dt IN DATE DEFAULT NULL,
88     x_submission_yr IN NUMBER DEFAULT NULL,
89     x_submission_number IN NUMBER DEFAULT NULL,
90     x_intake_target_type IN VARCHAR2 DEFAULT NULL,
91     x_priority_of_target IN NUMBER DEFAULT NULL,
92     x_target IN NUMBER DEFAULT NULL,
93     x_max_target IN NUMBER DEFAULT NULL,
94     x_override_s_amount_type IN VARCHAR2 DEFAULT NULL,
95     x_actual_enrolment IN NUMBER DEFAULT NULL,
96     x_creation_date IN DATE DEFAULT NULL,
97     x_created_by IN NUMBER DEFAULT NULL,
98     x_last_update_date IN DATE DEFAULT NULL,
99     x_last_updated_by IN NUMBER DEFAULT NULL,
100     x_last_update_login IN NUMBER DEFAULT NULL
101   );
102 
103 end IGS_AD_SBMINTAK_TRGT_PKG;