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
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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: );
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:
51: xv_return_status out nocopy varchar2,
52: xv_return_message out nocopy varchar2
53: );
54:
55: END JG_ZZ_VAT_BOX_ALLOCS_PKG;