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.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 621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;

617: bad_parameters EXCEPTION;
618: bad_awt_lines EXCEPTION; -- Bug 1271489
619: countrecs NUMBER;
620: first_record NUMBER := 0;
621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

Line 622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;

618: bad_awt_lines EXCEPTION; -- Bug 1271489
619: countrecs NUMBER;
620: first_record NUMBER := 0;
621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;

Line 623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;

619: countrecs NUMBER;
620: first_record NUMBER := 0;
621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;

Line 624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;

620: first_record NUMBER := 0;
621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;

Line 625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

621: conc_req_id1 JE_ES_MODELO_190_ALL.conc_req_id%TYPE;
622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;

Line 626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;

622: fin_ind1 JE_ES_MODELO_190_ALL.fin_ind%TYPE;
623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;

Line 627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;

623: remun_type1 JE_ES_MODELO_190_ALL.remun_type%TYPE;
624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;

Line 628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;

624: sub_remun_type1 JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

Line 629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;

625: vendor_nif1 JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

Line 630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;

626: vendor_name1 JE_ES_MODELO_190_ALL.vendor_name%TYPE;
627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;

Line 631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;

627: invoice_id1 JE_ES_MODELO_190_ALL.invoice_id%TYPE;
628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

628: invoice_num1 JE_ES_MODELO_190_ALL.invoice_num%TYPE;
629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;

Line 633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;

629: inv_doc_seq_num1 JE_ES_MODELO_190_ALL.inv_doc_seq_num%TYPE;
630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
637: wht_mode ap_invoices.payment_status_flag%TYPE;

Line 634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;

630: invoice_date1 JE_ES_MODELO_190_ALL.invoice_date%TYPE;
631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
637: wht_mode ap_invoices.payment_status_flag%TYPE;
638: inv_awt_flag ap_invoices.awt_flag%TYPE;

Line 635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

631: gl_date1 JE_ES_MODELO_190_ALL.gl_date%TYPE;
632: invoice_payment_id1 JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
633: awt_invoice_payment_id JE_ES_MODELO_190_ALL.invoice_payment_id%TYPE;
634: date_paid1 JE_ES_MODELO_190_ALL.date_paid%TYPE;
635: invoice_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
636: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
637: wht_mode ap_invoices.payment_status_flag%TYPE;
638: inv_awt_flag ap_invoices.awt_flag%TYPE;
639: dist_awt_flag ap_invoice_distributions_all.awt_flag%type; -- bug 8709676

Line 640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

636: inv_payment_status_flag ap_invoices.payment_status_flag%TYPE;
637: wht_mode ap_invoices.payment_status_flag%TYPE;
638: inv_awt_flag ap_invoices.awt_flag%TYPE;
639: dist_awt_flag ap_invoice_distributions_all.awt_flag%type; -- bug 8709676
640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

637: wht_mode ap_invoices.payment_status_flag%TYPE;
638: inv_awt_flag ap_invoices.awt_flag%TYPE;
639: dist_awt_flag ap_invoice_distributions_all.awt_flag%type; -- bug 8709676
640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

638: inv_awt_flag ap_invoices.awt_flag%TYPE;
639: dist_awt_flag ap_invoice_distributions_all.awt_flag%type; -- bug 8709676
640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

639: dist_awt_flag ap_invoice_distributions_all.awt_flag%type; -- bug 8709676
640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

Line 644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;

640: paid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

Line 645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

641: invoice_prepaid_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

Line 646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

642: invoice_withheld_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

Line 647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;

643: inv_dist_net_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;

Line 648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

644: discount_amount JE_ES_MODELO_190_ALL.net_amount%TYPE;
645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;

Line 649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;

645: net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;

Line 650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

646: wht_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;

Line 651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;

647: inv_net_amount1 JE_ES_MODELO_190_ALL.net_amount%TYPE;
648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;

Line 652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;

648: withholding_tax_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;

Line 653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;

649: inv_wht_amount1 JE_ES_MODELO_190_ALL.withholding_tax_amount%TYPE;
650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;

Line 654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;

650: zip_electronic1 JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
658: invoice_payments_count number := 0;

Line 655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;

651: zip_legal1 JE_ES_MODELO_190_ALL.zip_legal%TYPE;
652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
658: invoice_payments_count number := 0;
659: func_curr fnd_currencies_vl.currency_code%TYPE;

Line 656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;

652: city_legal1 JE_ES_MODELO_190_ALL.city_legal%TYPE;
653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
658: invoice_payments_count number := 0;
659: func_curr fnd_currencies_vl.currency_code%TYPE;
660: func_curr_precision fnd_currencies_vl.precision%TYPE;

Line 657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;

653: num_children1 JE_ES_MODELO_190_ALL.num_children%TYPE;
654: sign1 JE_ES_MODELO_190_ALL.sign%TYPE;
655: tax_rate1 JE_ES_MODELO_190_ALL.tax_rate%TYPE;
656: tax_name1 JE_ES_MODELO_190_ALL.tax_name%TYPE;
657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
658: invoice_payments_count number := 0;
659: func_curr fnd_currencies_vl.currency_code%TYPE;
660: func_curr_precision fnd_currencies_vl.precision%TYPE;
661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;

Line 661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;

657: year_due1 JE_ES_MODELO_190_ALL.year_due%TYPE;
658: invoice_payments_count number := 0;
659: func_curr fnd_currencies_vl.currency_code%TYPE;
660: func_curr_precision fnd_currencies_vl.precision%TYPE;
661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;

Line 662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;

658: invoice_payments_count number := 0;
659: func_curr fnd_currencies_vl.currency_code%TYPE;
660: func_curr_precision fnd_currencies_vl.precision%TYPE;
661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

Line 663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;

659: func_curr fnd_currencies_vl.currency_code%TYPE;
660: func_curr_precision fnd_currencies_vl.precision%TYPE;
661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;

Line 664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;

660: func_curr_precision fnd_currencies_vl.precision%TYPE;
661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

Line 665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;

661: old_remun_type JE_ES_MODELO_190_ALL.remun_type%TYPE;
662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

Line 666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;

662: old_sub_remun_type JE_ES_MODELO_190_ALL.sub_remun_type%TYPE;
663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
670: l_parent_reversal_flag VARCHAR2(1); -- Bug 9759711

Line 667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;

663: old_vendor_nif JE_ES_MODELO_190_ALL.vendor_nif%TYPE;
664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
670: l_parent_reversal_flag VARCHAR2(1); -- Bug 9759711
671: l_le_id_count NUMBER;

Line 668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

664: old_vendor_name JE_ES_MODELO_190_ALL.vendor_name%TYPE;
665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
670: l_parent_reversal_flag VARCHAR2(1); -- Bug 9759711
671: l_le_id_count NUMBER;
672: l_le_id_message VARCHAR2(500);

Line 669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

665: old_city_legal JE_ES_MODELO_190_ALL.city_legal%TYPE;
666: old_zip_electronic JE_ES_MODELO_190_ALL.zip_electronic%TYPE;
667: old_zip_legal JE_ES_MODELO_190_ALL.zip_legal%TYPE;
668: old_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
669: old_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
670: l_parent_reversal_flag VARCHAR2(1); -- Bug 9759711
671: l_le_id_count NUMBER;
672: l_le_id_message VARCHAR2(500);
673: l_ledger_id number;

Line 2303: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;

2299: p_parent_reversal_flag IN VARCHAR2,
2300: p_awt_invoice_payment_id IN NUMBER DEFAULT 0) is -- Bug 12616975
2301: l_tax_code_id ap_tax_codes.tax_id%TYPE;
2302: l_invoice_num ap_invoices.invoice_num%TYPE;
2303: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
2304: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
2305: l_accounting_date ap_invoice_distributions_all.accounting_date%TYPE;
2306: begin
2307: begin

Line 2304: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;

2300: p_awt_invoice_payment_id IN NUMBER DEFAULT 0) is -- Bug 12616975
2301: l_tax_code_id ap_tax_codes.tax_id%TYPE;
2302: l_invoice_num ap_invoices.invoice_num%TYPE;
2303: l_tax_name JE_ES_MODELO_190_ALL.tax_name%TYPE;
2304: l_tax_rate JE_ES_MODELO_190_ALL.tax_rate%TYPE;
2305: l_accounting_date ap_invoice_distributions_all.accounting_date%TYPE;
2306: begin
2307: begin
2308: if p_fetch_pi_flag = 'P' then

Line 2438: FROM je_es_modelo_190_all

2434:
2435: -- Added for bug 5277700.
2436: SELECT COUNT(*)
2437: INTO l_le_id_count
2438: FROM je_es_modelo_190_all
2439: WHERE legal_entity_id IS NULL;
2440: IF l_le_id_count > 0 THEN
2441: je_es_mod_le_update.update_main;
2442: /* fnd_message.set_name('JE', 'JE_WHT_LEGAL_ENTITY_ID_UPG');

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

2439: WHERE legal_entity_id IS NULL;
2440: IF l_le_id_count > 0 THEN
2441: je_es_mod_le_update.update_main;
2442: /* fnd_message.set_name('JE', 'JE_WHT_LEGAL_ENTITY_ID_UPG');
2443: fnd_message.set_token('TABLE', 'JE_ES_MODELO_190_ALL');
2444: l_le_id_message := fnd_message.get;
2445: errbuf := l_le_id_message;
2446: retcode := -1;
2447: RETURN;

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

2638: tax_rate => NULL,
2639: tax_name => NULL,
2640: year_due => NULL);
2641: end if;
2642: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2643: CLOSE detail_paid;
2644: plsqlmsg('CURSOR Closed');
2645: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2646: ELSE -- p_pay_inv_sel <> 'P'

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

2695: tax_name => tax_name1,
2696: year_due => year_due1);
2697: end if;
2698: END LOOP;
2699: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2700: CLOSE sum_approve_mag;
2701: plsqlmsg('CURSOR Closed');
2702: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2703: end if; -- p_pay_inv_sel = 'P' or <> 'P'

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

2819: tax_name => tax_name1,
2820: year_due => year_due1);
2821: end if;
2822: END LOOP;
2823: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2824: CLOSE detail_paid;
2825: plsqlmsg('CURSOR Closed');
2826: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2827: else -- p_pay_inv_sel <> 'P'

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

2880: tax_name => tax_name1,
2881: year_due => NULL);
2882: end if;
2883: END LOOP;
2884: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
2885: CLOSE detail_approve;
2886: plsqlmsg('CURSOR Closed');
2887: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
2888: end if; -- p_pay_inv_sel = 'P' or <> 'P'

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

3009: tax_name => tax_name1,
3010: year_due => year_due1);
3011: end if;
3012: END LOOP;
3013: plsqlmsg('Data inserted into table JE_ES_MODELO_190_ALL');
3014: CLOSE detail_paid;
3015: plsqlmsg('CURSOR Closed');
3016: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
3017: else -- p_pay_inv_sel <> 'P'

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

3085: tax_name => tax_name1,
3086: year_due => year_due1);
3087: end if;
3088: END LOOP;
3089: plsqlmsg('Data inserted into table JE_ES_MODELO_190_all');
3090: CLOSE detail_approve;
3091: plsqlmsg('CURSOR Closed');
3092: plsqlmsg('Routine Successfully completed - ' || to_char(countrecs) || ' rows inserted');
3093: RETCODE := 0;