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.JAI_PA_TAX_PKG dependencies on PA_DRAFT_INVOICES_ALL

Line 27: -- pn_request_id - request id of projects table pa_draft_invoices_all for concurrent

23: -- procedure name -- tax_defaultation
24: -- global procedure to call by trigger
25: -- it is called by trigger to do either defaultation of taxes or recalculation of taxes according to event send by trigger
26: ------parameter details---------------------------------------------------------------------------------------------------
27: -- pn_request_id - request id of projects table pa_draft_invoices_all for concurrent
28: -- pn_project_id - project id
29: -- pn_draft_invoice_num - draft invoice number
30: -- pv_event - either defaultation of taxes of recalculate taxes
31: -- jai_constants.default_taxes

Line 39: pn_request_id in pa_draft_invoices_all.request_id%type ,

35: procedure calc_taxes_for_invoices
36: (
37: err_buf out nocopy varchar2 ,
38: retcode out nocopy varchar2 ,
39: pn_request_id in pa_draft_invoices_all.request_id%type ,
40: pn_project_id in pa_draft_invoices_all.project_id%type ,
41: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
42: pv_event in varchar2
43: ) ;

Line 40: pn_project_id in pa_draft_invoices_all.project_id%type ,

36: (
37: err_buf out nocopy varchar2 ,
38: retcode out nocopy varchar2 ,
39: pn_request_id in pa_draft_invoices_all.request_id%type ,
40: pn_project_id in pa_draft_invoices_all.project_id%type ,
41: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
42: pv_event in varchar2
43: ) ;
44:

Line 41: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

37: err_buf out nocopy varchar2 ,
38: retcode out nocopy varchar2 ,
39: pn_request_id in pa_draft_invoices_all.request_id%type ,
40: pn_project_id in pa_draft_invoices_all.project_id%type ,
41: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
42: pv_event in varchar2
43: ) ;
44:
45: ---------------------------------------------------------------------------------------------------------------

Line 51: r_new in pa_draft_invoices_all%rowtype,

47: -- procedure is responsible for calculate taxes for header level information in projects
48: --------------------------------------------------------------------------------------------
49:
50: procedure dflt_taxes_for_invoice_lines(
51: r_new in pa_draft_invoices_all%rowtype,
52: pv_action in varchar2,
53: pv_process_message out nocopy varchar2,
54: pv_process_flag out nocopy varchar2
55: ) ;

Line 105: pn_project_id in pa_draft_invoices_all.project_id%type ,

101: -- procedure name -- get_tax_category
102: --- purpose -- responsible for returning tax category to calling object for further operation
103: ---------------------------------------------------------------------------------------------------------------
104: procedure get_tax_category(
105: pn_project_id in pa_draft_invoices_all.project_id%type ,
106: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
107: pn_line_num in pa_draft_invoice_items.line_num%type ,
108: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
109: pn_event_num in pa_draft_invoice_items.event_num%type,

Line 106: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

102: --- purpose -- responsible for returning tax category to calling object for further operation
103: ---------------------------------------------------------------------------------------------------------------
104: procedure get_tax_category(
105: pn_project_id in pa_draft_invoices_all.project_id%type ,
106: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
107: pn_line_num in pa_draft_invoice_items.line_num%type ,
108: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
109: pn_event_num in pa_draft_invoice_items.event_num%type,
110: pv_action in varchar2,

Line 120: pn_project_id in pa_draft_invoices_all.project_id%type ,

116: -- procedure name -- get_event_tax_category
117: --- purpose -- responsible for returning tax category for event types
118: ---------------------------------------------------------------------------------------------------------------
119: procedure get_event_tax_category (
120: pn_project_id in pa_draft_invoices_all.project_id%type ,
121: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
122: pn_line_num in pa_draft_invoice_items.line_num%type ,
123: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
124: pn_event_num in pa_draft_invoice_items.event_num%type,

Line 121: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

117: --- purpose -- responsible for returning tax category for event types
118: ---------------------------------------------------------------------------------------------------------------
119: procedure get_event_tax_category (
120: pn_project_id in pa_draft_invoices_all.project_id%type ,
121: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
122: pn_line_num in pa_draft_invoice_items.line_num%type ,
123: pn_event_task_id in pa_draft_invoice_items.event_task_id%type,
124: pn_event_num in pa_draft_invoice_items.event_num%type,
125: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,

Line 138: pn_project_id in pa_draft_invoices_all.project_id%type ,

134: ---------------------------------------------------------------------------------------------------------------
135:
136: procedure get_project_tax_category
137: (
138: pn_project_id in pa_draft_invoices_all.project_id%type ,
139: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
140: pn_line_num in pa_draft_invoice_items.line_num%type ,
141: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
142: pv_process_status out nocopy varchar2 ,

Line 139: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

135:
136: procedure get_project_tax_category
137: (
138: pn_project_id in pa_draft_invoices_all.project_id%type ,
139: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
140: pn_line_num in pa_draft_invoice_items.line_num%type ,
141: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
142: pv_process_status out nocopy varchar2 ,
143: pv_process_message out nocopy varchar2,

Line 153: ( pn_project_id in pa_draft_invoices_all.project_id%type ,

149: --- purpose -- responsible for returning tax category for customer - site or customer - null site combination
150: ---------------------------------------------------------------------------------------------------------------
151:
152: procedure get_cust_tax_category
153: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
154: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
155: pn_line_num in pa_draft_invoice_items.line_num%type ,
156: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
157: pv_process_status out nocopy varchar2 ,

Line 154: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

150: ---------------------------------------------------------------------------------------------------------------
151:
152: procedure get_cust_tax_category
153: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
154: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
155: pn_line_num in pa_draft_invoice_items.line_num%type ,
156: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
157: pv_process_status out nocopy varchar2 ,
158: pv_process_message out nocopy varchar2,

Line 166: ( pn_project_id in pa_draft_invoices_all.project_id%type ,

162: -- procedure name -- get_expn_tax_category
163: --- purpose -- responsible for returning tax category for expenditure type
164: ---------------------------------------------------------------------------------------------------------------
165: procedure get_expn_tax_category
166: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
167: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
168: pn_line_num in pa_draft_invoice_items.line_num%type ,
169: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
170: pv_process_status out nocopy varchar2 ,

Line 167: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,

163: --- purpose -- responsible for returning tax category for expenditure type
164: ---------------------------------------------------------------------------------------------------------------
165: procedure get_expn_tax_category
166: ( pn_project_id in pa_draft_invoices_all.project_id%type ,
167: pn_draft_invoice_num in pa_draft_invoices_all.draft_invoice_num%type ,
168: pn_line_num in pa_draft_invoice_items.line_num%type ,
169: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
170: pv_process_status out nocopy varchar2 ,
171: pv_process_message out nocopy varchar2,