1 PACKAGE igf_ap_st_inst_appl_pkg AS
2 /* $Header: IGFAI12S.pls 120.1 2005/08/16 23:07:16 appldev ship $ */
3 /*
4 || Created By : skoppula
5 || Created On : 05-DEC-2000
6 || Purpose : Table Handler package for igf_ap_st_inst_appl table.
7 || Known limitations, enhancements or remarks :
8 || Change History :
9 || Who When What
10 || (reverse chronological order - newest change first)
11 */
12
13 PROCEDURE insert_row (
14 x_rowid IN OUT NOCOPY VARCHAR2,
15 x_inst_app_id IN OUT NOCOPY NUMBER,
16 x_base_id IN NUMBER,
17 x_question_id IN NUMBER,
18 x_question_value IN VARCHAR2,
19 x_mode IN VARCHAR2 DEFAULT 'R',
20 x_application_code IN VARCHAR2 DEFAULT NULL
21 );
22
23 PROCEDURE lock_row (
24 x_rowid IN VARCHAR2,
25 x_inst_app_id IN NUMBER,
26 x_base_id IN NUMBER,
27 x_question_id IN NUMBER,
28 x_question_value IN VARCHAR2,
29 x_application_code IN VARCHAR2 DEFAULT NULL
30 );
31
32 PROCEDURE update_row (
33 x_rowid IN VARCHAR2,
34 x_inst_app_id IN NUMBER,
35 x_base_id IN NUMBER,
36 x_question_id IN NUMBER,
37 x_question_value IN VARCHAR2,
38 x_mode IN VARCHAR2 DEFAULT 'R',
39 x_application_code IN VARCHAR2 DEFAULT NULL
40 );
41
42 PROCEDURE add_row (
43 x_rowid IN OUT NOCOPY VARCHAR2,
44 x_inst_app_id IN OUT NOCOPY NUMBER,
45 x_base_id IN NUMBER,
46 x_question_id IN NUMBER,
47 x_question_value IN VARCHAR2,
48 x_mode IN VARCHAR2 DEFAULT 'R',
49 x_application_code IN VARCHAR2 DEFAULT NULL
50 );
51
52 PROCEDURE delete_row (
53 x_rowid IN VARCHAR2
54 );
55
56 FUNCTION get_pk_for_validation (
57 x_inst_app_id IN NUMBER
58 ) RETURN BOOLEAN;
59
60 FUNCTION get_uk_for_validation (
61 x_base_id IN NUMBER,
62 x_question_id IN NUMBER,
63 x_application_code IN VARCHAR2
64 ) RETURN BOOLEAN;
65
66 PROCEDURE get_fk_igf_ap_appl_setup (
67 x_question_id IN NUMBER
68 );
69
70 PROCEDURE get_fk_igf_ap_fa_base_rec (
71 x_base_id IN NUMBER
72 );
73
74 PROCEDURE get_fk_igf_ap_appl_status (
75 x_base_id IN NUMBER,
76 x_application_code IN VARCHAR2
77 );
78
79 PROCEDURE before_dml (
80 p_action IN VARCHAR2,
81 x_rowid IN VARCHAR2 DEFAULT NULL,
82 x_inst_app_id IN NUMBER DEFAULT NULL,
83 x_base_id IN NUMBER DEFAULT NULL,
84 x_question_id IN NUMBER DEFAULT NULL,
85 x_question_value IN VARCHAR2 DEFAULT NULL,
86 x_creation_date IN DATE DEFAULT NULL,
87 x_created_by IN NUMBER DEFAULT NULL,
88 x_last_update_date IN DATE DEFAULT NULL,
89 x_last_updated_by IN NUMBER DEFAULT NULL,
90 x_last_update_login IN NUMBER DEFAULT NULL,
91 x_application_code IN VARCHAR2 DEFAULT NULL
92 );
93
94 END igf_ap_st_inst_appl_pkg;