PACKAGE: APPS.IGS_PS_USEC_TCH_RESP_PKG

Source

1 PACKAGE igs_ps_usec_tch_resp_pkg AS
2 /* $Header: IGSPI1ES.pls 120.1 2005/10/04 00:37:55 appldev ship $ */
3  procedure INSERT_ROW (
4       X_ROWID in out NOCOPY VARCHAR2,
5        x_UNIT_SECTION_TEACH_RESP_ID IN OUT NOCOPY NUMBER,
6        x_INSTRUCTOR_ID IN NUMBER,
7        x_CONFIRMED_FLAG IN VARCHAR2,
8        x_PERCENTAGE_ALLOCATION IN NUMBER,
9        x_INSTRUCTIONAL_LOAD IN NUMBER,
10        x_LEAD_INSTRUCTOR_FLAG IN VARCHAR2,
11        x_UOO_ID IN NUMBER,
12        x_instructional_load_lab IN NUMBER DEFAULT NULL,
13        x_instructional_load_lecture IN NUMBER DEFAULT NULL,
14       X_MODE in VARCHAR2 default 'R'
15   );
16 
17  procedure LOCK_ROW (
18       X_ROWID in  VARCHAR2,
19        x_UNIT_SECTION_TEACH_RESP_ID IN NUMBER,
20        x_INSTRUCTOR_ID IN NUMBER,
21        x_CONFIRMED_FLAG IN VARCHAR2,
22        x_PERCENTAGE_ALLOCATION IN NUMBER,
23        x_INSTRUCTIONAL_LOAD IN NUMBER,
24        x_LEAD_INSTRUCTOR_FLAG IN VARCHAR2,
25        x_UOO_ID IN NUMBER,
26        x_instructional_load_lab IN NUMBER DEFAULT NULL,
27        x_instructional_load_lecture IN NUMBER DEFAULT NULL  );
28  procedure UPDATE_ROW (
29       X_ROWID in  VARCHAR2,
30        x_UNIT_SECTION_TEACH_RESP_ID IN NUMBER,
31        x_INSTRUCTOR_ID IN NUMBER,
32        x_CONFIRMED_FLAG IN VARCHAR2,
33        x_PERCENTAGE_ALLOCATION IN NUMBER,
34        x_INSTRUCTIONAL_LOAD IN NUMBER,
35        x_LEAD_INSTRUCTOR_FLAG IN VARCHAR2,
36        x_UOO_ID IN NUMBER,
37        x_instructional_load_lab IN NUMBER DEFAULT NULL,
38        x_instructional_load_lecture IN NUMBER DEFAULT NULL,
39       X_MODE in VARCHAR2 default 'R'
40   );
41 
42  procedure ADD_ROW (
43       X_ROWID in out NOCOPY VARCHAR2,
44        x_UNIT_SECTION_TEACH_RESP_ID IN OUT NOCOPY NUMBER,
45        x_INSTRUCTOR_ID IN NUMBER,
46        x_CONFIRMED_FLAG IN VARCHAR2,
47        x_PERCENTAGE_ALLOCATION IN NUMBER,
48        x_INSTRUCTIONAL_LOAD IN NUMBER,
49        x_LEAD_INSTRUCTOR_FLAG IN VARCHAR2,
50        x_UOO_ID IN NUMBER,
51        x_instructional_load_lab IN NUMBER DEFAULT NULL,
52        x_instructional_load_lecture IN NUMBER DEFAULT NULL,
53       X_MODE in VARCHAR2 default 'R'
54   ) ;
55 
56 procedure DELETE_ROW (
57   X_ROWID in VARCHAR2
58 ) ;
59   FUNCTION Get_PK_For_Validation (
60     x_unit_section_teach_resp_id IN NUMBER
61     ) RETURN BOOLEAN ;
62 
63   FUNCTION Get_UK_For_Validation (
64     x_uoo_id IN NUMBER,
65     x_instructor_id IN NUMBER
66     ) RETURN BOOLEAN;
67 
68   PROCEDURE Get_UFK_Igs_Ps_Unit_Ofr_Opt (
69     x_uoo_id IN NUMBER
70     );
71 
72   PROCEDURE Check_Constraints (
73 		 Column_Name IN VARCHAR2  DEFAULT NULL,
74 		 Column_Value IN VARCHAR2  DEFAULT NULL ) ;
75   PROCEDURE Before_DML (
76     p_action IN VARCHAR2,
77     x_rowid IN VARCHAR2 DEFAULT NULL,
78     x_unit_section_teach_resp_id IN NUMBER DEFAULT NULL,
79     x_instructor_id IN NUMBER DEFAULT NULL,
80     x_confirmed_flag IN VARCHAR2 DEFAULT NULL,
81     x_percentage_allocation IN NUMBER DEFAULT NULL,
82     x_instructional_load IN NUMBER DEFAULT NULL,
83     x_lead_instructor_flag IN VARCHAR2 DEFAULT NULL,
84     x_uoo_id IN NUMBER DEFAULT NULL,
85     x_instructional_load_lab IN NUMBER DEFAULT NULL,
86        x_instructional_load_lecture IN NUMBER DEFAULT NULL,
87     x_creation_date IN DATE DEFAULT NULL,
88     x_created_by IN NUMBER DEFAULT NULL,
89     x_last_update_date IN DATE DEFAULT NULL,
90     x_last_updated_by IN NUMBER DEFAULT NULL,
91     x_last_update_login IN NUMBER DEFAULT NULL
92  );
93 END igs_ps_usec_tch_resp_pkg;