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.JE_ES_WHTAX dependencies on JE_ES_MODELO_190_ALL

Line 32: DELETE je_es_modelo_190_all

28: where upper(name) = upper(p_legal_entity_name);
29: If (SQL%NOTFOUND) then
30: RAISE bad_legal_entity;
31: else
32: DELETE je_es_modelo_190_all
33: WHERE legal_entity_id = current_legal_entity_id
34: and fin_ind = p_fin_ind;
35: COMMIT;
36: end if;

Line 48: DELETE je_es_modelo_190_all

44: where UPPER(name) = UPPER(p_org_name);
45: If (SQL%NOTFOUND) then
46: RAISE bad_org_name;
47: else
48: DELETE je_es_modelo_190_all
49: WHERE org_id = current_org_id
50: and fin_ind = p_fin_ind;
51: COMMIT;
52: end if;

Line 68: DELETE je_es_modelo_190_all

64: PROCEDURE del_trans_s ( p_conc_req_id IN NUMBER,
65: p_legal_entity_id IN NUMBER,
66: p_org_id IN NUMBER ) IS
67: BEGIN
68: DELETE je_es_modelo_190_all
69: WHERE fin_ind = 'S'
70: and conc_req_id = p_conc_req_id
71: and legal_entity_id = p_legal_entity_id;
72: -- bug 5207771: Removed org_id condition

Line 80: DELETE je_es_modelo_190_all

76: /* Delete Oracle Payables Magnetic transactions */
77: PROCEDURE del_trans_m ( p_legal_entity_id IN NUMBER,
78: p_org_id IN NUMBER) IS
79: BEGIN
80: DELETE je_es_modelo_190_all
81: WHERE fin_ind = 'S'
82: and conc_req_id is NULL
83: and legal_entity_id = p_legal_entity_id;
84: -- bug 5207771: Removed org_id condition

Line 162: INSERT INTO je_es_modelo_190_all(

158: else
159: current_org_id := NULL;
160: end if;
161: */
162: INSERT INTO je_es_modelo_190_all(
163: legal_entity_id,
164: -- org_id, -- Bug 5207771 org_id removed
165: fin_ind,
166: remun_type,

Line 325: INSERT INTO je_es_modelo_190_all(

321: else
322: current_org_id := NULL;
323: end if;
324: */
325: INSERT INTO je_es_modelo_190_all(
326: legal_entity_id,
327: -- org_id, -- Bug 5207771 org_id removed
328: fin_ind,
329: remun_type,

Line 441: INSERT INTO je_es_modelo_190_all( legal_entity_id,

437: tax_name VARCHAR2,
438: year_due NUMBER
439: ) IS
440: BEGIN
441: INSERT INTO je_es_modelo_190_all( legal_entity_id,
442: org_id,
443: conc_req_id,
444: fin_ind,
445: remun_type,

Line 615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;

611: bad_parameters EXCEPTION;
612: bad_awt_lines EXCEPTION; -- Bug 1271489
613: countrecs NUMBER;
614: first_record NUMBER := 0;
615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

Line 616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;

612: bad_awt_lines EXCEPTION; -- Bug 1271489
613: countrecs NUMBER;
614: first_record NUMBER := 0;
615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;

Line 617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;

613: countrecs NUMBER;
614: first_record NUMBER := 0;
615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;

Line 618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;

614: first_record NUMBER := 0;
615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;

Line 619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

615: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;

Line 620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;

616: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;

Line 621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;

617: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;

Line 622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;

618: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

Line 623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;

619: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

Line 624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;

620: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;

Line 625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;

621: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

622: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;

Line 627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

623: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
631: wht_mode ap_invoices.payment_status_flag%TYPE;

Line 628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;

624: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
631: wht_mode ap_invoices.payment_status_flag%TYPE;
632: inv_awt_flag ap_invoices.awt_flag%TYPE;

Line 629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

625: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
626: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
627: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
628: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
631: wht_mode ap_invoices.payment_status_flag%TYPE;
632: inv_awt_flag ap_invoices.awt_flag%TYPE;
633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

629: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
631: wht_mode ap_invoices.payment_status_flag%TYPE;
632: inv_awt_flag ap_invoices.awt_flag%TYPE;
633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

630: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
631: wht_mode ap_invoices.payment_status_flag%TYPE;
632: inv_awt_flag ap_invoices.awt_flag%TYPE;
633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

631: wht_mode ap_invoices.payment_status_flag%TYPE;
632: inv_awt_flag ap_invoices.awt_flag%TYPE;
633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

632: inv_awt_flag ap_invoices.awt_flag%TYPE;
633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

633: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

Line 638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

634: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

Line 639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

635: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

Line 640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

636: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;

Line 641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

637: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;

Line 642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

638: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;

Line 643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

639: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;

Line 644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;

640: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;

Line 645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;

641: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;

Line 646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;

642: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;

Line 647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;

643: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
651: invoice_payments_count number := 0;

Line 648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;

644: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
651: invoice_payments_count number := 0;
652: func_curr fnd_currencies_vl.currency_code%TYPE;

Line 649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;

645: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
651: invoice_payments_count number := 0;
652: func_curr fnd_currencies_vl.currency_code%TYPE;
653: func_curr_precision fnd_currencies_vl.precision%TYPE;

Line 650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;

646: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
647: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
648: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
649: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
651: invoice_payments_count number := 0;
652: func_curr fnd_currencies_vl.currency_code%TYPE;
653: func_curr_precision fnd_currencies_vl.precision%TYPE;
654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;

Line 654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;

650: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
651: invoice_payments_count number := 0;
652: func_curr fnd_currencies_vl.currency_code%TYPE;
653: func_curr_precision fnd_currencies_vl.precision%TYPE;
654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;

Line 655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;

651: invoice_payments_count number := 0;
652: func_curr fnd_currencies_vl.currency_code%TYPE;
653: func_curr_precision fnd_currencies_vl.precision%TYPE;
654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

Line 656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

652: func_curr fnd_currencies_vl.currency_code%TYPE;
653: func_curr_precision fnd_currencies_vl.precision%TYPE;
654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;

Line 657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;

653: func_curr_precision fnd_currencies_vl.precision%TYPE;
654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

Line 658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;

654: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

Line 659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

655: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
663: l_le_id_count NUMBER;

Line 660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;

656: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
663: l_le_id_count NUMBER;
664: l_le_id_message VARCHAR2(500);

Line 661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

657: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
663: l_le_id_count NUMBER;
664: l_le_id_message VARCHAR2(500);
665: l_ledger_id number;

Line 662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

658: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
659: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
660: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
661: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
662: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
663: l_le_id_count NUMBER;
664: l_le_id_message VARCHAR2(500);
665: l_ledger_id number;
666: --

Line 1960: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

1956: p_legal_entity_id IN number,
1957: p_org_id IN number) is
1958: l_tax_code_id ap_tax_codes.tax_id%TYPE;
1959: l_invoice_num ap_invoices.invoice_num%TYPE;
1960: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
1961: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
1962: l_accounting_date ap_invoice_distributions_all.accounting_date%TYPE;
1963: begin
1964: begin

Line 1961: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

1957: p_org_id IN number) is
1958: l_tax_code_id ap_tax_codes.tax_id%TYPE;
1959: l_invoice_num ap_invoices.invoice_num%TYPE;
1960: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
1961: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
1962: l_accounting_date ap_invoice_distributions_all.accounting_date%TYPE;
1963: begin
1964: begin
1965: if p_fetch_pi_flag = 'P' then

Line 2039: FROM je_es_modelo_190_all

2035: fnd_file.put_line( fnd_file.log,' ');
2036: -- Added for bug 5277700.
2037: SELECT COUNT(*)
2038: INTO l_le_id_count
2039: FROM je_es_modelo_190_all
2040: WHERE legal_entity_id IS NULL;
2041: IF l_le_id_count > 0 THEN
2042: je_es_mod_le_update.update_main;
2043: /* fnd_message.set_name('JE', 'JE_WHT_LEGAL_ENTITY_ID_UPG');

Line 2044: fnd_message.set_token('TABLE', 'JE_ES_MODELO_190_ALL');

2040: WHERE legal_entity_id IS NULL;
2041: IF l_le_id_count > 0 THEN
2042: je_es_mod_le_update.update_main;
2043: /* fnd_message.set_name('JE', 'JE_WHT_LEGAL_ENTITY_ID_UPG');
2044: fnd_message.set_token('TABLE', 'JE_ES_MODELO_190_ALL');
2045: l_le_id_message := fnd_message.get;
2046: errbuf := l_le_id_message;
2047: retcode := -1;
2048: RETURN;

Line 2241: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');

2237: tax_rate => NULL,
2238: tax_name => NULL,
2239: year_due => NULL);
2240: end if;
2241: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2242: CLOSE detail_paid;
2243: plsqlmsg('CURSOR Closed');
2244: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2245: ELSE -- p_pay_inv_sel <> 'P'

Line 2298: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');

2294: tax_name => tax_name1,
2295: year_due => year_due1);
2296: end if;
2297: END LOOP;
2298: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2299: CLOSE sum_approve_mag;
2300: plsqlmsg('CURSOR Closed');
2301: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2302: end if; -- p_pay_inv_sel = 'P' or <> 'P'

Line 2420: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');

2416: tax_name => tax_name1,
2417: year_due => year_due1);
2418: end if;
2419: END LOOP;
2420: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2421: CLOSE detail_paid;
2422: plsqlmsg('CURSOR Closed');
2423: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2424: else -- p_pay_inv_sel <> 'P'

Line 2479: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');

2475: tax_name => tax_name1,
2476: year_due => NULL);
2477: end if;
2478: END LOOP;
2479: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2480: CLOSE detail_approve;
2481: plsqlmsg('CURSOR Closed');
2482: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2483: end if; -- p_pay_inv_sel = 'P' or <> 'P'

Line 2600: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');

2596: tax_name => tax_name1,
2597: year_due => year_due1);
2598: end if;
2599: END LOOP;
2600: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2601: CLOSE detail_paid;
2602: plsqlmsg('CURSOR Closed');
2603: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2604: else -- p_pay_inv_sel <> 'P'

Line 2668: plsqlmsg('Data inserted into table JE_ES_MODELO_190_all');

2664: tax_name => tax_name1,
2665: year_due => year_due1);
2666: end if;
2667: END LOOP;
2668: plsqlmsg('Data inserted into table JE_ES_MODELO_190_all');
2669: CLOSE detail_approve;
2670: plsqlmsg('CURSOR Closed');
2671: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2672: RETCODE := 0;