APPS.IGW_INSTALLMENTS_TBH dependencies on IGW_INSTALLMENTS

Line 1: PACKAGE BODY Igw_Installments_Tbh AS

1: PACKAGE BODY Igw_Installments_Tbh AS
2: /* $Header: igwtinsb.pls 115.2 2002/11/15 00:52:47 ashkumar noship $ */
3:
4: ---------------------------------------------------------------------------
5:

Line 6: G_PKG_NAME VARCHAR2(30) := 'IGW_INSTALLMENTS_TBH';

2: /* $Header: igwtinsb.pls 115.2 2002/11/15 00:52:47 ashkumar noship $ */
3:
4: ---------------------------------------------------------------------------
5:
6: G_PKG_NAME VARCHAR2(30) := 'IGW_INSTALLMENTS_TBH';
7:
8: ---------------------------------------------------------------------------
9:
10: PROCEDURE Insert_Row

Line 38: FROM igw_installments

34: l_last_update_login NUMBER := Nvl(Fnd_Global.Login_Id,-1);
35:
36: CURSOR c IS
37: SELECT rowid
38: FROM igw_installments
39: WHERE proposal_installment_id = x_proposal_installment_id;
40:
41: BEGIN
42:

Line 57: INSERT INTO igw_installments

53: App_Exception.Raise_Exception;
54:
55: END IF;
56:
57: INSERT INTO igw_installments
58: (
59: proposal_installment_id,
60: proposal_award_id,
61: installment_id,

Line 81: igw_installments_s.nextval,

77: last_update_login
78: )
79: VALUES
80: (
81: igw_installments_s.nextval,
82: p_proposal_award_id,
83: p_installment_id,
84: p_installment_number,
85: p_installment_type_code,

Line 179: UPDATE igw_installments

175: App_Exception.Raise_Exception;
176:
177: END IF;
178:
179: UPDATE igw_installments
180: SET proposal_award_id = p_proposal_award_id,
181: installment_number = p_installment_number,
182: installment_type_code = p_installment_type_code,
183: issue_date = p_issue_date,

Line 235: DELETE igw_installments

231: BEGIN
232:
233: x_return_status := Fnd_Api.G_Ret_Sts_Success;
234:
235: DELETE igw_installments
236: WHERE rowid = p_rowid;
237:
238: IF SQL%NotFound THEN
239:

Line 264: END Igw_Installments_Tbh;

260: END Delete_Row;
261:
262: ---------------------------------------------------------------------------
263:
264: END Igw_Installments_Tbh;