APPS.PA_CC_AR_AP_TRANSFER dependencies on AP_INVOICES_INTERFACE

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

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

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

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

Line 510: populate_ap_invoices_interface (

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

Line 574: --procedure Populate_ap_invoices_interface

570: end transfer_ar_ap_invoices_01;
571:
572:
573: ----------------------------------------------------
574: --procedure Populate_ap_invoices_interface
575: --transfer invoices to ap_invoices_interface table
576: -------------------------------------------------
577: procedure Populate_ap_invoices_interface(
578: p_internal_billing_type in varchar2,

Line 575: --transfer invoices to ap_invoices_interface table

571:
572:
573: ----------------------------------------------------
574: --procedure Populate_ap_invoices_interface
575: --transfer invoices to ap_invoices_interface table
576: -------------------------------------------------
577: procedure Populate_ap_invoices_interface(
578: p_internal_billing_type in varchar2,
579: p_invoice_id in number,

Line 577: procedure Populate_ap_invoices_interface(

573: ----------------------------------------------------
574: --procedure Populate_ap_invoices_interface
575: --transfer invoices to ap_invoices_interface table
576: -------------------------------------------------
577: procedure Populate_ap_invoices_interface(
578: p_internal_billing_type in varchar2,
579: p_invoice_id in number,
580: p_invoice_number in varchar2,
581: p_invoice_date in date,

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

588: p_workflow_flag in varchar2,
589: p_org_id in number)
590: IS
591: begin
592: pa_debug.set_err_stack('populate_ap_invoices_interface');
593: Insert into ap_invoices_interface (
594: invoice_id,
595: invoice_num,
596: invoice_date,

Line 593: Insert into ap_invoices_interface (

589: p_org_id in number)
590: IS
591: begin
592: pa_debug.set_err_stack('populate_ap_invoices_interface');
593: Insert into ap_invoices_interface (
594: invoice_id,
595: invoice_num,
596: invoice_date,
597: vendor_id,

Line 638: End populate_ap_invoices_interface;

634: when others then
635: pa_debug.G_err_code :=SQLCODE;
636: pa_debug.G_err_stage:= pa_debug.G_err_stage||':'||sqlerrm;
637: Raise;
638: End populate_ap_invoices_interface;
639:
640:
641: ----------------------------------------------------------------------------------
642: ---procedure Populate_ap_inv_line_interface