1 package IGS_AV_ADV_STANDING_PKG AS
2 /* $Header: IGSBI01S.pls 120.0 2005/07/05 12:04:51 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_VERSION_NUMBER in NUMBER,
8 X_TOTAL_EXMPTN_APPROVED in NUMBER,
9 X_TOTAL_EXMPTN_GRANTED in NUMBER,
10 X_TOTAL_EXMPTN_PERC_GRNTD in NUMBER,
11 X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
12 X_MODE in VARCHAR2 default 'R',
13 X_ORG_ID in NUMBER
14 );
15 procedure LOCK_ROW (
16 X_ROWID in VARCHAR2,
17 X_PERSON_ID in NUMBER,
18 X_COURSE_CD in VARCHAR2,
19 X_VERSION_NUMBER in NUMBER,
20 X_TOTAL_EXMPTN_APPROVED in NUMBER,
21 X_TOTAL_EXMPTN_GRANTED in NUMBER,
22 X_TOTAL_EXMPTN_PERC_GRNTD in NUMBER,
23 X_EXEMPTION_INSTITUTION_CD in VARCHAR2
24 );
25 procedure UPDATE_ROW (
26 X_ROWID in VARCHAR2,
27 X_PERSON_ID in NUMBER,
28 X_COURSE_CD in VARCHAR2,
29 X_VERSION_NUMBER in NUMBER,
30 X_TOTAL_EXMPTN_APPROVED in NUMBER,
31 X_TOTAL_EXMPTN_GRANTED in NUMBER,
32 X_TOTAL_EXMPTN_PERC_GRNTD in NUMBER,
33 X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
34 X_MODE in VARCHAR2 default 'R'
35 );
36 procedure ADD_ROW (
37 X_ROWID in out NOCOPY VARCHAR2,
38 X_PERSON_ID in NUMBER,
39 X_COURSE_CD in VARCHAR2,
40 X_VERSION_NUMBER in NUMBER,
41 X_TOTAL_EXMPTN_APPROVED in NUMBER,
42 X_TOTAL_EXMPTN_GRANTED in NUMBER,
43 X_TOTAL_EXMPTN_PERC_GRNTD in NUMBER,
44 X_EXEMPTION_INSTITUTION_CD in VARCHAR2,
45 X_MODE in VARCHAR2 default 'R',
46 X_ORG_ID in NUMBER
47 );
48 procedure DELETE_ROW (
49 X_ROWID in VARCHAR2,
50 x_mode IN VARCHAR2 DEFAULT 'R');
51 ---
52 FUNCTION Get_PK_For_Validation (
53 x_person_id IN NUMBER,
54 x_course_cd IN VARCHAR2,
55 x_version_number IN NUMBER,
56 x_exemption_institution_cd IN VARCHAR2
57 ) RETURN BOOLEAN ;
58 ---
59 PROCEDURE GET_FK_IGS_PS_VER (
60 x_course_cd IN VARCHAR2,
61 x_version_number IN NUMBER
62 );
63
64 PROCEDURE GET_FK_IGS_PE_PERSON (
65 x_person_id IN NUMBER
66 );
67 --
68 PROCEDURE CHECK_CONSTRAINTS (
69 Column_name IN VARCHAR2 DEFAULT NULL,
70 Column_Value IN VARCHAR2 DEFAULT NULL
71 );
72
73 PROCEDURE Before_DML (
74 p_action IN VARCHAR2,
75 x_rowid IN VARCHAR2 DEFAULT NULL,
76 x_person_id IN NUMBER DEFAULT NULL,
77 x_course_cd IN VARCHAR2 DEFAULT NULL,
78 x_version_number IN NUMBER DEFAULT NULL,
79 x_total_exmptn_approved IN NUMBER DEFAULT NULL,
80 x_total_exmptn_granted IN NUMBER DEFAULT NULL,
81 x_total_exmptn_perc_grntd IN NUMBER DEFAULT NULL,
82 x_exemption_institution_cd IN VARCHAR2 DEFAULT NULL,
83 x_creation_date IN DATE DEFAULT NULL,
84 x_created_by IN NUMBER DEFAULT NULL,
85 x_last_update_date IN DATE DEFAULT NULL,
86 x_last_updated_by IN NUMBER DEFAULT NULL,
87 x_last_update_login IN NUMBER DEFAULT NULL,
88 x_org_id in NUMBER DEFAULT NULL
89 ) ;
90 ---
91 end IGS_AV_ADV_STANDING_PKG;
[Home] [Help]