APPS.LNS_FEE_SCHEDULES_PKG dependencies on LNS_FEE_SCHEDULES

Line 1: PACKAGE BODY LNS_FEE_SCHEDULES_PKG AS

1: PACKAGE BODY LNS_FEE_SCHEDULES_PKG AS
2: /* $Header: LNS_FEESC_TBLH_B.pls 120.1.12010000.3 2010/02/24 02:38:48 mbolli ship $ */
3:
4: /* Insert_Row procedure */
5: PROCEDURE Insert_Row(

Line 28: INSERT INTO LNS_FEE_SCHEDULES

24: ,P_DISB_HEADER_ID IN NUMBER
25: ,P_PHASE IN VARCHAR2
26: ) IS
27: BEGIN
28: INSERT INTO LNS_FEE_SCHEDULES
29: (
30: FEE_SCHEDULE_ID
31: ,FEE_ID
32: ,LOAN_ID

Line 106: UPDATE LNS_FEE_SCHEDULES SET

102: ,P_DISB_HEADER_ID IN NUMBER
103: ,P_PHASE IN VARCHAR2
104: ) IS
105: BEGIN
106: UPDATE LNS_FEE_SCHEDULES SET
107: FEE_ID = DECODE(P_FEE_ID, NULL, FEE_ID, FND_API.G_MISS_NUM,
108: NULL, P_FEE_ID)
109: ,LOAN_ID = DECODE(P_LOAN_ID, NULL, LOAN_ID, FND_API.G_MISS_NUM,
110: NULL, P_LOAN_ID)

Line 148: DELETE FROM LNS_FEE_SCHEDULES

144:
145: /* Delete_Row procedure */
146: PROCEDURE Delete_Row(P_FEE_SCHEDULE_ID IN NUMBER) IS
147: BEGIN
148: DELETE FROM LNS_FEE_SCHEDULES
149: WHERE FEE_SCHEDULE_ID = P_FEE_SCHEDULE_ID;
150:
151: if (sql%notfound) then
152: raise no_data_found;

Line 179: CURSOR C IS SELECT * FROM LNS_FEE_SCHEDULES

175: ,P_OBJECT_VERSION_NUMBER IN NUMBER
176: ,P_DISB_HEADER_ID IN NUMBER
177: ,P_PHASE IN VARCHAR2
178: ) IS
179: CURSOR C IS SELECT * FROM LNS_FEE_SCHEDULES
180: WHERE FEE_SCHEDULE_ID = P_FEE_SCHEDULE_ID
181: FOR UPDATE of FEE_SCHEDULE_ID NOWAIT;
182: Recinfo C%ROWTYPE;
183: BEGIN