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 BODY JG_ZZ_VAT_BOX_ALLOCS_PKG AS

1: PACKAGE BODY JG_ZZ_VAT_BOX_ALLOCS_PKG AS
2: /* $Header: jgzzvatboxallocb.pls 120.1 2006/07/26 14:09:37 brathod ship $*/
3: /*------------------------------------------------------------------------------------------------------------
4: CHANGE HISTORY
5: 1. Vijay Shankar 20-Jan-2005 File Version 120.0

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

11: ------------------------------------------------------------------------------------------------------------*/
12:
13: /* API to insert a single row */
14: procedure INSERT_ROW(
15: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,

Line 16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,

12:
13: /* API to insert a single row */
14: procedure INSERT_ROW(
15: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,

Line 17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,

13: /* API to insert a single row */
14: procedure INSERT_ROW(
15: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,

Line 18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,

14: procedure INSERT_ROW(
15: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,

Line 19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,

15: XN_VAT_BOX_ALLOCATION_ID OUT nocopy jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,

Line 20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,

16: PN_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,

Line 21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,

17: PV_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,

Line 22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,

18: PN_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
26: pn_created_by number,

Line 23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,

19: PV_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
26: pn_created_by number,
27: pn_last_updated_by number,

Line 24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,

20: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
26: pn_created_by number,
27: pn_last_updated_by number,
28: pn_last_update_login number,

Line 25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,

21: PV_TAX_RECOVERABLE_FLAG jg_zz_vat_box_allocs.TAX_RECOVERABLE_FLAG%TYPE,
22: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
23: pn_program_application_id jg_zz_vat_box_allocs.program_application_id%TYPE,
24: pn_program_id jg_zz_vat_box_allocs.program_id%TYPE,
25: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
26: pn_created_by number,
27: pn_last_updated_by number,
28: pn_last_update_login number,
29: xv_return_status out nocopy varchar2,

Line 35: INSERT INTO jg_zz_vat_box_allocs(

31: ) is
32:
33:
34: begin
35: INSERT INTO jg_zz_vat_box_allocs(
36: vat_box_allocation_id ,
37: vat_transaction_id ,
38: allocation_rule_id ,
39: period_type ,

Line 54: jg_zz_vat_box_allocs_s.nextval,

50: last_update_date ,
51: last_updated_by ,
52: last_update_login
53: ) VALUES (
54: jg_zz_vat_box_allocs_s.nextval,
55: pn_vat_transaction_id ,
56: pn_allocation_rule_id ,
57: pv_period_type ,
58: pv_tax_box ,

Line 76: xv_return_message := 'jg_zz_vat_box_allocs_pkg.insert_row ~ Unexpected Error -' || sqlerrm;

72:
73: exception
74: when others then
75: xv_return_status := fnd_api.g_ret_sts_unexp_error;
76: xv_return_message := 'jg_zz_vat_box_allocs_pkg.insert_row ~ Unexpected Error -' || sqlerrm;
77:
78: end INSERT_ROW;
79:
80: /* API to update a single row */

Line 82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,

78: end INSERT_ROW;
79:
80: /* API to update a single row */
81: procedure UPDATE_ROW(
82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,

Line 83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,

79:
80: /* API to update a single row */
81: procedure UPDATE_ROW(
82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,

Line 84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,

80: /* API to update a single row */
81: procedure UPDATE_ROW(
82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
88: pn_last_updated_by number,

Line 85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,

81: procedure UPDATE_ROW(
82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
88: pn_last_updated_by number,
89: pn_last_update_login number,

Line 86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,

82: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
88: pn_last_updated_by number,
89: pn_last_update_login number,
90: xv_return_status out nocopy varchar2,

Line 87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,

83: Pn_ALLOCATION_RULE_ID jg_zz_vat_box_allocs.ALLOCATION_RULE_ID%TYPE,
84: Pv_TAX_BOX jg_zz_vat_box_allocs.TAX_BOX%TYPE,
85: Pv_TAXABLE_BOX jg_zz_vat_box_allocs.TAXABLE_BOX%TYPE,
86: pn_request_id jg_zz_vat_box_allocs.request_id%TYPE,
87: pn_program_login_id jg_zz_vat_box_allocs.program_login_id%TYPE,
88: pn_last_updated_by number,
89: pn_last_update_login number,
90: xv_return_status out nocopy varchar2,
91: xv_return_message out nocopy varchar2

Line 95: UPDATE jg_zz_vat_box_allocs

91: xv_return_message out nocopy varchar2
92: ) is
93:
94: begin
95: UPDATE jg_zz_vat_box_allocs
96: SET allocation_rule_id = pn_allocation_rule_id,
97: tax_box = nvl(pv_tax_box, tax_box),
98: taxable_box = nvl(pv_taxable_box, taxable_box),
99: program_update_date = sysdate,

Line 110: xv_return_message := 'jg_zz_vat_box_allocs_pkg.update_row ~ Unexpected Error -' || sqlerrm;

106:
107: exception
108: when others then
109: xv_return_status := fnd_api.g_ret_sts_unexp_error;
110: xv_return_message := 'jg_zz_vat_box_allocs_pkg.update_row ~ Unexpected Error -' || sqlerrm;
111:
112: end UPDATE_ROW;
113:
114: /* API to delete a single row */

Line 116: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,

112: end UPDATE_ROW;
113:
114: /* API to delete a single row */
115: procedure DELETE_ROW(
116: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
117: Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
118: Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
119: xv_return_status out nocopy varchar2,
120: xv_return_message out nocopy varchar2

Line 117: Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,

113:
114: /* API to delete a single row */
115: procedure DELETE_ROW(
116: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
117: Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
118: Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
119: xv_return_status out nocopy varchar2,
120: xv_return_message out nocopy varchar2
121: ) is

Line 118: Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,

114: /* API to delete a single row */
115: procedure DELETE_ROW(
116: Pn_VAT_BOX_ALLOCATION_ID jg_zz_vat_box_allocs.VAT_BOX_ALLOCATION_ID%TYPE,
117: Pn_VAT_TRANSACTION_ID jg_zz_vat_box_allocs.VAT_TRANSACTION_ID%TYPE,
118: Pv_PERIOD_TYPE jg_zz_vat_box_allocs.PERIOD_TYPE%TYPE,
119: xv_return_status out nocopy varchar2,
120: xv_return_message out nocopy varchar2
121: ) is
122:

Line 125: DELETE FROM jg_zz_vat_box_allocs

121: ) is
122:
123: begin
124: if pn_vat_Box_allocation_id is not null then
125: DELETE FROM jg_zz_vat_box_allocs
126: WHERE vat_box_allocation_id = pn_vat_box_allocation_id;
127: else
128: DELETE FROM jg_zz_vat_box_allocs
129: WHERE vat_transaction_id = pn_vat_transaction_id

Line 128: DELETE FROM jg_zz_vat_box_allocs

124: if pn_vat_Box_allocation_id is not null then
125: DELETE FROM jg_zz_vat_box_allocs
126: WHERE vat_box_allocation_id = pn_vat_box_allocation_id;
127: else
128: DELETE FROM jg_zz_vat_box_allocs
129: WHERE vat_transaction_id = pn_vat_transaction_id
130: AND period_type = pv_period_type;
131: end if;
132:

Line 136: xv_return_message := 'jg_zz_vat_box_allocs_pkg.delete_row ~ Unexpected Error -' || sqlerrm;

132:
133: exception
134: when others then
135: xv_return_status := fnd_api.g_ret_sts_unexp_error;
136: xv_return_message := 'jg_zz_vat_box_allocs_pkg.delete_row ~ Unexpected Error -' || sqlerrm;
137:
138: end DELETE_ROW;
139:
140: end JG_ZZ_VAT_BOX_ALLOCS_PKG;

Line 140: end JG_ZZ_VAT_BOX_ALLOCS_PKG;

136: xv_return_message := 'jg_zz_vat_box_allocs_pkg.delete_row ~ Unexpected Error -' || sqlerrm;
137:
138: end DELETE_ROW;
139:
140: end JG_ZZ_VAT_BOX_ALLOCS_PKG;