PACKAGE: APPS.IGS_PR_STDNT_PR_UNIT_PKG

Source

1 package  IGS_PR_STDNT_PR_UNIT_PKG AS
2 /* $Header: IGSQI18S.pls 120.0 2005/07/05 12:51:18 appldev noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_PERSON_ID in NUMBER,
6   X_COURSE_CD in VARCHAR2,
7   X_SPO_SEQUENCE_NUMBER in NUMBER,
8   X_UNIT_CD in VARCHAR2,
9   X_S_UNIT_TYPE in VARCHAR2,
10   X_MODE in VARCHAR2 default 'R'
11   );
12 procedure LOCK_ROW (
13   X_ROWID in VARCHAR2,
14   X_PERSON_ID in NUMBER,
15   X_COURSE_CD in VARCHAR2,
16   X_SPO_SEQUENCE_NUMBER in NUMBER,
17   X_UNIT_CD in VARCHAR2,
18   X_S_UNIT_TYPE in VARCHAR2
19 );
20 procedure UPDATE_ROW (
21   X_ROWID in VARCHAR2,
22   X_PERSON_ID in NUMBER,
23   X_COURSE_CD in VARCHAR2,
24   X_SPO_SEQUENCE_NUMBER in NUMBER,
25   X_UNIT_CD in VARCHAR2,
26   X_S_UNIT_TYPE in VARCHAR2,
27   X_MODE in VARCHAR2 default 'R'
28   );
29 procedure ADD_ROW (
30   X_ROWID in out NOCOPY VARCHAR2,
31   X_PERSON_ID in NUMBER,
32   X_COURSE_CD in VARCHAR2,
33   X_SPO_SEQUENCE_NUMBER in NUMBER,
34   X_UNIT_CD in VARCHAR2,
35   X_S_UNIT_TYPE in VARCHAR2,
36   X_MODE in VARCHAR2 default 'R'
37   );
38 procedure DELETE_ROW (
39   X_ROWID in VARCHAR2,
40   x_mode IN VARCHAR2 DEFAULT 'R'
41 );
42 
43 FUNCTION Get_PK_For_Validation (
44     x_person_id IN NUMBER,
45     x_course_cd IN VARCHAR2,
46     x_spo_sequence_number IN NUMBER,
47     x_unit_cd IN VARCHAR2
48     ) RETURN BOOLEAN;
49 
50   PROCEDURE GET_FK_IGS_PR_STDNT_PR_OU (
51     x_person_id IN NUMBER,
52     x_course_cd IN VARCHAR2,
53     x_sequence_number IN NUMBER
54     );
55 
56   PROCEDURE GET_FK_IGS_PS_UNIT (
57     x_unit_cd IN VARCHAR2
58     );
59 PROCEDURE Before_DML (
60     p_action IN VARCHAR2,
61     x_rowid IN  VARCHAR2 DEFAULT NULL,
62     x_person_id IN NUMBER DEFAULT NULL,
63     x_course_cd IN VARCHAR2 DEFAULT NULL,
64     x_spo_sequence_number IN NUMBER DEFAULT NULL,
65     x_unit_cd IN VARCHAR2 DEFAULT NULL,
66     x_s_unit_type IN VARCHAR2 DEFAULT NULL,
67     x_creation_date IN DATE DEFAULT NULL,
68     x_created_by IN NUMBER DEFAULT NULL,
69     x_last_update_date IN DATE DEFAULT NULL,
70     x_last_updated_by IN NUMBER DEFAULT NULL,
71     x_last_update_login IN NUMBER DEFAULT NULL
72   );
73 PROCEDURE Check_Constraints(
74 	Column_Name IN VARCHAR2 DEFAULT NULL,
75 	Column_Value IN VARCHAR2 DEFAULT NULL
76 	);
77 
78 end IGS_PR_STDNT_PR_UNIT_PKG;