APPS.ARP_RTE_PKG dependencies on RA_TAX_EXEMPTIONS

Line 4: table RA_TAX_EXEMPTIONS. This file holds the package body. */

1: PACKAGE BODY ARP_RTE_PKG as
2: /* $Header: ARXIRTEB.pls 120.2 2005/07/26 15:30:15 naneja noship $ */
3: /* Purpose : This package has the server side table handlers for the
4: table RA_TAX_EXEMPTIONS. This file holds the package body. */
5:
6: --
7: -- PRIVATE Procedures/Functions
8: --

Line 81: CURSOR C IS SELECT rowid FROM RA_TAX_EXEMPTIONS

77: p_Exempt_percent10 NUMBER,
78: p_org_id NUMBER
79: )
80: IS
81: CURSOR C IS SELECT rowid FROM RA_TAX_EXEMPTIONS
82: WHERE tax_exemption_id = p_Tax_exemption_id;
83:
84: CURSOR C2 IS SELECT ra_tax_exemptions_s.nextval FROM dual;
85: BEGIN

Line 84: CURSOR C2 IS SELECT ra_tax_exemptions_s.nextval FROM dual;

80: IS
81: CURSOR C IS SELECT rowid FROM RA_TAX_EXEMPTIONS
82: WHERE tax_exemption_id = p_Tax_exemption_id;
83:
84: CURSOR C2 IS SELECT ra_tax_exemptions_s.nextval FROM dual;
85: BEGIN
86:
87:
88: if (p_Tax_Exemption_Id is NULL) then

Line 94: INSERT INTO RA_TAX_EXEMPTIONS(

90: FETCH C2 INTO p_Tax_Exemption_id;
91: CLOSE C2;
92: end if;
93:
94: INSERT INTO RA_TAX_EXEMPTIONS(
95: Tax_exemption_id,
96: Last_updated_by,
97: Last_update_date,
98: Created_by,

Line 293: FROM RA_TAX_EXEMPTIONS

289: p_Exempt_percent10 NUMBER
290: ) IS
291: CURSOR C IS
292: SELECT *
293: FROM RA_TAX_EXEMPTIONS
294: WHERE rowid = p_Rowid
295: FOR UPDATE of Tax_Exemption_Id NOWAIT;
296: Recinfo C%ROWTYPE;
297:

Line 535: UPDATE RA_TAX_EXEMPTIONS

531: ) IS
532: BEGIN
533:
534:
535: UPDATE RA_TAX_EXEMPTIONS
536: SET
537: Tax_exemption_id = p_Tax_exemption_id,
538: Last_updated_by = p_Last_updated_by,
539: Last_update_date = p_Last_update_date,

Line 608: DELETE FROM RA_TAX_EXEMPTIONS

604:
605:
606: PROCEDURE Delete_Row(p_Rowid VARCHAR2) IS
607: BEGIN
608: DELETE FROM RA_TAX_EXEMPTIONS
609: WHERE rowid = p_Rowid;
610:
611: if (SQL%NOTFOUND) then
612: Raise NO_DATA_FOUND;