[Home] [Help]
PACKAGE: APPS.JG_ZZ_VAT_BOX_ALLOCS_PKG
Source
1 PACKAGE JG_ZZ_VAT_BOX_ALLOCS_PKG AS
2 /* $Header: jgzzvatboxallocs.pls 120.1 2006/07/26 14:09:06 brathod ship $*/
3 /*------------------------------------------------------------------------------------------------------------
4 CHANGE HISTORY
5 1. Vijay Shankar 20-Jan-2005 File Version 120.0
6 Created.
7
8 2. Bhavik Rathod 25-Jul-2005 Bug: 5408280, File Version 120.1
9 Modified to uptake impact due to SIGN_FLAG column changes
10 Refer bug for more details
11 ------------------------------------------------------------------------------------------------------------*/
12 /* API to insert a single row */
13 PROCEDURE INSERT_ROW(
14 XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
15 PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
16 PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
17 PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
18 PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
19 Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
20 PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
21 pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
22 pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
23 pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
24 pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
25 pn_created_by number,
26 pn_last_updated_by number,
27 pn_last_update_login number,
28 xv_return_status out nocopy varchar2,
29 xv_return_message out nocopy varchar2
30 );
31
32 /* API to update a single row */
33 PROCEDURE UPDATE_ROW(
34 Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
35 Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
36 Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
37 Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
38 pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
39 pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
40 pn_last_updated_by number,
41 pn_last_update_login number,
42 xv_return_status out nocopy varchar2,
43 xv_return_message out nocopy varchar2
44 );
45
46 /* API to delete a single row */
47 PROCEDURE DELETE_ROW(
48 Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
49 Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
50 Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
51 xv_return_status out nocopy varchar2,
52 xv_return_message out nocopy varchar2
53 );
54
55 END JG_ZZ_VAT_BOX_ALLOCS_PKG;