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.

[Home] [Help]

APPS.JAI_PA_TAX_PKG dependencies on JAI_PA_DRAFT_INVOICE_LINES

Line 98: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,

94: ln_ship_to_address_id pa_draft_invoices_all.ship_to_address_id%type ,
95: -- for credit memo ( invoice ) variables
96: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
97: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
98: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
99: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
100: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
101: ) ;
102:

Line 99: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,

95: -- for credit memo ( invoice ) variables
96: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
97: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
98: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
99: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
100: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
101: ) ;
102:
103: pkg_global_type global_type ;

Line 100: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type

96: ln_draft_invoice_num_credited pa_draft_invoices_all.draft_invoice_num_credited%type ,
97: ln_write_off_flag pa_draft_invoices_all.write_off_flag%type ,
98: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type,
99: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ,
100: ln_line_amt jai_pa_draft_invoice_lines.line_amt%type
101: ) ;
102:
103: pkg_global_type global_type ;
104:

Line 271: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;

267: pv_process_flag out nocopy varchar2
268: ) is
269: ----------------variable declarations---------------------------
270: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
271: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
272: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
273: ln_amount number ;
274: ln_tax_amount number ;
275: -----------------------------------------------------------------

Line 272: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;

268: ) is
269: ----------------variable declarations---------------------------
270: ln_tax_category_id JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ;
271: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
272: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
273: ln_amount number ;
274: ln_tax_amount number ;
275: -----------------------------------------------------------------
276: begin

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

798: procedure insert_line_info (
799: r_new in pa_draft_invoice_items%rowtype,
800: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
801: pv_action in varchar2,
802: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
803: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
804: pv_process_message out nocopy varchar2,
805: pv_process_flag out nocopy varchar2
806: ) is

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

799: r_new in pa_draft_invoice_items%rowtype,
800: pn_tax_category_id in JAI_CMN_TAX_CTGS_ALL.tax_category_id%type ,
801: pv_action in varchar2,
802: pn_draft_invoice_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_id%type ,
803: pn_draft_invoice_line_id out nocopy jai_pa_draft_invoice_lines.draft_invoice_line_id%type ,
804: pv_process_message out nocopy varchar2,
805: pv_process_flag out nocopy varchar2
806: ) is
807:

Line 808: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;

804: pv_process_message out nocopy varchar2,
805: pv_process_flag out nocopy varchar2
806: ) is
807:
808: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
809: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
810: ln_count number ;
811: -- credit memo changes
812: ----------------------------------------------------------------------------------------

Line 809: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;

805: pv_process_flag out nocopy varchar2
806: ) is
807:
808: ln_draft_invoice_id jai_pa_draft_invoice_lines.draft_invoice_id%type ;
809: ln_draft_invoice_line_id jai_pa_draft_invoice_lines.draft_invoice_line_id%type ;
810: ln_count number ;
811: -- credit memo changes
812: ----------------------------------------------------------------------------------------
813: ln_organization_id jai_pa_draft_invoices.organization_id%type;

Line 815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;

811: -- credit memo changes
812: ----------------------------------------------------------------------------------------
813: ln_organization_id jai_pa_draft_invoices.organization_id%type;
814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
819: ----------------------------------------------------------------------------------------

Line 816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;

812: ----------------------------------------------------------------------------------------
813: ln_organization_id jai_pa_draft_invoices.organization_id%type;
814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
819: ----------------------------------------------------------------------------------------
820: -- get draft invoice id for existing draft invoice lines

Line 817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

813: ln_organization_id jai_pa_draft_invoices.organization_id%type;
814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
819: ----------------------------------------------------------------------------------------
820: -- get draft invoice id for existing draft invoice lines
821:

Line 818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;

814: ln_location_id jai_pa_draft_invoices.location_id%type;
815: lv_service_type_code jai_pa_draft_invoice_lines.service_type_code%type;
816: ln_parent_draft_invoice_id jai_pa_draft_invoice_lines.parent_draft_invoice_id%type;
817: ln_parent_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
818: ln_tax_category_id jai_pa_draft_invoice_lines.tax_category_id%type;
819: ----------------------------------------------------------------------------------------
820: -- get draft invoice id for existing draft invoice lines
821:
822: cursor cur_draft_invoice_id is

Line 835: select jai_pa_draft_invoice_lines_s.nextval

831: from dual ;
832:
833: -- generate sequence for line id
834: cursor cur_draft_inv_line_seq is
835: select jai_pa_draft_invoice_lines_s.nextval
836: from dual ;
837:
838: --for credit memo invoice generation
839: -- this cursor find out organization id and location id from header table

Line 851: from jai_pa_draft_invoice_lines

847: draft_invoice_num = pkg_global_type.ln_draft_invoice_num_credited;
848:
849: cursor cur_get_detail_var is
850: select service_type_code ,draft_invoice_id , draft_invoice_line_id ,line_amt , tax_category_id
851: from jai_pa_draft_invoice_lines
852: where project_id =r_new.project_id and
853: draft_invoice_num =pkg_global_type.ln_draft_invoice_num_credited and
854: line_num =r_new.draft_inv_line_num_credited ;
855: --end ----------------------------------------

Line 933: insert into jai_pa_draft_invoice_lines(

929: fetch cur_draft_inv_line_seq into ln_draft_invoice_line_id ;
930: close cur_draft_inv_line_seq;
931:
932: --step4 -- insert information into il table
933: insert into jai_pa_draft_invoice_lines(
934: draft_invoice_line_id ,
935: draft_invoice_id ,
936: project_id ,
937: draft_invoice_num ,

Line 1010: from pa_draft_invoices_all pdia, jai_pa_draft_invoice_lines jpdil

1006: source_doc_type = jai_constants.pa_draft_invoice ;
1007:
1008: cursor cur_get_inv_info is
1009: select pdia.inv_currency_code , pdia.inv_exchange_rate
1010: from pa_draft_invoices_all pdia, jai_pa_draft_invoice_lines jpdil
1011: where pdia.project_id = jpdil.project_id and
1012: pdia.draft_invoice_num = jpdil.draft_invoice_num and
1013: jpdil.draft_invoice_line_id = pn_draft_invoice_line_id and
1014: draft_invoice_id = pn_draft_invoice_id ;

Line 1106: update jai_pa_draft_invoice_lines

1102: open cur_get_tax_amount ;
1103: fetch cur_get_tax_amount into ln_tax_amount ;
1104: close cur_get_tax_amount;
1105:
1106: update jai_pa_draft_invoice_lines
1107: set line_tax_amt = ln_tax_amount
1108: where draft_invoice_line_id = pn_draft_invoice_line_id and
1109: draft_invoice_id = pn_draft_invoice_id ;
1110:

Line 1184: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',

1180: P_LAST_UPDATE_DATE => SYSDATE,
1181: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1182: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1183: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1184: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1185: P_ACTION => JAI_CONSTANTS.DEFAULT_TAXES
1186: ) ;
1187:
1188:

Line 1191: update jai_pa_draft_invoice_lines

1187:
1188:
1189: pn_tax_amount := ln_tax_amount;
1190:
1191: update jai_pa_draft_invoice_lines
1192: set line_tax_amt = pn_tax_amount
1193: where draft_invoice_line_id = pn_draft_invoice_line_id and
1194: draft_invoice_id = pn_draft_invoice_id ;
1195: end if ;

Line 1216: from jai_pa_draft_invoice_lines

1212: begin
1213: delete from jai_cmn_document_taxes
1214: where ( source_doc_id , source_doc_line_id ) in
1215: ( select draft_invoice_id , draft_invoice_line_id
1216: from jai_pa_draft_invoice_lines
1217: where project_id = pn_project_id and
1218: draft_invoice_num = pn_draft_invoice_num
1219: ) ;
1220:

Line 1221: delete from jai_pa_draft_invoice_lines

1217: where project_id = pn_project_id and
1218: draft_invoice_num = pn_draft_invoice_num
1219: ) ;
1220:
1221: delete from jai_pa_draft_invoice_lines
1222: where project_id = pn_project_id and
1223: draft_invoice_num = pn_draft_invoice_num ;
1224:
1225: delete from jai_pa_draft_invoices

Line 1295: from jai_pa_draft_invoice_lines

1291: ln_tax_amount number ;
1292:
1293: cursor cur_get_line_detail is
1294: select draft_invoice_id , draft_invoice_line_id
1295: from jai_pa_draft_invoice_lines
1296: where project_id = r_new.project_id and
1297: draft_invoice_num = r_new.draft_invoice_num and
1298: line_num = r_new.line_num ;
1299:

Line 1333: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',

1329: P_LAST_UPDATE_DATE => SYSDATE,
1330: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1331: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1332: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1333: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1334: P_ACTION => JAI_CONSTANTS.RECALCULATE_TAXES
1335: ) ;
1336:
1337: update jai_pa_draft_invoice_lines

Line 1337: update jai_pa_draft_invoice_lines

1333: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1334: P_ACTION => JAI_CONSTANTS.RECALCULATE_TAXES
1335: ) ;
1336:
1337: update jai_pa_draft_invoice_lines
1338: set line_tax_amt = ln_tax_amount ,
1339: line_amt = r_new.inv_amount
1340: where draft_invoice_line_id = r_get_line_detail.draft_invoice_line_id and
1341: draft_invoice_id = r_get_line_detail.draft_invoice_id ;