[Home] [Help]
PACKAGE: APPS.AS_CARD_RULE_QUAL_VALUES_PKG
Source
1 PACKAGE as_card_rule_qual_values_pkg AUTHID CURRENT_USER AS
2 /* $Header: asxtcqvs.pls 120.1 2005/06/24 16:58:32 appldev ship $ */
3 PROCEDURE insert_row(
4 x_rowid IN OUT NOCOPY VARCHAR2
5 , x_qual_value_id NUMBER
6 , x_last_update_date DATE
7 , x_last_updated_by NUMBER
8 , x_creation_date DATE
9 , x_created_by NUMBER
10 , x_last_update_login NUMBER
11 , x_scorecard_id NUMBER
12 , x_score NUMBER
13 , x_card_rule_id NUMBER
14 , x_seed_qual_id NUMBER
15 , x_high_value_number NUMBER
16 , x_low_value_number NUMBER
17 , x_high_value_char VARCHAR2
18 , x_low_value_char VARCHAR2
19 , x_currency_code VARCHAR2
20 , x_low_value_date DATE
21 , x_high_value_date DATE
22 , x_start_date_active DATE
23 , x_end_date_active DATE
24 );
25
26 PROCEDURE delete_row(
27 x_qual_value_id NUMBER
28 );
29
30 PROCEDURE update_row(
31 x_rowid VARCHAR2
32 , x_qual_value_id NUMBER
33 , x_last_update_date DATE
34 , x_last_updated_by NUMBER
35 , x_last_update_login NUMBER
36 , x_scorecard_id NUMBER
37 , x_score NUMBER
38 , x_card_rule_id NUMBER
39 , x_seed_qual_id NUMBER
40 , x_high_value_number NUMBER
41 , x_low_value_number NUMBER
42 , x_high_value_char VARCHAR2
43 , x_low_value_char VARCHAR2
44 , x_currency_code VARCHAR2
45 , x_low_value_date DATE
46 , x_high_value_date DATE
47 , x_start_date_active DATE
48 , x_end_date_active DATE
49 );
50
51 PROCEDURE update_row(
52 x_qual_value_id NUMBER
53 , x_last_update_date DATE
54 , x_last_updated_by NUMBER
55 , x_last_update_login NUMBER
56 , x_scorecard_id NUMBER
57 , x_score NUMBER
58 , x_card_rule_id NUMBER
59 , x_seed_qual_id NUMBER
60 , x_high_value_number NUMBER
61 , x_low_value_number NUMBER
62 , x_high_value_char VARCHAR2
63 , x_low_value_char VARCHAR2
64 , x_currency_code VARCHAR2
65 , x_low_value_date DATE
66 , x_high_value_date DATE
67 , x_start_date_active DATE
68 , x_end_date_active DATE
69 );
70
71 PROCEDURE lock_row(
72 x_rowid VARCHAR2
73 , x_qual_value_id NUMBER
74 , x_last_update_date DATE
75 , x_last_updated_by NUMBER
76 , x_creation_date DATE
77 , x_created_by NUMBER
78 , x_last_update_login NUMBER
79 , x_scorecard_id NUMBER
80 , x_score NUMBER
81 , x_card_rule_id NUMBER
82 , x_seed_qual_id NUMBER
86 , x_low_value_char VARCHAR2
83 , x_high_value_number NUMBER
84 , x_low_value_number NUMBER
85 , x_high_value_char VARCHAR2
87 , x_currency_code VARCHAR2
88 , x_low_value_date DATE
89 , x_high_value_date DATE
90 , x_start_date_active DATE
91 , x_end_date_active DATE
92 );
93
94
95 PROCEDURE load_row(
96 x_qual_value_id NUMBER
97 , x_scorecard_id NUMBER
98 , x_score NUMBER
99 , x_card_rule_id NUMBER
100 , x_seed_qual_id NUMBER
101 , x_high_value_number NUMBER
102 , x_low_value_number NUMBER
103 , x_high_value_char VARCHAR2
104 , x_low_value_char VARCHAR2
105 , x_currency_code VARCHAR2
106 , x_low_value_date DATE
107 , x_high_value_date DATE
108 , x_start_date_active DATE
109 , x_end_date_active DATE
110 , x_owner VARCHAR2
111 );
112
113 END as_card_rule_qual_values_pkg;