1 package IGS_GE_REF_CD_TYPE_PKG AUTHID CURRENT_USER as
2 /* $Header: IGSMI04S.pls 115.7 2003/05/09 06:30:55 sarakshi ship $ */
3 /*************************************************************
4 Created By :
5 Date Created By :
6 Purpose :
7 Know limitations, enhancements or remarks
8 Change History
9 Who When What
10 sbeerell 09-MAY-2000 Changed according to DLD version 2
11 (reverse chronological order - newest change first)
12 ***************************************************************/
13
14 procedure INSERT_ROW (
15 X_ROWID in out NOCOPY VARCHAR2,
16 x_SELF_SERVICE_FLAG IN VARCHAR2,
17 X_REFERENCE_CD_TYPE in VARCHAR2,
18 X_DESCRIPTION in VARCHAR2,
19 X_S_REFERENCE_CD_TYPE in VARCHAR2,
20 x_CLOSED_IND in VARCHAR2,
21 x_PROGRAM_FLAG IN VARCHAR2,
22 x_PROGRAM_OFFERING_OPTION_FLAG IN VARCHAR2,
23 x_UNIT_FLAG IN VARCHAR2,
24 x_UNIT_SECTION_FLAG IN VARCHAR2,
25 x_UNIT_SECTION_OCCURRENCE_FLAG IN VARCHAR2,
26 X_MODE in VARCHAR2 default 'R',
27 X_ORG_ID in NUMBER,
28 x_mandatory_flag IN VARCHAR2 DEFAULT NULL ,
29 x_restricted_flag IN VARCHAR2 DEFAULT NULL
30 );
31
32 procedure LOCK_ROW (
33 X_ROWID in VARCHAR2,
34 x_SELF_SERVICE_FLAG IN VARCHAR2,
35 x_REFERENCE_CD_TYPE IN VARCHAR2,
36 x_DESCRIPTION IN VARCHAR2,
37 x_S_REFERENCE_CD_TYPE IN VARCHAR2,
38 x_CLOSED_IND IN VARCHAR2,
39 x_PROGRAM_FLAG IN VARCHAR2,
40 x_PROGRAM_OFFERING_OPTION_FLAG IN VARCHAR2,
41 x_UNIT_FLAG IN VARCHAR2,
42 x_UNIT_SECTION_FLAG IN VARCHAR2,
43 x_UNIT_SECTION_OCCURRENCE_FLAG IN VARCHAR2,
44 x_mandatory_flag IN VARCHAR2 DEFAULT NULL ,
45 x_restricted_flag IN VARCHAR2 DEFAULT NULL
46 );
47 procedure UPDATE_ROW (
48 X_ROWID in VARCHAR2,
49 x_SELF_SERVICE_FLAG IN VARCHAR2,
50 x_REFERENCE_CD_TYPE IN VARCHAR2,
51 x_DESCRIPTION IN VARCHAR2,
52 x_S_REFERENCE_CD_TYPE IN VARCHAR2,
53 x_CLOSED_IND IN VARCHAR2,
54 x_PROGRAM_FLAG IN VARCHAR2,
55 x_PROGRAM_OFFERING_OPTION_FLAG IN VARCHAR2,
56 x_UNIT_FLAG IN VARCHAR2,
57 x_UNIT_SECTION_FLAG IN VARCHAR2,
58 x_UNIT_SECTION_OCCURRENCE_FLAG IN VARCHAR2,
59 X_MODE in VARCHAR2 default 'R',
60 x_mandatory_flag IN VARCHAR2 DEFAULT NULL ,
61 x_restricted_flag IN VARCHAR2 DEFAULT NULL
62 );
63 procedure ADD_ROW (
64 X_ROWID in out NOCOPY VARCHAR2,
65 x_SELF_SERVICE_FLAG IN VARCHAR2,
66 x_REFERENCE_CD_TYPE IN VARCHAR2,
67 x_DESCRIPTION IN VARCHAR2,
68 x_S_REFERENCE_CD_TYPE IN VARCHAR2,
69 x_CLOSED_IND IN VARCHAR2,
70 x_PROGRAM_FLAG IN VARCHAR2,
71 x_PROGRAM_OFFERING_OPTION_FLAG IN VARCHAR2,
72
73 x_UNIT_FLAG IN VARCHAR2,
74 x_UNIT_SECTION_FLAG IN VARCHAR2,
75 x_UNIT_SECTION_OCCURRENCE_FLAG IN VARCHAR2,
76 X_MODE in VARCHAR2 default 'R',
77 X_ORG_ID in NUMBER,
78 x_mandatory_flag IN VARCHAR2 DEFAULT NULL ,
79 x_restricted_flag IN VARCHAR2 DEFAULT NULL
80 );
81 procedure DELETE_ROW (
82 X_ROWID in VARCHAR2
83 );
84
85 FUNCTION GET_PK_FOR_VALIDATION (
86 x_reference_cd_type IN VARCHAR2
87 ) RETURN BOOLEAN;
88
89 PROCEDURE GET_FK_IGS_LOOKUPS_VIEW (
90 x_s_reference_cd_type IN VARCHAR2
91 );
92 PROCEDURE Check_Constraints(
93 Column_Name IN VARCHAR2 DEFAULT NULL,
94 Column_Value IN VARCHAR2 DEFAULT NULL
95 );
96 PROCEDURE Before_DML (
97 p_action IN VARCHAR2,
98 x_rowid IN VARCHAR2 DEFAULT NULL,
99 x_self_service_flag IN VARCHAR2 DEFAULT NULL,
100 x_reference_cd_type IN VARCHAR2 DEFAULT NULL,
101 x_description IN VARCHAR2 DEFAULT NULL,
102 x_s_reference_cd_type IN VARCHAR2 DEFAULT NULL,
103 x_closed_ind IN VARCHAR2 DEFAULT NULL,
104 x_program_flag IN VARCHAR2 DEFAULT NULL,
105 x_program_offering_option_flag IN VARCHAR2 DEFAULT NULL,
106 x_unit_flag IN VARCHAR2 DEFAULT NULL,
107 x_unit_section_flag IN VARCHAR2 DEFAULT NULL,
108 x_unit_section_occurrence_flag IN VARCHAR2 DEFAULT NULL,
109 x_creation_date IN DATE DEFAULT NULL,
110 x_created_by IN NUMBER DEFAULT NULL,
111 x_last_update_date IN DATE DEFAULT NULL,
112 x_last_updated_by IN NUMBER DEFAULT NULL,
113 x_last_update_login IN NUMBER DEFAULT NULL,
114 x_org_id IN NUMBER DEFAULT NULL,
115 x_mandatory_flag IN VARCHAR2 DEFAULT NULL,
116 x_restricted_flag IN VARCHAR2 DEFAULT NULL
117 ) ;
118
119
120 end IGS_GE_REF_CD_TYPE_PKG;