PACKAGE: APPS.IGS_PR_OU_TYPE_PKG

Source

1 package IGS_PR_OU_TYPE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSQI06S.pls 115.6 2003/02/24 11:29:03 gjha ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
7   X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
8   X_DESCRIPTION in VARCHAR2,
9   X_ENCUMBRANCE_TYPE in VARCHAR2,
10   X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
11   X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
12   X_CLOSED_IND in VARCHAR2,
13   X_COMMENTS in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R',
15   X_ORG_ID in NUMBER,
16   X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
17   );
18 procedure LOCK_ROW (
19   X_ROWID in VARCHAR2,
20   X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
21   X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
22   X_DESCRIPTION in VARCHAR2,
23   X_ENCUMBRANCE_TYPE in VARCHAR2,
24   X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
25   X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
26   X_CLOSED_IND in VARCHAR2,
27   X_COMMENTS in VARCHAR2,
28   X_POSITIVE_OUTCOME_IND IN VARCHAR2
29 );
30 procedure UPDATE_ROW (
31   X_ROWID in VARCHAR2,
32   X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
33   X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
34   X_DESCRIPTION in VARCHAR2,
35   X_ENCUMBRANCE_TYPE in VARCHAR2,
36   X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
37   X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
38   X_CLOSED_IND in VARCHAR2,
39   X_COMMENTS in VARCHAR2,
40   X_MODE in VARCHAR2 default 'R',
41   X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
42   );
43 procedure ADD_ROW (
44   X_ROWID in out NOCOPY VARCHAR2,
45   X_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
46   X_S_PROGRESSION_OUTCOME_TYPE in VARCHAR2,
47   X_DESCRIPTION in VARCHAR2,
48   X_ENCUMBRANCE_TYPE in VARCHAR2,
49   X_DFLT_RESTRICTED_ENROLMENT_CP in NUMBER,
50   X_DFLT_RESTRICTED_ATT_TYPE in VARCHAR2,
51   X_CLOSED_IND in VARCHAR2,
52   X_COMMENTS in VARCHAR2,
53   X_MODE in VARCHAR2 default 'R',
54   X_ORG_ID in NUMBER ,
55   X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
56   );
57 
58 /*Removed procedure Delete_row for Records Locking Bug 2784198 */
59 
60  FUNCTION Get_PK_For_Validation (
61     x_progression_outcome_type IN VARCHAR2
62     )
63  RETURN BOOLEAN;
64 
65   PROCEDURE GET_FK_IGS_EN_ATD_TYPE (
66     x_attendance_type IN VARCHAR2
67     );
68 
69   PROCEDURE GET_FK_IGS_FI_ENCMB_TYPE (
70     x_encumbrance_type IN VARCHAR2
71     );
72 
73   PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
74     x_s_progression_outcome_type IN VARCHAR2
75     );
76 
77   PROCEDURE  Check_Constraints (
78     Column_Name IN VARCHAR2 DEFAULT NULL,
79     Column_Value IN VARCHAR2 DEFAULT NULL
80   );
81 
82   PROCEDURE Before_DML (
83     p_action IN VARCHAR2,
84     x_rowid IN VARCHAR2 DEFAULT NULL,
85     x_progression_outcome_type IN VARCHAR2 DEFAULT NULL,
86     x_s_progression_outcome_type IN VARCHAR2 DEFAULT NULL,
87     x_description IN VARCHAR2 DEFAULT NULL,
88     x_encumbrance_type IN VARCHAR2 DEFAULT NULL,
89     x_dflt_restricted_enrolment_cp IN NUMBER DEFAULT NULL,
90     x_dflt_restricted_att_type IN VARCHAR2 DEFAULT NULL,
91     x_closed_ind IN VARCHAR2 DEFAULT NULL,
92     x_comments IN VARCHAR2 DEFAULT NULL,
93     x_creation_date IN DATE DEFAULT NULL,
94     x_created_by IN NUMBER DEFAULT NULL,
95     x_last_update_date IN DATE DEFAULT NULL,
96     x_last_updated_by IN NUMBER DEFAULT NULL,
97     x_last_update_login IN NUMBER DEFAULT NULL,
98     X_ORG_ID in NUMBER DEFAULT NULL,
99     X_POSITIVE_OUTCOME_IND IN VARCHAR2 DEFAULT 'N'
100   ) ;
101 
102 end IGS_PR_OU_TYPE_PKG;