eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JG_ZZ_VAT_BOX_ALLOCS_PKG dependencies on JG_ZZ_VAT_BOX_ALLOCS

Line 1: PACKAGE JG_ZZ_VAT_BOX_ALLOCS_PKG AUTHID CURRENT_USER AS

1: PACKAGE JG_ZZ_VAT_BOX_ALLOCS_PKG AUTHID CURRENT_USER 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

Line 14: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,

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,

Line 15: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%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,

Line 16: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%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,

Line 17: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%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,

Line 18: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%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,

Line 19: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%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,

Line 20: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%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,

Line 21: pn_request_id jg_zz_vat_box_allocs.request_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,

Line 22: pn_program_application_id jg_zz_vat_box_allocs.program_application_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,

Line 23: pn_program_id jg_zz_vat_box_allocs.program_id%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,

Line 24: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%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,

Line 34: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,

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,

Line 35: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_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,

Line 36: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%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,

Line 37: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,

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,

Line 38: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,

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,

Line 39: pn_program_login_id jg_zz_vat_box_allocs.program_login_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

Line 48: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,

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

Line 49: Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,

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: );

Line 50: Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,

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:

Line 55: END JG_ZZ_VAT_BOX_ALLOCS_PKG;

51: xv_return_status out nocopy varchar2,
52: xv_return_message out nocopy varchar2
53: );
54:
55: END JG_ZZ_VAT_BOX_ALLOCS_PKG;