PACKAGE: APPS.IGS_PE_STD_TODO_REF_PKG

Source

1 package IGS_PE_STD_TODO_REF_PKG AUTHID CURRENT_USER AS
2   /* $Header: IGSNI37S.pls 115.4 2003/04/30 06:00:25 svanukur ship $ */
3 
4 procedure INSERT_ROW (
5   X_ROWID in out NOCOPY VARCHAR2,
6   X_PERSON_ID in NUMBER,
7   X_S_STUDENT_TODO_TYPE in VARCHAR2,
8   X_SEQUENCE_NUMBER in NUMBER,
9   X_REFERENCE_NUMBER in NUMBER,
10   X_CAL_TYPE in VARCHAR2,
11   X_CI_SEQUENCE_NUMBER in NUMBER,
12   X_COURSE_CD in VARCHAR2,
13   X_UNIT_CD in VARCHAR2,
14   X_OTHER_REFERENCE in VARCHAR2,
15   X_LOGICAL_DELETE_DT in DATE,
16   X_MODE in VARCHAR2 default 'R' ,
17   X_UOO_ID in NUMBER
18   );
19 procedure LOCK_ROW (
20   X_ROWID in VARCHAR2,
21   X_PERSON_ID in NUMBER,
22   X_S_STUDENT_TODO_TYPE in VARCHAR2,
23   X_SEQUENCE_NUMBER in NUMBER,
24   X_REFERENCE_NUMBER in NUMBER,
25   X_CAL_TYPE in VARCHAR2,
26   X_CI_SEQUENCE_NUMBER in NUMBER,
27   X_COURSE_CD in VARCHAR2,
28   X_UNIT_CD in VARCHAR2,
29   X_OTHER_REFERENCE in VARCHAR2,
30   X_LOGICAL_DELETE_DT in DATE,
31   X_UOO_ID in NUMBER
32 );
33 procedure UPDATE_ROW (
34   X_ROWID in VARCHAR2,
35   X_PERSON_ID in NUMBER,
36   X_S_STUDENT_TODO_TYPE in VARCHAR2,
37   X_SEQUENCE_NUMBER in NUMBER,
38   X_REFERENCE_NUMBER in NUMBER,
39   X_CAL_TYPE in VARCHAR2,
40   X_CI_SEQUENCE_NUMBER in NUMBER,
41   X_COURSE_CD in VARCHAR2,
42   X_UNIT_CD in VARCHAR2,
43   X_OTHER_REFERENCE in VARCHAR2,
44   X_LOGICAL_DELETE_DT in DATE,
45   X_MODE in VARCHAR2 default 'R',
46   X_UOO_ID in NUMBER
47   );
48 procedure ADD_ROW (
49   X_ROWID in out NOCOPY VARCHAR2,
50   X_PERSON_ID in NUMBER,
51   X_S_STUDENT_TODO_TYPE in VARCHAR2,
52   X_SEQUENCE_NUMBER in NUMBER,
53   X_REFERENCE_NUMBER in NUMBER,
54   X_CAL_TYPE in VARCHAR2,
55   X_CI_SEQUENCE_NUMBER in NUMBER,
56   X_COURSE_CD in VARCHAR2,
57   X_UNIT_CD in VARCHAR2,
58   X_OTHER_REFERENCE in VARCHAR2,
59   X_LOGICAL_DELETE_DT in DATE,
60   X_MODE in VARCHAR2 default 'R',
61   X_UOO_ID in NUMBER
62   );
63 procedure DELETE_ROW (
64   X_ROWID in VARCHAR2
65 );
66  FUNCTION Get_PK_For_Validation (
67     x_person_id IN NUMBER,
68     x_s_student_todo_type IN VARCHAR2,
69     x_sequence_number IN NUMBER,
70     x_reference_number IN NUMBER
71     ) RETURN BOOLEAN;
72 
73   PROCEDURE GET_FK_IGS_PE_STD_TODO (
74     x_person_id IN NUMBER,
75     x_s_student_todo_type IN VARCHAR2,
76     x_sequence_number IN NUMBER
77     );
78   PROCEDURE Check_Constraints (
79  Column_Name	IN	VARCHAR2	DEFAULT NULL,
80  Column_Value 	IN	VARCHAR2	DEFAULT NULL
81  );
82  PROCEDURE Before_DML (
83 
84     p_action IN VARCHAR2,
85 
86     x_rowid IN VARCHAR2 DEFAULT NULL,
87 
88     x_person_id IN NUMBER DEFAULT NULL,
89 
90     x_s_student_todo_type IN VARCHAR2 DEFAULT NULL,
91 
92     x_sequence_number IN NUMBER DEFAULT NULL,
93 
94     x_reference_number IN NUMBER DEFAULT NULL,
95 
96     x_cal_type IN VARCHAR2 DEFAULT NULL,
97 
98     x_ci_sequence_number IN NUMBER DEFAULT NULL,
99 
100     x_course_cd IN VARCHAR2 DEFAULT NULL,
101 
102     x_unit_cd IN VARCHAR2 DEFAULT NULL,
103 
104     x_other_reference IN VARCHAR2 DEFAULT NULL,
105 
106     x_logical_delete_dt IN DATE DEFAULT NULL,
107 
108     x_creation_date IN DATE DEFAULT NULL,
109 
110     x_created_by IN NUMBER DEFAULT NULL,
111 
112     x_last_update_date IN DATE DEFAULT NULL,
113 
114     x_last_updated_by IN NUMBER DEFAULT NULL,
115 
116     x_last_update_login IN NUMBER DEFAULT NULL,
117 
118     x_uoo_id IN NUMBER DEFAULT NULL
119 
120   );
121 
122 end IGS_PE_STD_TODO_REF_PKG;