PACKAGE: APPS.IGS_PS_TYPE_PKG

Source

1 package IGS_PS_TYPE_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSPI36S.pls 115.9 2003/06/05 12:53:40 sarakshi ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_COURSE_TYPE in VARCHAR2,
7   X_DESCRIPTION in VARCHAR2,
8   X_GOVT_COURSE_TYPE in NUMBER,
9   X_AWARD_COURSE_IND in VARCHAR2,
10   X_COURSE_TYPE_GROUP_CD in VARCHAR2 DEFAULT NULL,
11   X_TAC_COURSE_LEVEL in VARCHAR2 DEFAULT NULL,
12   X_RESEARCH_TYPE_IND in VARCHAR2 ,
13   X_CLOSED_IND in VARCHAR2,
14   X_MODE in VARCHAR2 default 'R',
15   X_ORG_ID in NUMBER  DEFAULT NULL,
16   X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT NULL,
17   X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
18   X_ENROLMENT_CAT  IN  VARCHAR2 DEFAULT NULL
19   );
20 procedure LOCK_ROW (
21   X_ROWID in VARCHAR2,
22   X_COURSE_TYPE in VARCHAR2,
23   X_DESCRIPTION in VARCHAR2,
24   X_GOVT_COURSE_TYPE in NUMBER,
25   X_AWARD_COURSE_IND in VARCHAR2,
26   X_COURSE_TYPE_GROUP_CD in VARCHAR2 DEFAULT NULL,
27   X_TAC_COURSE_LEVEL in VARCHAR2 DEFAULT NULL,
28   X_RESEARCH_TYPE_IND in VARCHAR2,
29   X_CLOSED_IND in VARCHAR2 ,
30   X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT NULL,
31   X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
32   X_ENROLMENT_CAT  IN  VARCHAR2 DEFAULT NULL
33 );
34 procedure UPDATE_ROW (
35   X_ROWID in VARCHAR2,
36   X_COURSE_TYPE in VARCHAR2,
37   X_DESCRIPTION in VARCHAR2,
38   X_GOVT_COURSE_TYPE in NUMBER,
39   X_AWARD_COURSE_IND in VARCHAR2,
40   X_COURSE_TYPE_GROUP_CD in VARCHAR2 DEFAULT NULL,
41   X_TAC_COURSE_LEVEL in VARCHAR2 DEFAULT NULL,
42   X_RESEARCH_TYPE_IND in VARCHAR2,
43   X_CLOSED_IND in VARCHAR2,
44   X_MODE in VARCHAR2 default 'R',
45   X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT NULL,
46   X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
47   X_ENROLMENT_CAT  IN  VARCHAR2 DEFAULT NULL
48   );
49 procedure ADD_ROW (
50   X_ROWID in out NOCOPY VARCHAR2,
51   X_COURSE_TYPE in VARCHAR2,
52   X_DESCRIPTION in VARCHAR2,
53   X_GOVT_COURSE_TYPE in NUMBER,
54   X_AWARD_COURSE_IND in VARCHAR2,
55   X_COURSE_TYPE_GROUP_CD in VARCHAR2 DEFAULT NULL,
56   X_TAC_COURSE_LEVEL in VARCHAR2 DEFAULT NULL,
57   X_RESEARCH_TYPE_IND in VARCHAR2,
58   X_CLOSED_IND in VARCHAR2,
59   X_MODE in VARCHAR2 default 'R',
60   X_ORG_ID in NUMBER,
61   X_PRIMARY_AUTO_SELECT IN VARCHAR2 DEFAULT NULL,
62   X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
63   X_ENROLMENT_CAT  IN  VARCHAR2 DEFAULT NULL
64   );
65 
66   FUNCTION Get_PK_For_Validation (
67     x_course_type IN VARCHAR2
68     )RETURN BOOLEAN;
69 
70   PROCEDURE CHECK_CONSTRAINTS (
71 	Column_Name IN VARCHAR2 DEFAULT NULL,
72 	Column_Value IN VARCHAR2 DEFAULT NULL
73   );
74 
75   PROCEDURE Before_DML (
76     p_action IN VARCHAR2,
77     x_rowid IN VARCHAR2 DEFAULT NULL,
78     x_description IN VARCHAR2 DEFAULT NULL,
79     x_govt_course_type IN NUMBER DEFAULT NULL,
80     x_award_course_ind IN VARCHAR2 DEFAULT NULL,
81     x_course_type_group_cd IN VARCHAR2 DEFAULT NULL,
82     x_tac_course_level IN VARCHAR2 DEFAULT NULL,
83     x_research_type_ind IN VARCHAR2 DEFAULT NULL,
84     x_closed_ind IN VARCHAR2 DEFAULT NULL,
85     x_course_type IN VARCHAR2 DEFAULT NULL,
86     x_creation_date IN DATE DEFAULT NULL,
87     x_created_by IN NUMBER DEFAULT NULL,
88     x_last_update_date IN DATE DEFAULT NULL,
89     x_last_updated_by IN NUMBER DEFAULT NULL,
90     x_last_update_login IN NUMBER DEFAULT NULL,
91     x_org_id IN NUMBER DEFAULT NULL,
92     x_primary_auto_select IN VARCHAR2 DEFAULT NULL,
93     X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 DEFAULT NULL,
94     x_enrolment_cat IN VARCHAR2 DEFAULT NULL
95   );
96 
97   PROCEDURE GET_FK_IGS_PS_TYPE_GRP (
98     x_course_type_group_cd IN VARCHAR2
99     );
100 
101   PROCEDURE GET_FK_IGS_PS_GOVT_TYPE (
102     x_govt_course_type IN NUMBER
103     );
104 
105    PROCEDURE GET_FK_IGS_EN_ENROLMENT_CAT (
106     x_enrolment_cat IN VARCHAR2
107     );
108 end IGS_PS_TYPE_PKG;