APPS.HZ_BILLING_PREFERENCES_PKG dependencies on HZ_BILLING_PREFERENCES

Line 1: PACKAGE BODY HZ_BILLING_PREFERENCES_PKG as

1: PACKAGE BODY HZ_BILLING_PREFERENCES_PKG as
2: /* $Header: ARHABFTB.pls 120.3 2005/10/30 03:50:18 appldev ship $ */
3:
4:
5: PROCEDURE Insert_Row(

Line 28: CURSOR C IS SELECT rowid FROM HZ_BILLING_PREFERENCES

24: x_PROGRAM_ID NUMBER,
25: x_PROGRAM_UPDATE_DATE DATE,
26: x_WH_UPDATE_DATE DATE
27: ) IS
28: CURSOR C IS SELECT rowid FROM HZ_BILLING_PREFERENCES
29: WHERE BILLING_PREFERENCES_ID = x_BILLING_PREFERENCES_ID;
30: BEGIN
31: INSERT INTO HZ_BILLING_PREFERENCES(
32: BILLING_PREFERENCES_ID,

Line 31: INSERT INTO HZ_BILLING_PREFERENCES(

27: ) IS
28: CURSOR C IS SELECT rowid FROM HZ_BILLING_PREFERENCES
29: WHERE BILLING_PREFERENCES_ID = x_BILLING_PREFERENCES_ID;
30: BEGIN
31: INSERT INTO HZ_BILLING_PREFERENCES(
32: BILLING_PREFERENCES_ID,
33: BILL_LANGUAGE,
34: BILL_ROUND_NUMBER,
35: BILL_TYPE,

Line 86: DELETE FROM HZ_BILLING_PREFERENCES

82:
83: PROCEDURE Delete_Row( x_BILLING_PREFERENCES_ID NUMBER
84: ) IS
85: BEGIN
86: DELETE FROM HZ_BILLING_PREFERENCES
87: WHERE BILLING_PREFERENCES_ID = x_BILLING_PREFERENCES_ID;
88: If (SQL%NOTFOUND) then
89: RAISE NO_DATA_FOUND;
90: End If;

Line 119: Update HZ_BILLING_PREFERENCES

115: x_PROGRAM_UPDATE_DATE DATE,
116: x_WH_UPDATE_DATE DATE
117: ) IS
118: BEGIN
119: Update HZ_BILLING_PREFERENCES
120: SET
121: BILLING_PREFERENCES_ID = decode( x_BILLING_PREFERENCES_ID, FND_API.G_MISS_NUM,BILLING_PREFERENCES_ID,x_BILLING_PREFERENCES_ID),
122: BILL_LANGUAGE = decode( x_BILL_LANGUAGE, FND_API.G_MISS_CHAR,BILL_LANGUAGE,x_BILL_LANGUAGE),
123: BILL_ROUND_NUMBER = decode( x_BILL_ROUND_NUMBER, FND_API.G_MISS_CHAR,BILL_ROUND_NUMBER,x_BILL_ROUND_NUMBER),

Line 178: FROM HZ_BILLING_PREFERENCES

174: x_WH_UPDATE_DATE DATE
175: ) IS
176: CURSOR C IS
177: SELECT *
178: FROM HZ_BILLING_PREFERENCES
179: WHERE rowid = x_Rowid
180: FOR UPDATE of BILLING_PREFERENCES_ID NOWAIT;
181: Recinfo C%ROWTYPE;
182: BEGIN

Line 260: END HZ_BILLING_PREFERENCES_PKG;

256: APP_EXCEPTION.RAISE_EXCEPTION;
257: End If;
258: END Lock_Row;
259:
260: END HZ_BILLING_PREFERENCES_PKG;