[Home] [Help]
62: -- if pv_action is default_taxes then it will go for defaultation of taxes
63: -- if pv_action is recalculate_taxes then it will go for recalculation of taxes
64: --------------------------------------------------------------------------------------------
65: procedure calculate_taxes(
66: r_new in pa_draft_invoice_items%rowtype,
67: pv_action in varchar2,
68: pv_process_message out nocopy varchar2,
69: pv_process_flag out nocopy varchar2
70: ) ;
78: ---- 3. default taxes for these information
79: --------------------------------------------------------------------------------------------
80:
81: procedure tax_defaultation_line(
82: r_new in pa_draft_invoice_items%rowtype,
83: pv_action in varchar2,
84: pv_process_message out nocopy varchar2,
85: pv_process_flag out nocopy varchar2
86: ) ;
89: -- procedure name -- tax_recalculate_line
90: --- purpose -- responsibility for reaclculating taxes
91: ---------------------------------------------------------------------------------------------------------------
92: procedure tax_recalculate_line(
93: r_new in pa_draft_invoice_items%rowtype,
94: pv_action in varchar2,
95: pv_process_message out nocopy varchar2,
96: pv_process_flag out nocopy varchar2
97: ) ;
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,
111: pv_process_message out nocopy varchar2,
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,
111: pv_process_message out nocopy varchar2,
112: pv_process_flag out nocopy varchar2,
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,
111: pv_process_message out nocopy varchar2,
112: pv_process_flag out nocopy varchar2,
113: pn_tax_category_id out nocopy JAI_CMN_TAX_CTGS_ALL.tax_category_id%type
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 ,
126: pv_process_status out nocopy varchar2 ,
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 ,
126: pv_process_status out nocopy varchar2 ,
127: pv_process_message out nocopy varchar2,
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 ,
126: pv_process_status out nocopy varchar2 ,
127: pv_process_message out nocopy varchar2,
128: pv_process_flag out nocopy varchar2
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,
144: pv_process_flag out nocopy varchar2
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,
159: pv_process_flag out nocopy varchar2
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,
172: pv_process_flag out nocopy varchar2
175: -- procedure name -- insert_line_info
176: --- purpose -- responsible for inserting information in to india localizations tables
177: ---------------------------------------------------------------------------------------------------------------
178: procedure insert_line_info (
179: r_new in pa_draft_invoice_items%rowtype,
180: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
181: pv_action in varchar2,
182: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
183: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,