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.PO_INTERFACE_S dependencies on PO_DISTRIBUTIONS_INTERFACE

Line 314: po_distributions_interface pdi

310: , pli.catalog_name catalog_name
311: --
312: FROM po_headers_interface phi,
313: po_lines_interface pli,
314: po_distributions_interface pdi
315: WHERE phi.interface_header_id = pli.interface_header_id
316: AND pli.interface_line_id = pdi.interface_line_id
317: AND phi.interface_header_id = x_interface_header_id
318: AND pdi.interface_distribution_id =

Line 320: FROM po_distributions_interface pdi2

316: AND pli.interface_line_id = pdi.interface_line_id
317: AND phi.interface_header_id = x_interface_header_id
318: AND pdi.interface_distribution_id =
319: (SELECT min(pdi2.interface_distribution_id)
320: FROM po_distributions_interface pdi2
321: WHERE pdi2.interface_line_id = pli.interface_line_id)
322: ORDER BY pli.line_num,
323: --
324: nvl(pli.shipment_num,0),

Line 6816: --SQL WHAT: Update po_distributions_interface table with

6812:
6813:
6814: l_progress := '150';
6815: --
6816: --SQL WHAT: Update po_distributions_interface table with
6817: -- po_distribution_id's and distribution_num
6818:
6819: UPDATE po_distributions_interface
6820: SET po_distribution_id = po_distributions_s.NEXTVAL,

Line 6819: UPDATE po_distributions_interface

6815: --
6816: --SQL WHAT: Update po_distributions_interface table with
6817: -- po_distribution_id's and distribution_num
6818:
6819: UPDATE po_distributions_interface
6820: SET po_distribution_id = po_distributions_s.NEXTVAL,
6821: distribution_num = x_distribution_num + rownum
6822: WHERE interface_header_id = interface.interface_header_id
6823: AND interface_line_id = interface.interface_line_id;

Line 6852: FROM po_distributions_interface pdi, po_line_locations_all poll

6848:
6849: BEGIN
6850: SELECT pdi.amount_ordered
6851: INTO l_amount_ordered
6852: FROM po_distributions_interface pdi, po_line_locations_all poll
6853: WHERE pdi.interface_header_id = interface.interface_header_id
6854: AND pdi.interface_line_id = interface.interface_line_id
6855: AND poll.line_location_id = x_line_location_id;
6856:

Line 7117: FROM po_distributions_interface pdi, po_line_locations_all poll

7113: g_purchasing_ou_id, --
7114: poll.shipment_type, --
7115: nvl2(g_calculate_tax_flag, 'CREATE', null), --
7116: pdi.interface_distribution_ref --
7117: FROM po_distributions_interface pdi, po_line_locations_all poll
7118: WHERE pdi.interface_header_id = interface.interface_header_id
7119: AND pdi.interface_line_id = interface.interface_line_id
7120: AND poll.line_location_id = x_line_location_id; --
7121:

Line 7844: -- PO_DISTRIBUTIONS_INTERFACE table. The following columns may get

7840: --Pre-reqs:
7841: -- The global variables g_document_type, g_document_subtype and params
7842: -- should have been populated correctly.
7843: --Modifies:
7844: -- PO_DISTRIBUTIONS_INTERFACE table. The following columns may get
7845: -- modified:
7846: -- CODE_COMBINATION_ID
7847: -- ACCRUAL_ACCOUNT_ID
7848: -- VARIANCE_ACCOUNT_ID

Line 7857: -- PO_DISTRIBUTIONS_INTERFACE table with the new account ID's.

7853: -- None.
7854: --Function:
7855: -- Generates the accounts for shared procurement scenarios by calling
7856: -- the PO AG workflow. After that, it updates the affected records in
7857: -- PO_DISTRIBUTIONS_INTERFACE table with the new account ID's.
7858: --Parameters:
7859: --IN:
7860: -- p_interface_header_id -- The interface header ID of the document being
7861: -- processed.

Line 7878: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

7874: l_charge_success BOOLEAN := TRUE;
7875: l_budget_success BOOLEAN := TRUE;
7876: l_accrual_success BOOLEAN := TRUE;
7877: l_variance_success BOOLEAN := TRUE;
7878: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7879: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
7880: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
7881: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7882: l_charge_account_flex VARCHAR2(2000);

Line 7879: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;

7875: l_budget_success BOOLEAN := TRUE;
7876: l_accrual_success BOOLEAN := TRUE;
7877: l_variance_success BOOLEAN := TRUE;
7878: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7879: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
7880: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
7881: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7882: l_charge_account_flex VARCHAR2(2000);
7883: l_budget_account_flex VARCHAR2(2000);

Line 7880: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;

7876: l_accrual_success BOOLEAN := TRUE;
7877: l_variance_success BOOLEAN := TRUE;
7878: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7879: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
7880: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
7881: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7882: l_charge_account_flex VARCHAR2(2000);
7883: l_budget_account_flex VARCHAR2(2000);
7884: l_accrual_account_flex VARCHAR2(2000);

Line 7881: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

7877: l_variance_success BOOLEAN := TRUE;
7878: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7879: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
7880: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
7881: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7882: l_charge_account_flex VARCHAR2(2000);
7883: l_budget_account_flex VARCHAR2(2000);
7884: l_accrual_account_flex VARCHAR2(2000);
7885: l_variance_account_flex VARCHAR2(2000);

Line 7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;

7893:
7894: l_return_status VARCHAR2(1);
7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;

Line 7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

7895: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:

Line 7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

7896: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:
7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;

Line 7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;

7897: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
7898: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
7899: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
7900: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
7901: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
7902: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
7903:
7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;

Line 7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;

7904: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;

Line 7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;

7905: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
7906: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
7907: --l_ship_to_organization_id NUMBER;
7908: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;

Line 7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;

7909: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;

Line 7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;

7910: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;

Line 7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;

7911: l_vendor_id PO_VENDORS.vendor_id%TYPE;
7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;

Line 7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;

7912: l_agent_id PO_HEADERS.agent_id%TYPE;
7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;

Line 7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;

7913: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;

Line 7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;

7914: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;

Line 7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;

7915: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;

Line 7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;

7916: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
7917: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
7918: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
7924: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;

Line 7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;

7919: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
7924: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
7925: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
7926:
7927:

Line 7924: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;

7920: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
7924: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
7925: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
7926:
7927:
7928: --< New start_workflow parameters in FPJ End >

Line 7925: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;

7921: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
7922: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
7923: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
7924: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
7925: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
7926:
7927:
7928: --< New start_workflow parameters in FPJ End >
7929: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;

Line 7932: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;

7928: --< New start_workflow parameters in FPJ End >
7929: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;
7930: l_dest_charge_success BOOLEAN;
7931: l_dest_variance_success BOOLEAN;
7932: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;
7933: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;
7934: l_dest_charge_account_desc VARCHAR2(2000);
7935: l_dest_variance_account_desc VARCHAR2(2000);
7936: l_dest_charge_account_flex VARCHAR2(2000);

Line 7933: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;

7929: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;
7930: l_dest_charge_success BOOLEAN;
7931: l_dest_variance_success BOOLEAN;
7932: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;
7933: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;
7934: l_dest_charge_account_desc VARCHAR2(2000);
7935: l_dest_variance_account_desc VARCHAR2(2000);
7936: l_dest_charge_account_flex VARCHAR2(2000);
7937: l_dest_variance_account_flex VARCHAR2(2000);

Line 7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;

7949: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
7950: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
7951: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
7952: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
7953: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
7954: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
7955: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
7956: -- Bug 3463242 END
7957:

Line 7960: --SQL WHAT: All those lines inserted in the PO distributions interface table

7956: -- Bug 3463242 END
7957:
7958: l_item_in_linv_pou VARCHAR2(1):= 'Y'; -- Bug 3433867
7959:
7960: --SQL WHAT: All those lines inserted in the PO distributions interface table
7961: -- that have the DOU <> POU.
7962: --SQL WHY: To call AG Workflow for line that have a Transaction Flow
7963: -- defined between DOU and POU.
7964: CURSOR l_SPS_lines_csr IS

Line 8007: FROM PO_DISTRIBUTIONS_INTERFACE pdi,

8003: phi.rate_date,
8004: phi.rate,
8005: pdi.rate
8006: -- Bug 3463242 END
8007: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8008: PO_LINES_INTERFACE pli,
8009: PO_HEADERS_INTERFACE phi,
8010: PO_REQUISITION_LINES_ALL prl, --
8011: MTL_PARAMETERS mp,

Line 8354: UPDATE po_distributions_interface

8350:
8351: l_progress := '130';
8352:
8353: -- update the distributions interface table with new account ID's
8354: UPDATE po_distributions_interface
8355: SET charge_account_id = l_charge_account_id,
8356: variance_account_id = l_variance_account_id,
8357: accrual_account_id = l_accrual_account_id,
8358: budget_account_id = NULL,

Line 8649: po_distributions_interface pdi

8645: phi.vendor_site_id,
8646: pdi.destination_organization_id
8647: from po_lines_interface pli,
8648: po_headers_interface phi,
8649: po_distributions_interface pdi
8650: where phi.interface_header_id = x_interface_header_id
8651: and phi.interface_header_id = pli.interface_header_id
8652: and pdi.interface_distribution_id =
8653: (SELECT min(pdi2.interface_distribution_id)

Line 8654: FROM po_distributions_interface pdi2

8650: where phi.interface_header_id = x_interface_header_id
8651: and phi.interface_header_id = pli.interface_header_id
8652: and pdi.interface_distribution_id =
8653: (SELECT min(pdi2.interface_distribution_id)
8654: FROM po_distributions_interface pdi2
8655: WHERE pdi2.interface_line_id = pli.interface_line_id)
8656: and pli.item_id is not null
8657: and phi.vendor_id is not null
8658: and pli.vendor_product_num is null;

Line 9464: INSERT INTO po_distributions_interface

9460: p_token => l_progress,
9461: p_message => 'Before insert into Distribution interface');
9462: END IF;
9463:
9464: INSERT INTO po_distributions_interface
9465: (interface_header_id,
9466: interface_line_id,
9467: interface_distribution_id,
9468: distribution_num,

Line 9522: po_distributions_interface_s.nextval,

9518: oke_contract_deliverable_id
9519: )
9520: SELECT pli.interface_header_id,
9521: pli.interface_line_id,
9522: po_distributions_interface_s.nextval,
9523: prd.distribution_num,
9524: prd.code_combination_id,
9525: prd.set_of_books_id,
9526: prd.req_line_quantity,

Line 9590: FROM po_distributions_interface

9586: AND phi.interface_header_id = x_interface_header_id;
9587:
9588: SELECT count(*)
9589: INTO x_count_dist
9590: FROM po_distributions_interface
9591: WHERE interface_header_id = x_interface_header_id;
9592:
9593: l_progress:='180';
9594: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

Line 9655: -- SQL WHAT: insert minimal data into po_distributions_interface

9651: params.inventory_organization_id);
9652:
9653: END IF; -- IF i.ship_to_organization_id IS NOT NULL
9654:
9655: -- SQL WHAT: insert minimal data into po_distributions_interface
9656: -- SQL WHY: this is required because the global interface cursor
9657: -- joins to the distributions interface table and uses
9658: -- some of the following fields for defaulting purposes
9659:

Line 9660: INSERT INTO po_distributions_interface(

9656: -- SQL WHY: this is required because the global interface cursor
9657: -- joins to the distributions interface table and uses
9658: -- some of the following fields for defaulting purposes
9659:
9660: INSERT INTO po_distributions_interface(
9661: interface_header_id
9662: , interface_line_id
9663: , interface_distribution_id
9664: , destination_type_code

Line 9670: , PO_DISTRIBUTIONS_INTERFACE_S.nextval

9666: , destination_organization_id
9667: ) VALUES (
9668: i.interface_header_id
9669: , i.interface_line_id
9670: , PO_DISTRIBUTIONS_INTERFACE_S.nextval
9671: , 'EXPENSE'
9672: , i.ship_to_location_id
9673: , l_ship_to_org_id
9674: );

Line 9825: DELETE po_distributions_interface

9821: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
9822: PO_DEBUG.debug_begin(p_log_head => g_log_head||'wrapup');
9823: END IF;
9824:
9825: DELETE po_distributions_interface
9826: WHERE interface_header_id = x_interface_header_id;
9827:
9828: --
9829: DELETE po_price_diff_interface

Line 9982: po_distributions_interface pld

9978: pli.consigned_flag, -- CONSIGNED FPI
9979: pli.contract_id, --
9980: pli.supplier_ref_number --
9981: FROM po_lines_interface pli,
9982: po_distributions_interface pld
9983: WHERE pli.interface_header_id=x_interface_header_id
9984: AND pli.interface_line_id=pld.interface_line_id
9985: AND pld.interface_distribution_id =
9986: ( SELECT min(pdi2.interface_distribution_id)

Line 9987: FROM po_distributions_interface pdi2

9983: WHERE pli.interface_header_id=x_interface_header_id
9984: AND pli.interface_line_id=pld.interface_line_id
9985: AND pld.interface_distribution_id =
9986: ( SELECT min(pdi2.interface_distribution_id)
9987: FROM po_distributions_interface pdi2
9988: WHERE pdi2.interface_line_id = pli.interface_line_id)
9989: ORDER BY pli.item_id,
9990: pli.item_description,
9991: pli.unit_price,

Line 13672: -- PO_DISTRIBUTIONS_INTERFACE

13668: --Name: update_award_distributions
13669: --Pre-reqs:
13670: -- None
13671: --Modifies:
13672: -- PO_DISTRIBUTIONS_INTERFACE
13673: -- GMS_AWARD_DISTRIBUTIONS
13674: --Locks:
13675: -- None
13676: --Function:

Line 13744: -- po_distributions_interface table

13740: ELSE
13741:
13742: --SQL WHAT: For distributions with award_id references, select
13743: -- the columns that Grants needs from the
13744: -- po_distributions_interface table
13745: --SQL WHY : Need to call GMS API to update award distribution
13746: -- lines table.
13747:
13748: SELECT po_distribution_id,

Line 13761: FROM PO_DISTRIBUTIONS_INTERFACE

13757: l_gms_po_interface_obj.project_id,
13758: l_gms_po_interface_obj.task_id,
13759: l_gms_po_interface_obj.award_set_id_in,
13760: l_gms_po_interface_obj.award_set_id_out
13761: FROM PO_DISTRIBUTIONS_INTERFACE
13762: WHERE interface_header_id = interface.interface_header_id
13763: AND interface_line_id = interface.interface_line_id
13764: AND award_id IS NOT NULL;
13765:

Line 13808: --SQL WHAT: Update po_distributions_interface table with the new

13804: l_gms_po_interface_obj.distribution_id(i);
13805:
13806: ELSE
13807:
13808: --SQL WHAT: Update po_distributions_interface table with the new
13809: -- award_id's
13810: --SQL WHY : award_id's in PO tables need to be synchronized with
13811: -- award_id's in GMS tables.
13812:

Line 13814: UPDATE po_distributions_interface

13810: --SQL WHY : award_id's in PO tables need to be synchronized with
13811: -- award_id's in GMS tables.
13812:
13813: FORALL i IN 1..l_gms_po_interface_obj.distribution_id.COUNT
13814: UPDATE po_distributions_interface
13815: SET award_id = l_gms_po_interface_obj.award_set_id_out(i)
13816: WHERE po_distribution_id = l_gms_po_interface_obj.distribution_id(i);
13817:
13818: END IF; -- if p_table_type = 'ALL'