APPS.HZ_CREDIT_PROFILE_AMTS_PKG dependencies on HZ_CREDIT_PROFILE_AMTS

Line 1: PACKAGE BODY HZ_CREDIT_PROFILE_AMTS_PKG AS

1: PACKAGE BODY HZ_CREDIT_PROFILE_AMTS_PKG AS
2: /* $Header: ARHCRPAB.pls 115.3 2003/08/16 02:00:47 rajkrish ship $ */
3:
4: ---------------------------
5: -- PROCEDURES AND FUNCTIONS

Line 11: -- table HZ_CREDIT_PROFILE_AMTS

7:
8: --========================================================================
9: -- PROCEDURE : Insert_row PUBLIC
10: -- PARAMETERS: p_row_id ROWID of the current record in
11: -- table HZ_CREDIT_PROFILE_AMTS
12: -- p_credit_profile_amt_id primary key
13: -- p_credit_profile_id credit_profile_id
14: -- p_currency_code currency_code
15: -- p_trx_credit_limit trx_credit_limit

Line 24: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILE_AMTS

20: -- p_last_update_date
21: -- p_last_updated_by
22: -- p_last_update_login
23: --
24: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILE_AMTS
25: --
26: --========================================================================
27: PROCEDURE Insert_row
28: ( p_row_id OUT NOCOPY VARCHAR2

Line 62: hz_credit_profile_amts

58: CURSOR prof_amt_csr IS
59: SELECT
60: rowid
61: FROM
62: hz_credit_profile_amts
63: WHERE credit_profile_amt_id=p_credit_profile_amt_id;
64:
65: BEGIN
66:

Line 67: INSERT INTO hz_credit_profile_amts

63: WHERE credit_profile_amt_id=p_credit_profile_amt_id;
64:
65: BEGIN
66:
67: INSERT INTO hz_credit_profile_amts
68: ( credit_profile_amt_id
69: , credit_profile_id
70: , creation_date
71: , created_by

Line 158: -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILE_AMTS

154: -- p_currency_code currency-code
155: -- p_trx_credit_limit trx_credit_limit
156: -- p_overall_credit_limit overall_credit_limit
157: -- p_last_update_date
158: -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILE_AMTS
159: --
160: --========================================================================
161: PROCEDURE Lock_row
162: ( p_row_id VARCHAR2

Line 172: FROM hz_credit_profile_amts

168: IS
169: CURSOR prof_csr
170: IS
171: SELECT *
172: FROM hz_credit_profile_amts
173: WHERE ROWID=CHARTOROWID(p_row_id)
174: FOR UPDATE OF last_update_date NOWAIT;
175:
176: recinfo prof_csr%ROWTYPE;

Line 220: -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILE_AMTS

216: -- p_trx_credit_limit trx_credit_limit
217: -- p_overall_credit_limit overall_credit_limit credit_rating
218: -- p_last_update_date date, when record was updated
219: -- p_last_updated_by userid of the person,who updated the record
220: -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILE_AMTS
221: --
222: --========================================================================
223: PROCEDURE Update_row
224: ( p_row_id VARCHAR2

Line 252: UPDATE hz_credit_profile_amts

248: )
249: IS
250:
251: BEGIN
252: UPDATE hz_credit_profile_amts
253: SET
254: credit_profile_id =p_credit_profile_id
255: , currency_code=p_currency_code
256: , trx_credit_limit=p_trx_credit_limit

Line 297: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS

293: --========================================================================
294: -- PROCEDURE : Delete_row PUBLIC
295: -- PARAMETERS: p_row_id rowid
296: --
297: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS
298: --
299: --========================================================================
300: PROCEDURE Delete_row
301: ( p_row_id VARCHAR2

Line 306: FROM HZ_CREDIT_PROFILE_AMTS

302: )
303: IS
304: BEGIN
305: DELETE
306: FROM HZ_CREDIT_PROFILE_AMTS
307: WHERE ROWID=CHARTOROWID(p_row_id);
308:
309: IF (SQL%NOTFOUND)
310: THEN

Line 328: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS

324: --========================================================================
325: -- PROCEDURE : Delete_rows PUBLIC
326: -- PARAMETERS: p_credit_profile_id credit_profile_id
327: --
328: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILE_AMTS
329: -- when master record is deleted from HZ_CREDIT_PROFILES table
330: --========================================================================
331: PROCEDURE Delete_rows
332: ( p_credit_profile_id NUMBER

Line 337: FROM HZ_CREDIT_PROFILE_AMTS

333: )
334: IS
335: BEGIN
336: DELETE
337: FROM HZ_CREDIT_PROFILE_AMTS
338: WHERE credit_profile_id=p_credit_profile_id;
339:
340:
341: EXCEPTION

Line 352: END HZ_CREDIT_PROFILE_AMTS_PKG;

348:
349: END Delete_rows;
350:
351:
352: END HZ_CREDIT_PROFILE_AMTS_PKG;