1 PACKAGE igs_uc_offer_conds_pkg AUTHID CURRENT_USER AS
2 /* $Header: IGSXI22S.pls 115.4 2003/11/02 18:00:46 ayedubat noship $ */
3
4 PROCEDURE insert_row (
5 x_rowid IN OUT NOCOPY VARCHAR2,
6 x_condition_category IN VARCHAR2,
7 x_condition_name IN VARCHAR2,
8 x_effective_from IN DATE,
9 x_effective_to IN DATE,
10 x_status IN VARCHAR2,
11 x_marvin_code IN VARCHAR2,
12 x_summ_of_cond IN VARCHAR2,
13 x_letter_text IN LONG,
14 x_mode IN VARCHAR2 DEFAULT 'R',
15 x_decision IN VARCHAR2 DEFAULT NULL
16 );
17
18 PROCEDURE lock_row (
19 x_rowid IN VARCHAR2,
20 x_condition_category IN VARCHAR2,
21 x_condition_name IN VARCHAR2,
22 x_effective_from IN DATE,
23 x_effective_to IN DATE,
24 x_status IN VARCHAR2,
25 x_marvin_code IN VARCHAR2,
26 x_summ_of_cond IN VARCHAR2,
27 x_letter_text IN LONG,
28 x_decision IN VARCHAR2 DEFAULT NULL
29 );
30
31 PROCEDURE update_row (
32 x_rowid IN VARCHAR2,
33 x_condition_category IN VARCHAR2,
34 x_condition_name IN VARCHAR2,
35 x_effective_from IN DATE,
36 x_effective_to IN DATE,
37 x_status IN VARCHAR2,
38 x_marvin_code IN VARCHAR2,
39 x_summ_of_cond IN VARCHAR2,
40 x_letter_text IN LONG,
41 x_mode IN VARCHAR2 DEFAULT 'R' ,
42 x_decision IN VARCHAR2 DEFAULT NULL
43 );
44
45 PROCEDURE add_row (
46 x_rowid IN OUT NOCOPY VARCHAR2,
47 x_condition_category IN VARCHAR2,
48 x_condition_name IN VARCHAR2,
49 x_effective_from IN DATE,
50 x_effective_to IN DATE,
51 x_status IN VARCHAR2,
52 x_marvin_code IN VARCHAR2,
53 x_summ_of_cond IN VARCHAR2,
54 x_letter_text IN LONG,
55 x_mode IN VARCHAR2 DEFAULT 'R' ,
56 x_decision IN VARCHAR2 DEFAULT NULL
57 );
58
59 PROCEDURE delete_row (
60 x_rowid IN VARCHAR2
61 );
62
63 FUNCTION get_pk_for_validation (
64 x_condition_category IN VARCHAR2,
65 x_condition_name IN VARCHAR2
66 ) RETURN BOOLEAN;
67
68 PROCEDURE before_dml (
69 p_action IN VARCHAR2,
70 x_rowid IN VARCHAR2 DEFAULT NULL,
71 x_condition_category IN VARCHAR2 DEFAULT NULL,
72 x_condition_name IN VARCHAR2 DEFAULT NULL,
73 x_effective_from IN DATE DEFAULT NULL,
74 x_effective_to IN DATE DEFAULT NULL,
75 x_status IN VARCHAR2 DEFAULT NULL,
76 x_marvin_code IN VARCHAR2 DEFAULT NULL,
77 x_summ_of_cond IN VARCHAR2 DEFAULT NULL,
78 x_letter_text IN LONG DEFAULT NULL,
79 x_creation_date IN DATE DEFAULT NULL,
80 x_created_by IN NUMBER DEFAULT NULL,
81 x_last_update_date IN DATE DEFAULT NULL,
82 x_last_updated_by IN NUMBER DEFAULT NULL,
83 x_last_update_login IN NUMBER DEFAULT NULL,
84 x_decision IN VARCHAR2 DEFAULT NULL
85 );
86
87 END igs_uc_offer_conds_pkg;