1 PACKAGE igs_fi_hold_plan_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSSIA6S.pls 115.12 2003/09/12 09:30:43 vvutukur ship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_hold_plan_name IN VARCHAR2,
7 x_hold_plan_desc IN VARCHAR2,
8 x_hold_plan_level IN VARCHAR2,
9 x_hold_type IN VARCHAR2,
10 x_threshold_amount IN NUMBER,
11 x_threshold_percent IN NUMBER,
12 x_closed_ind IN VARCHAR2,
13 x_mode IN VARCHAR2 DEFAULT 'R' ,
14 x_fee_type IN VARCHAR2 DEFAULT NULL,
15 x_offset_days IN NUMBER DEFAULT NULL,
16 x_payment_plan_threshold_amt IN NUMBER DEFAULT NULL,
17 x_payment_plan_threshold_pcent IN NUMBER DEFAULT NULL
18 );
19
20 PROCEDURE lock_row (
21 x_rowid IN VARCHAR2,
22 x_hold_plan_name IN VARCHAR2,
23 x_hold_plan_desc IN VARCHAR2,
24 x_hold_plan_level IN VARCHAR2,
25 x_hold_type IN VARCHAR2,
26 x_threshold_amount IN NUMBER,
27 x_threshold_percent IN NUMBER,
28 x_closed_ind IN VARCHAR2,
29 x_fee_type IN VARCHAR2 DEFAULT NULL,
30 x_offset_days IN NUMBER DEFAULT NULL,
31 x_payment_plan_threshold_amt IN NUMBER DEFAULT NULL,
32 x_payment_plan_threshold_pcent IN NUMBER DEFAULT NULL
33 );
34
35 PROCEDURE update_row (
36 x_rowid IN VARCHAR2,
37 x_hold_plan_name IN VARCHAR2,
38 x_hold_plan_desc IN VARCHAR2,
39 x_hold_plan_level IN VARCHAR2,
40 x_hold_type IN VARCHAR2,
41 x_threshold_amount IN NUMBER,
42 x_threshold_percent IN NUMBER,
43 x_closed_ind IN VARCHAR2,
44 x_mode IN VARCHAR2 DEFAULT 'R' ,
45 x_fee_type IN VARCHAR2 DEFAULT NULL,
46 x_offset_days IN NUMBER DEFAULT NULL,
47 x_payment_plan_threshold_amt IN NUMBER DEFAULT NULL,
48 x_payment_plan_threshold_pcent IN NUMBER DEFAULT NULL
49 );
50
51 PROCEDURE add_row (
52 x_rowid IN OUT NOCOPY VARCHAR2,
53 x_hold_plan_name IN VARCHAR2,
54 x_hold_plan_desc IN VARCHAR2,
55 x_hold_plan_level IN VARCHAR2,
56 x_hold_type IN VARCHAR2,
57 x_threshold_amount IN NUMBER,
58 x_threshold_percent IN NUMBER,
59 x_closed_ind IN VARCHAR2,
60 x_mode IN VARCHAR2 DEFAULT 'R' ,
61 x_fee_type IN VARCHAR2 DEFAULT NULL,
62 x_offset_days IN NUMBER DEFAULT NULL,
63 x_payment_plan_threshold_amt IN NUMBER DEFAULT NULL,
64 x_payment_plan_threshold_pcent IN NUMBER DEFAULT NULL
65 );
66
67 PROCEDURE delete_row (
68 x_rowid IN VARCHAR2
69 );
70
71 FUNCTION get_pk_for_validation (
72 x_hold_plan_name IN VARCHAR2
73 ) RETURN BOOLEAN;
74
75 PROCEDURE get_fk_igs_fi_encmb_type (
76 x_encumbrance_type IN VARCHAR2
77 );
78
79 PROCEDURE before_dml (
80 p_action IN VARCHAR2,
81 x_rowid IN VARCHAR2 DEFAULT NULL,
82 x_hold_plan_name IN VARCHAR2 DEFAULT NULL,
83 x_hold_plan_desc IN VARCHAR2 DEFAULT NULL,
84 x_hold_plan_level IN VARCHAR2 DEFAULT NULL,
85 x_hold_type IN VARCHAR2 DEFAULT NULL,
86 x_threshold_amount IN NUMBER DEFAULT NULL,
87 x_threshold_percent IN NUMBER DEFAULT NULL,
88 x_closed_ind IN VARCHAR2 DEFAULT NULL,
89 x_creation_date IN DATE DEFAULT NULL,
90 x_created_by IN NUMBER DEFAULT NULL,
91 x_last_update_date IN DATE DEFAULT NULL,
92 x_last_updated_by IN NUMBER DEFAULT NULL,
93 x_last_update_login IN NUMBER DEFAULT NULL,
94 x_fee_type IN VARCHAR2 DEFAULT NULL,
95 x_offset_days IN NUMBER DEFAULT NULL,
96 x_payment_plan_threshold_amt IN NUMBER DEFAULT NULL,
97 x_payment_plan_threshold_pcent IN NUMBER DEFAULT NULL
98 );
99
100 END igs_fi_hold_plan_pkg;