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 JAI_PA_DRAFT_INVOICE_LINES

Line 108: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,

104: ln_ship_to_address_id pa_draft_invoices_all.ship_to_address_id%type ,
105: -- for credit memo ( invoice ) variables
106: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
107: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
108: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
109: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
110: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
111: ) ;
112:

Line 109: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,

105: -- for credit memo ( invoice ) variables
106: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
107: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
108: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
109: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
110: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
111: ) ;
112:
113: pkg_global_type global_type ;

Line 110: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type

106: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
107: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
108: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
109: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
110: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
111: ) ;
112:
113: pkg_global_type global_type ;
114:

Line 281: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;

277: pv_process_flag out nocopy varchar2
278: ) is
279: ----------------variable declarations---------------------------
280: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
281: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
282: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
283: ln_amount number ;
284: ln_tax_amount number ;
285: -----------------------------------------------------------------

Line 282: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;

278: ) is
279: ----------------variable declarations---------------------------
280: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
281: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
282: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
283: ln_amount number ;
284: ln_tax_amount number ;
285: -----------------------------------------------------------------
286: begin

Line 843: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,

839: procedure insert_line_info (
840: r_new in pa_draft_invoice_items%rowtype,
841: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
842: pv_action in varchar2,
843: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
844: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
845: pv_process_message out nocopy varchar2,
846: pv_process_flag out nocopy varchar2
847: ) is

Line 844: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,

840: r_new in pa_draft_invoice_items%rowtype,
841: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
842: pv_action in varchar2,
843: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
844: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
845: pv_process_message out nocopy varchar2,
846: pv_process_flag out nocopy varchar2
847: ) is
848:

Line 849: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;

845: pv_process_message out nocopy varchar2,
846: pv_process_flag out nocopy varchar2
847: ) is
848:
849: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
850: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
851: ln_count number ;
852: -- credit memo changes
853: ----------------------------------------------------------------------------------------

Line 850: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;

846: pv_process_flag out nocopy varchar2
847: ) is
848:
849: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
850: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
851: ln_count number ;
852: -- credit memo changes
853: ----------------------------------------------------------------------------------------
854: ln_organization_id jai_pa_draft_invoices.organization_id%type;

Line 856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;

852: -- credit memo changes
853: ----------------------------------------------------------------------------------------
854: ln_organization_id jai_pa_draft_invoices.organization_id%type;
855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
860: ----------------------------------------------------------------------------------------

Line 857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;

853: ----------------------------------------------------------------------------------------
854: ln_organization_id jai_pa_draft_invoices.organization_id%type;
855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
860: ----------------------------------------------------------------------------------------
861: -- get draft invoice id for existing draft invoice lines

Line 858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

854: ln_organization_id jai_pa_draft_invoices.organization_id%type;
855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
860: ----------------------------------------------------------------------------------------
861: -- get draft invoice id for existing draft invoice lines
862:

Line 859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

855: ln_location_id jai_pa_draft_invoices.location_id%type;
856: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
857: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
858: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
859: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
860: ----------------------------------------------------------------------------------------
861: -- get draft invoice id for existing draft invoice lines
862:
863: cursor cur_draft_invoice_id is

Line 876: select jai_pa_draft_invoice_lines_s.nextval

872: from dual ;
873:
874: -- generate sequence for line id
875: cursor cur_draft_inv_line_seq is
876: select jai_pa_draft_invoice_lines_s.nextval
877: from dual ;
878:
879: --for credit memo invoice generation
880: -- this cursor find out organization id and location id from header table

Line 892: from jai_pa_draft_invoice_lines

888: draft_invoice_num = pkg_global_type.ln_draft_invoice_num_credited;
889:
890: cursor cur_get_detail_var is
891: select service_type_code ,draft_invoice_id , draft_invoice_line_id ,line_amt , tax_category_id
892: from jai_pa_draft_invoice_lines
893: where project_id =r_new.project_id and
894: draft_invoice_num =pkg_global_type.ln_draft_invoice_num_credited and
895: line_num =r_new.draft_inv_line_num_credited ;
896: --end ----------------------------------------

Line 974: insert into jai_pa_draft_invoice_lines(

970: fetch cur_draft_inv_line_seq into ln_draft_invoice_line_id ;
971: close cur_draft_inv_line_seq;
972:
973: --step4 -- insert information into il table
974: insert into jai_pa_draft_invoice_lines(
975: draft_invoice_line_id ,
976: draft_invoice_id ,
977: project_id ,
978: draft_invoice_num ,

Line 1051: from pa_draft_invoices_all pdia, jai_pa_draft_invoice_lines jpdil

1047: source_doc_type = jai_constants.pa_draft_invoice ;
1048:
1049: cursor cur_get_inv_info is
1050: select pdia.inv_currency_code , nvl(projfunc_invtrans_ex_rate,1) /*13513070 - Replaced inv_exchange_rate*/
1051: from pa_draft_invoices_all pdia, jai_pa_draft_invoice_lines jpdil
1052: where pdia.project_id = jpdil.project_id and
1053: pdia.draft_invoice_num = jpdil.draft_invoice_num and
1054: jpdil.draft_invoice_line_id = pn_draft_invoice_line_id and
1055: draft_invoice_id = pn_draft_invoice_id ;

Line 1147: update jai_pa_draft_invoice_lines

1143: open cur_get_tax_amount ;
1144: fetch cur_get_tax_amount into ln_tax_amount ;
1145: close cur_get_tax_amount;
1146:
1147: update jai_pa_draft_invoice_lines
1148: set line_tax_amt = ln_tax_amount
1149: where draft_invoice_line_id = pn_draft_invoice_line_id and
1150: draft_invoice_id = pn_draft_invoice_id ;
1151:

Line 1225: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',

1221: P_LAST_UPDATE_DATE => SYSDATE,
1222: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1223: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1224: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1225: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1226: P_ACTION => JAI_CONSTANTS.DEFAULT_TAXES
1227: /* for bug 16013918 by anupgupt
1228: , pn_gst_assessable_value=> ln_tax_amount -- Added by Eric Ma for Bug10043656 ,GST enhancement on Sep-14-2010
1229: */

Line 1235: update jai_pa_draft_invoice_lines

1231:
1232:
1233: pn_tax_amount := ln_tax_amount;
1234:
1235: update jai_pa_draft_invoice_lines
1236: set line_tax_amt = pn_tax_amount
1237: where draft_invoice_line_id = pn_draft_invoice_line_id and
1238: draft_invoice_id = pn_draft_invoice_id ;
1239: end if ;

Line 1260: from jai_pa_draft_invoice_lines

1256: begin
1257: delete from jai_cmn_document_taxes
1258: where ( source_doc_id , source_doc_line_id ) in
1259: ( select draft_invoice_id , draft_invoice_line_id
1260: from jai_pa_draft_invoice_lines
1261: where project_id = pn_project_id and
1262: draft_invoice_num = pn_draft_invoice_num
1263: ) ;
1264:

Line 1265: delete from jai_pa_draft_invoice_lines

1261: where project_id = pn_project_id and
1262: draft_invoice_num = pn_draft_invoice_num
1263: ) ;
1264:
1265: delete from jai_pa_draft_invoice_lines
1266: where project_id = pn_project_id and
1267: draft_invoice_num = pn_draft_invoice_num ;
1268:
1269: delete from jai_pa_draft_invoices

Line 1339: from jai_pa_draft_invoice_lines

1335: ln_tax_amount number ;
1336:
1337: cursor cur_get_line_detail is
1338: select draft_invoice_id , draft_invoice_line_id
1339: from jai_pa_draft_invoice_lines
1340: where project_id = r_new.project_id and
1341: draft_invoice_num = r_new.draft_invoice_num and
1342: line_num = r_new.line_num ;
1343:

Line 1377: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',

1373: P_LAST_UPDATE_DATE => SYSDATE,
1374: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1375: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1376: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1377: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1378: P_ACTION => JAI_CONSTANTS.RECALCULATE_TAXES
1379: /* for bug 16013918 by anupgupt
1380: , pn_gst_assessable_value => ln_tax_amount -- Added by Eric Ma for Bug10043656 ,GST enhancement on Sep-14-2010
1381: */

Line 1384: update jai_pa_draft_invoice_lines

1380: , pn_gst_assessable_value => ln_tax_amount -- Added by Eric Ma for Bug10043656 ,GST enhancement on Sep-14-2010
1381: */
1382: ) ;
1383:
1384: update jai_pa_draft_invoice_lines
1385: set line_tax_amt = ln_tax_amount ,
1386: line_amt = r_new.inv_amount
1387: where draft_invoice_line_id = r_get_line_detail.draft_invoice_line_id and
1388: draft_invoice_id = r_get_line_detail.draft_invoice_id ;