APPS.PA_CC_AR_AP_TRANSFER dependencies on AP_INVOICES_INTERFACE

Line 319: select ap_invoices_interface_s.nextval into v_invoice_id from sys.dual;

315: END LOOP;
316: close c_receiver_project_task;
317: end if;
318:
319: select ap_invoices_interface_s.nextval into v_invoice_id from sys.dual;
320:
321: pa_debug.G_err_stage := 'Check if tax code is null';
322: pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
323: open c_invoice_lines_counter(p_project_id(I),p_draft_invoice_number(I));

Line 504: pa_debug.G_err_stage := 'Insert into AP_invoices_interface table';

500:
501: -- DevDrop2 Changes End
502:
503: if x_status_code is null then
504: pa_debug.G_err_stage := 'Insert into AP_invoices_interface table';
505: pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
506: populate_ap_invoices_interface (
507: p_internal_billing_type(I),
508: v_invoice_id,

Line 506: populate_ap_invoices_interface (

502:
503: if x_status_code is null then
504: pa_debug.G_err_stage := 'Insert into AP_invoices_interface table';
505: pa_debug.write_file( 'LOG', pa_debug.G_err_stage);
506: populate_ap_invoices_interface (
507: p_internal_billing_type(I),
508: v_invoice_id,
509: p_ra_invoice_number(I),
510: p_invoice_date(I),

Line 570: --procedure Populate_ap_invoices_interface

566: end transfer_ar_ap_invoices_01;
567:
568:
569: ----------------------------------------------------
570: --procedure Populate_ap_invoices_interface
571: --transfer invoices to ap_invoices_interface table
572: -------------------------------------------------
573: procedure Populate_ap_invoices_interface(
574: p_internal_billing_type in varchar2,

Line 571: --transfer invoices to ap_invoices_interface table

567:
568:
569: ----------------------------------------------------
570: --procedure Populate_ap_invoices_interface
571: --transfer invoices to ap_invoices_interface table
572: -------------------------------------------------
573: procedure Populate_ap_invoices_interface(
574: p_internal_billing_type in varchar2,
575: p_invoice_id in number,

Line 573: procedure Populate_ap_invoices_interface(

569: ----------------------------------------------------
570: --procedure Populate_ap_invoices_interface
571: --transfer invoices to ap_invoices_interface table
572: -------------------------------------------------
573: procedure Populate_ap_invoices_interface(
574: p_internal_billing_type in varchar2,
575: p_invoice_id in number,
576: p_invoice_number in varchar2,
577: p_invoice_date in date,

Line 588: pa_debug.set_err_stack('populate_ap_invoices_interface');

584: p_workflow_flag in varchar2,
585: p_org_id in number)
586: IS
587: begin
588: pa_debug.set_err_stack('populate_ap_invoices_interface');
589: Insert into ap_invoices_interface (
590: invoice_id,
591: invoice_num,
592: invoice_date,

Line 589: Insert into ap_invoices_interface (

585: p_org_id in number)
586: IS
587: begin
588: pa_debug.set_err_stack('populate_ap_invoices_interface');
589: Insert into ap_invoices_interface (
590: invoice_id,
591: invoice_num,
592: invoice_date,
593: vendor_id,

Line 634: End populate_ap_invoices_interface;

630: when others then
631: pa_debug.G_err_code :=SQLCODE;
632: pa_debug.G_err_stage:= pa_debug.G_err_stage||':'||sqlerrm;
633: Raise;
634: End populate_ap_invoices_interface;
635:
636:
637: ----------------------------------------------------------------------------------
638: ---procedure Populate_ap_inv_line_interface