APPS.HZ_CREDIT_PROFILES_PKG dependencies on HZ_CREDIT_PROFILES

Line 1: PACKAGE BODY HZ_CREDIT_PROFILES_PKG AS

1: PACKAGE BODY HZ_CREDIT_PROFILES_PKG AS
2: /* $Header: ARHCRPRB.pls 115.3 2003/08/18 17:45:10 rajkrish ship $ */
3:
4: ---------------------------
5: -- PROCEDURES AND FUNCTIONS

Line 11: -- table HZ_CREDIT_PROFILES

7:
8: --========================================================================
9: -- PROCEDURE : Insert_row PUBLIC
10: -- PARAMETERS: p_row_id ROWID of the current record in
11: -- table HZ_CREDIT_PROFILES
12: -- p_credit_profile_id primary key
13: -- p_organization_id operating unit id
14: -- p_item_category_id item_category_id
15: -- p_enable_flag YES/NO enable flag

Line 27: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILES

23: -- p_creation_date date, when a record was inserted
24: -- p_created_by userid of the person,who inserted
25: -- a record
26: --
27: -- COMMENT : Procedure inserts record into the table HZ_CREDIT_PROFILES
28: --
29: --========================================================================
30: PROCEDURE Insert_row
31: ( p_row_id OUT NOCOPY VARCHAR2

Line 55: hz_credit_profiles

51: CURSOR profile_csr IS
52: SELECT
53: rowid
54: FROM
55: hz_credit_profiles
56: WHERE credit_profile_id=p_credit_profile_id;
57:
58: BEGIN
59:

Line 60: INSERT INTO hz_credit_profiles

56: WHERE credit_profile_id=p_credit_profile_id;
57:
58: BEGIN
59:
60: INSERT INTO hz_credit_profiles
61: ( credit_profile_id
62: , organization_id
63: , item_category_id
64: , creation_date

Line 160: -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILES

156: --========================================================================
157: -- PROCEDURE : Lock_row PUBLIC
158: -- PARAMETERS: p_credit_profile_id credit_profile_id
159: -- p_last_update_date
160: -- COMMENT : Procedure locks record in the table HZ_CREDIT_PROFILES
161: --
162: --========================================================================
163: PROCEDURE Lock_row
164: ( p_credit_profile_id NUMBER

Line 171: FROM hz_credit_profiles

167: IS
168: CURSOR prof_csr
169: IS
170: SELECT *
171: FROM hz_credit_profiles
172: WHERE credit_profile_id=p_credit_profile_id
173: FOR UPDATE OF last_update_date NOWAIT;
174:
175: recinfo prof_csr%ROWTYPE;

Line 216: -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILES

212: -- p_credit_hold credit_hold
213: -- p_credit_rating credit_rating
214: -- p_last_update_date date, when record was updated
215: -- p_last_updated_by userid of the person,who updated the record
216: -- COMMENT : Procedure updates record in the table HZ_CREDIT_PROFILES
217: --
218: --========================================================================
219: PROCEDURE Update_row
220: ( p_credit_profile_id NUMBER

Line 237: UPDATE hz_credit_profiles

233: )
234: IS
235:
236: BEGIN
237: UPDATE hz_credit_profiles
238: SET
239: organization_id =p_organization_id
240: , item_category_id=p_item_category_id
241: , enable_flag=p_enable_flag

Line 272: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILES

268: --========================================================================
269: -- PROCEDURE : Delete_row PUBLIC
270: -- PARAMETERS: p_credit_profile_id credit_profile_id
271: --
272: -- COMMENT : Procedure deletes record from the table HZ_CREDIT_PROFILES
273: --
274: --========================================================================
275: PROCEDURE Delete_row
276: ( p_credit_profile_id NUMBER

Line 281: FROM HZ_CREDIT_PROFILES

277: )
278: IS
279: BEGIN
280: DELETE
281: FROM HZ_CREDIT_PROFILES
282: WHERE credit_profile_id=p_credit_profile_id;
283:
284: IF (SQL%NOTFOUND)
285: THEN

Line 299: END HZ_CREDIT_PROFILES_PKG;

295: RAISE;
296:
297: END Delete_row;
298:
299: END HZ_CREDIT_PROFILES_PKG;