[Home] [Help]
PACKAGE: APPS.IGS_AS_SUA_SES_ATTS_PKG
Source
1 PACKAGE igs_as_sua_ses_atts_pkg AS
2 /* $Header: IGSDI80S.pls 120.0 2005/07/05 11:52:58 appldev noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_person_id IN NUMBER,
7 x_course_cd IN VARCHAR2,
8 x_uoo_id IN NUMBER,
9 x_session_name IN VARCHAR2,
10 x_attendance_flag IN VARCHAR2,
11 x_mode IN VARCHAR2 DEFAULT 'R' ,
12 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
13 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
14 X_MSG_COUNT OUT NOCOPY NUMBER
15 );
16
17 PROCEDURE lock_row (
18 x_rowid IN VARCHAR2,
19 x_person_id IN NUMBER,
20 x_course_cd IN VARCHAR2,
21 x_uoo_id IN NUMBER,
22 x_session_name IN VARCHAR2,
23 x_attendance_flag IN VARCHAR2,
24 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
25 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
26 X_MSG_COUNT OUT NOCOPY NUMBER
27 );
28
29 PROCEDURE update_row (
30 x_rowid IN VARCHAR2,
31 x_person_id IN NUMBER,
32 x_course_cd IN VARCHAR2,
33 x_uoo_id IN NUMBER,
34 x_session_name IN VARCHAR2,
35 x_attendance_flag IN VARCHAR2,
36 x_mode IN VARCHAR2 DEFAULT 'R' ,
37 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
38 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
39 X_MSG_COUNT OUT NOCOPY NUMBER
40 );
41
42 PROCEDURE add_row (
43 x_rowid IN OUT NOCOPY VARCHAR2,
44 x_person_id IN NUMBER,
45 x_course_cd IN VARCHAR2,
46 x_uoo_id IN NUMBER,
47 x_session_name IN VARCHAR2,
48 x_attendance_flag IN VARCHAR2,
49 x_mode IN VARCHAR2 DEFAULT 'R' ,
50 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
51 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
52 X_MSG_COUNT OUT NOCOPY NUMBER
53 );
54
55 PROCEDURE delete_row (
56 x_rowid IN VARCHAR2 ,
57 x_mode IN VARCHAR2 DEFAULT 'R',
58 X_RETURN_STATUS OUT NOCOPY VARCHAR2 ,
59 X_MSG_DATA OUT NOCOPY VARCHAR2 ,
60 X_MSG_COUNT OUT NOCOPY NUMBER
61 );
62
63 FUNCTION get_pk_for_validation (
64 x_person_id IN NUMBER,
65 x_course_cd IN VARCHAR2,
66 x_uoo_id IN NUMBER,
67 x_session_name IN VARCHAR2
68 ) RETURN BOOLEAN;
69
70 PROCEDURE before_dml (
71 p_action IN VARCHAR2,
72 x_rowid IN VARCHAR2 DEFAULT NULL,
73 x_person_id IN NUMBER DEFAULT NULL,
74 x_course_cd IN VARCHAR2 DEFAULT NULL,
75 x_uoo_id IN NUMBER DEFAULT NULL,
76 x_session_name IN VARCHAR2 DEFAULT NULL,
77 x_attendance_flag IN VARCHAR2 DEFAULT NULL,
78 x_creation_date IN DATE DEFAULT NULL,
79 x_created_by IN NUMBER DEFAULT NULL,
80 x_last_update_date IN DATE DEFAULT NULL,
81 x_last_updated_by IN NUMBER DEFAULT NULL,
82 x_last_update_login IN NUMBER DEFAULT NULL
83 );
84
85 PROCEDURE get_fk_igs_en_su_Attempt(
86 x_person_id igs_en_su_attempt.person_id%TYPE,
87 x_course_cd igs_en_su_attempt.course_cd%TYPE,
88 x_uoo_id igs_en_su_attempt.uoo_id%TYPE
89 );
90
91 PROCEDURE get_fk_igs_as_usec_sessns(
92 x_session_name igs_as_usec_sessns.session_name%TYPE,
93 x_uoo_id igs_as_usec_sessns.uoo_id%TYPE
94 );
95
96 END igs_as_sua_ses_atts_pkg;