[Home] [Help]
PACKAGE: APPS.HZ_CREDIT_PROFILE_AMTS_PKG
Source
1 PACKAGE HZ_CREDIT_PROFILE_AMTS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARHCRPAS.pls 115.3 2003/08/16 01:59:54 rajkrish ship $ */
3
4 --======================================================================
5 --CONSTANTS
6 --======================================================================
7 G_PKG_NAME CONSTANT VARCHAR2(30) :='HZ_CREDIT_PROFILE_AMTS_PKG';
8
9
10 ---------------------------
11 -- PROCEDURES AND FUNCTIONS
12 ---------------------------
13
14 --========================================================================
15 -- PROCEDURE : Insert_row PUBLIC
16 -- PARAMETERS: p_row_id ROWID of the current record in
17 -- table HZ_CREDIT_PROFILE_AMTS
18 -- p_credit_profile_amt_id primary key
19 -- p_credit_profile_id credit_profile_id
20 -- p_currency_code currency_code
21 -- p_trx_credit_limit trx_credit_limit
22 -- p_overall_credit_limit overall_credit_limit
23 -- p_creation_date date, when a record was inserted
24 -- p_created_by userid of the person,who inserted
25 -- a record
26 -- p_last_update_date
27 -- p_last_updated_by
28 -- p_last_update_login
29 --
30 -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILE_AMTS
31 --
32 --========================================================================
33 PROCEDURE Insert_row
34 ( p_row_id OUT NOCOPY VARCHAR2
35 , p_credit_profile_amt_id NUMBER
36 , p_credit_profile_id NUMBER
37 , p_currency_code VARCHAR2
38 , p_trx_credit_limit NUMBER
39 , p_overall_credit_limit NUMBER
40 , p_creation_date DATE
41 , p_created_by NUMBER
42 , p_last_update_date DATE
43 , p_last_updated_by NUMBER
44 , p_last_update_login NUMBER
45 , p_attribute_category VARCHAR2
46 , p_attribute1 VARCHAR2
47 , p_attribute2 VARCHAR2
48 , p_attribute3 VARCHAR2
49 , p_attribute4 VARCHAR2
50 , p_attribute5 VARCHAR2
51 , p_attribute6 VARCHAR2
52 , p_attribute7 VARCHAR2
53 , p_attribute8 VARCHAR2
54 , p_attribute9 VARCHAR2
55 , p_attribute10 VARCHAR2
56 , p_attribute11 VARCHAR2
57 , p_attribute12 VARCHAR2
58 , p_attribute13 VARCHAR2
59 , p_attribute14 VARCHAR2
60 , p_attribute15 VARCHAR2
61 );
62
63
64 --========================================================================
65 -- PROCEDURE : Lock_row PUBLIC
66 -- PARAMETERS: p_row_id rowid
67 -- p_currency_code currency-code
68 -- p_trx_credit_limit trx_credit_limit
69 -- p_overall_credit_limit overall_credit_limit
70 -- p_last_update_date
71 -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILE_AMTS
72 --
73 --========================================================================
74 PROCEDURE Lock_row
75 ( p_row_id VARCHAR2
76 , p_currency_code VARCHAR2
77 , p_trx_credit_limit NUMBER
78 , p_overall_credit_limit NUMBER
79 , p_last_update_date DATE
80 );
81
82
83
84 --========================================================================
85 -- PROCEDURE : Update_row PUBLIC
86 -- PARAMETERS: p_row_id rowid
87 -- p_credit_profile_amt_id primary key
88 -- p_credit_profile_id credit_profile_id
89 -- p_currency_code currency_code
90 -- p_trx_credit_limit trx_credit_limit
91 -- p_overall_credit_limit overall_credit_limit credit_rating
92 -- p_last_update_date date, when record was updated
93 -- p_last_updated_by userid of the person,who updated the record
94 -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILE_AMTS
95 --
96 --========================================================================
97 PROCEDURE Update_row
98 ( p_row_id VARCHAR2
99 , p_credit_profile_amt_id NUMBER
100 , p_credit_profile_id NUMBER
101 , p_currency_code VARCHAR2
102 , p_trx_credit_limit NUMBER
103 , p_overall_credit_limit NUMBER
104 , p_last_update_date DATE
105 , p_last_updated_by NUMBER
106 , p_attribute_category VARCHAR2
107 , p_attribute1 VARCHAR2
108 , p_attribute2 VARCHAR2
109 , p_attribute3 VARCHAR2
110 , p_attribute4 VARCHAR2
111 , p_attribute5 VARCHAR2
112 , p_attribute6 VARCHAR2
113 , p_attribute7 VARCHAR2
114 , p_attribute8 VARCHAR2
115 , p_attribute9 VARCHAR2
116 , p_attribute10 VARCHAR2
117 , p_attribute11 VARCHAR2
118 , p_attribute12 VARCHAR2
119 , p_attribute13 VARCHAR2
120 , p_attribute14 VARCHAR2
121 , p_attribute15 VARCHAR2
122 );
123
124
125 --========================================================================
126 -- PROCEDURE : Delete_row PUBLIC
127 -- PARAMETERS: p_row_id rowid
128 --
129 -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS
130 --
131 --========================================================================
132 PROCEDURE Delete_row
133 ( p_row_id VARCHAR2
134 );
135
136
137 --========================================================================
138 -- PROCEDURE : Delete_rows PUBLIC
139 -- PARAMETERS: p_credit_profile_id credit_profile_id
140 --
141 -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS
142 -- when master record is deleted from HZ_CREDIT_PROFILES table
143 --========================================================================
144 PROCEDURE Delete_rows
145 ( p_credit_profile_id NUMBER
146 );
147
148 END HZ_CREDIT_PROFILE_AMTS_PKG;