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 315: po_distributions_interface pdi

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

Line 321: FROM po_distributions_interface pdi2

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

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

7390:
7391:
7392: l_progress := '150';
7393: --
7394: --SQL WHAT: Update po_distributions_interface table with
7395: -- po_distribution_id's and distribution_num
7396:
7397: UPDATE po_distributions_interface
7398: SET po_distribution_id = po_distributions_s.NEXTVAL,

Line 7397: UPDATE po_distributions_interface

7393: --
7394: --SQL WHAT: Update po_distributions_interface table with
7395: -- po_distribution_id's and distribution_num
7396:
7397: UPDATE po_distributions_interface
7398: SET po_distribution_id = po_distributions_s.NEXTVAL,
7399: distribution_num = x_distribution_num + rownum
7400: WHERE interface_header_id = interface.interface_header_id
7401: AND interface_line_id = interface.interface_line_id;

Line 7430: FROM po_distributions_interface pdi, po_line_locations_all poll

7426:
7427: BEGIN
7428: SELECT pdi.amount_ordered
7429: INTO l_amount_ordered
7430: FROM po_distributions_interface pdi, po_line_locations_all poll
7431: WHERE pdi.interface_header_id = interface.interface_header_id
7432: AND pdi.interface_line_id = interface.interface_line_id
7433: AND poll.line_location_id = x_line_location_id;
7434:

Line 7702: FROM po_distributions_interface pdi,

7698: g_purchasing_ou_id, --
7699: poll.shipment_type, --
7700: nvl2(g_calculate_tax_flag, 'CREATE', null), --
7701: pdi.interface_distribution_ref --
7702: FROM po_distributions_interface pdi,
7703: po_line_locations_all poll,
7704: po_req_distributions_all prd
7705: --bug 16302602,join table po_req_distributions_all to get REQ_LINE_CURRENCY_AMOUNT
7706: WHERE pdi.interface_header_id = interface.interface_header_id

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

8447: --Pre-reqs:
8448: -- The global variables g_document_type, g_document_subtype and params
8449: -- should have been populated correctly.
8450: --Modifies:
8451: -- PO_DISTRIBUTIONS_INTERFACE table. The following columns may get
8452: -- modified:
8453: -- CODE_COMBINATION_ID
8454: -- ACCRUAL_ACCOUNT_ID
8455: -- VARIANCE_ACCOUNT_ID

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

8460: -- None.
8461: --Function:
8462: -- Generates the accounts for shared procurement scenarios by calling
8463: -- the PO AG workflow. After that, it updates the affected records in
8464: -- PO_DISTRIBUTIONS_INTERFACE table with the new account ID's.
8465: --Parameters:
8466: --IN:
8467: -- p_interface_header_id -- The interface header ID of the document being
8468: -- processed.

Line 8485: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

8481: l_charge_success BOOLEAN := TRUE;
8482: l_budget_success BOOLEAN := TRUE;
8483: l_accrual_success BOOLEAN := TRUE;
8484: l_variance_success BOOLEAN := TRUE;
8485: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8486: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
8487: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
8488: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8489: l_charge_account_flex VARCHAR2(2000);

Line 8486: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;

8482: l_budget_success BOOLEAN := TRUE;
8483: l_accrual_success BOOLEAN := TRUE;
8484: l_variance_success BOOLEAN := TRUE;
8485: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8486: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
8487: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
8488: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8489: l_charge_account_flex VARCHAR2(2000);
8490: l_budget_account_flex VARCHAR2(2000);

Line 8487: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;

8483: l_accrual_success BOOLEAN := TRUE;
8484: l_variance_success BOOLEAN := TRUE;
8485: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8486: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
8487: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
8488: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8489: l_charge_account_flex VARCHAR2(2000);
8490: l_budget_account_flex VARCHAR2(2000);
8491: l_accrual_account_flex VARCHAR2(2000);

Line 8488: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

8484: l_variance_success BOOLEAN := TRUE;
8485: l_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8486: l_budget_account_id PO_DISTRIBUTIONS_INTERFACE.budget_account_id%TYPE;
8487: l_accrual_account_id PO_DISTRIBUTIONS_INTERFACE.accrual_account_id%TYPE;
8488: l_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8489: l_charge_account_flex VARCHAR2(2000);
8490: l_budget_account_flex VARCHAR2(2000);
8491: l_accrual_account_flex VARCHAR2(2000);
8492: l_variance_account_flex VARCHAR2(2000);

Line 8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;

8500:
8501: l_return_status VARCHAR2(1);
8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;

Line 8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;

8502: l_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE;
8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
8510:

Line 8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;

8503: l_old_interface_line_id PO_LINES_INTERFACE.interface_line_id%TYPE := -1;
8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
8510:
8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;

Line 8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;

8504: l_interface_distribution_id PO_DISTRIBUTIONS_INTERFACE.interface_distribution_id%TYPE;
8505: l_item_category_id PO_LINES_INTERFACE.category_id%TYPE;
8506: l_req_charge_account_id PO_DISTRIBUTIONS_INTERFACE.charge_account_id%TYPE;
8507: l_req_variance_account_id PO_DISTRIBUTIONS_INTERFACE.variance_account_id%TYPE;
8508: l_destination_organization_id PO_DISTRIBUTIONS_INTERFACE.destination_organization_id%TYPE;
8509: l_destination_ou_id PO_HEADERS_ALL.org_id%TYPE;
8510:
8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;

Line 8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;

8511: l_item_id PO_LINES_INTERFACE.item_id%TYPE;
8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
8513: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;

Line 8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;

8512: l_category_id PO_LINES_INTERFACE.category_id%TYPE;
8513: l_destination_type_code PO_DISTRIBUTIONS_ALL.destination_type_code%TYPE;
8514: --l_ship_to_organization_id NUMBER;
8515: l_ship_to_location_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_location_id%TYPE;
8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;

Line 8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;

8516: l_deliver_to_person_id PO_DISTRIBUTIONS_INTERFACE.deliver_to_person_id%TYPE;
8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;

Line 8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;

8517: l_line_type_id PO_LINES_INTERFACE.line_type_id%TYPE;
8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;

Line 8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;

8518: l_vendor_id PO_VENDORS.vendor_id%TYPE;
8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;

Line 8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;

8519: l_agent_id PO_HEADERS.agent_id%TYPE;
8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;

Line 8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;

8520: l_expenditure_organization_id PO_DISTRIBUTIONS_INTERFACE.expenditure_organization_id%TYPE;
8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;

Line 8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;

8521: l_project_id PO_DISTRIBUTIONS_INTERFACE.project_id%TYPE;
8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;

Line 8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;

8522: l_task_id PO_DISTRIBUTIONS_INTERFACE.task_id%TYPE;
8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;

Line 8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;

8523: l_bom_resource_id PO_DISTRIBUTIONS_INTERFACE.bom_resource_id%TYPE;
8524: l_wip_entity_id PO_DISTRIBUTIONS_INTERFACE.wip_entity_id%TYPE;
8525: l_wip_line_id PO_DISTRIBUTIONS_INTERFACE.wip_line_id%TYPE;
8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
8531: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;

Line 8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;

8526: l_wip_repetitive_schedule_id PO_DISTRIBUTIONS_INTERFACE.wip_repetitive_schedule_id%TYPE;
8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
8531: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
8532: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
8533:
8534:

Line 8531: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;

8527: l_gl_encumbered_date PO_DISTRIBUTIONS_INTERFACE.gl_encumbered_date%TYPE;
8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
8531: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
8532: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
8533:
8534:
8535: --< New start_workflow parameters in FPJ End >

Line 8532: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;

8528: l_destination_subinventory PO_DISTRIBUTIONS_ALL.destination_subinventory%TYPE;
8529: l_expenditure_type PO_DISTRIBUTIONS_ALL.expenditure_type%TYPE;
8530: l_expenditure_item_date PO_DISTRIBUTIONS_INTERFACE.expenditure_item_date%TYPE;
8531: l_wip_operation_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_operation_seq_num%TYPE;
8532: l_wip_resource_seq_num PO_DISTRIBUTIONS_INTERFACE.wip_resource_seq_num%TYPE;
8533:
8534:
8535: --< New start_workflow parameters in FPJ End >
8536: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;

Line 8539: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;

8535: --< New start_workflow parameters in FPJ End >
8536: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;
8537: l_dest_charge_success BOOLEAN;
8538: l_dest_variance_success BOOLEAN;
8539: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;
8540: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;
8541: l_dest_charge_account_desc VARCHAR2(2000);
8542: l_dest_variance_account_desc VARCHAR2(2000);
8543: l_dest_charge_account_flex VARCHAR2(2000);

Line 8540: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;

8536: l_transaction_flow_header_id PO_LINE_LOCATIONS.transaction_flow_header_id%TYPE;
8537: l_dest_charge_success BOOLEAN;
8538: l_dest_variance_success BOOLEAN;
8539: l_dest_charge_account_id PO_DISTRIBUTIONS_INTERFACE.dest_charge_account_id%TYPE;
8540: l_dest_variance_account_id PO_DISTRIBUTIONS_INTERFACE.dest_variance_account_id%TYPE;
8541: l_dest_charge_account_desc VARCHAR2(2000);
8542: l_dest_variance_account_desc VARCHAR2(2000);
8543: l_dest_charge_account_flex VARCHAR2(2000);
8544: l_dest_variance_account_flex VARCHAR2(2000);

Line 8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;

8556: l_po_currency_code PO_HEADERS_INTERFACE.currency_code%TYPE;
8557: l_req_header_rate_type PO_HEADERS_INTERFACE.rate_type%TYPE;
8558: l_req_header_rate_date PO_HEADERS_INTERFACE.rate_date%TYPE;
8559: l_req_header_rate PO_HEADERS_INTERFACE.rate%TYPE;
8560: l_dist_rate PO_DISTRIBUTIONS_INTERFACE.rate%TYPE;
8561: l_rate_for_req_fields PO_HEADERS_INTERFACE.rate%TYPE;
8562: l_po_func_unit_price PO_LINES_ALL.unit_price%TYPE;
8563: -- Bug 3463242 END
8564:

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

8563: -- Bug 3463242 END
8564:
8565: l_item_in_linv_pou VARCHAR2(1):= 'Y'; -- Bug 3433867
8566:
8567: --SQL WHAT: All those lines inserted in the PO distributions interface table
8568: -- that have the DOU <> POU.
8569: --SQL WHY: To call AG Workflow for line that have a Transaction Flow
8570: -- defined between DOU and POU.
8571: CURSOR l_SPS_lines_csr IS

Line 8614: FROM PO_DISTRIBUTIONS_INTERFACE pdi,

8610: phi.rate_date,
8611: phi.rate,
8612: pdi.rate
8613: -- Bug 3463242 END
8614: FROM PO_DISTRIBUTIONS_INTERFACE pdi,
8615: PO_LINES_INTERFACE pli,
8616: PO_HEADERS_INTERFACE phi,
8617: PO_REQUISITION_LINES_ALL prl, --
8618: MTL_PARAMETERS mp,

Line 8961: UPDATE po_distributions_interface

8957:
8958: l_progress := '130';
8959:
8960: -- update the distributions interface table with new account ID's
8961: UPDATE po_distributions_interface
8962: SET charge_account_id = l_charge_account_id,
8963: variance_account_id = l_variance_account_id,
8964: accrual_account_id = l_accrual_account_id,
8965: budget_account_id = NULL,

Line 9267: po_distributions_interface pdi

9263: phi.vendor_site_id,
9264: pdi.destination_organization_id
9265: from po_lines_interface pli,
9266: po_headers_interface phi,
9267: po_distributions_interface pdi
9268: where phi.interface_header_id = x_interface_header_id
9269: and phi.interface_header_id = pli.interface_header_id
9270: and pdi.interface_distribution_id =
9271: (SELECT min(pdi2.interface_distribution_id)

Line 9272: FROM po_distributions_interface pdi2

9268: where phi.interface_header_id = x_interface_header_id
9269: and phi.interface_header_id = pli.interface_header_id
9270: and pdi.interface_distribution_id =
9271: (SELECT min(pdi2.interface_distribution_id)
9272: FROM po_distributions_interface pdi2
9273: WHERE pdi2.interface_line_id = pli.interface_line_id)
9274: and pli.item_id is not null
9275: and phi.vendor_id is not null
9276: and pli.vendor_product_num is null;

Line 10094: INSERT INTO po_distributions_interface

10090: p_token => l_progress,
10091: p_message => 'Before insert into Distribution interface');
10092: END IF;
10093:
10094: INSERT INTO po_distributions_interface
10095: (interface_header_id,
10096: interface_line_id,
10097: interface_distribution_id,
10098: distribution_num,

Line 10152: po_distributions_interface_s.nextval,

10148: oke_contract_deliverable_id
10149: )
10150: SELECT pli.interface_header_id,
10151: pli.interface_line_id,
10152: po_distributions_interface_s.nextval,
10153: prd.distribution_num,
10154: prd.code_combination_id,
10155: prd.set_of_books_id,
10156: prd.req_line_quantity,

Line 10220: FROM po_distributions_interface

10216: AND phi.interface_header_id = x_interface_header_id;
10217:
10218: SELECT count(*)
10219: INTO x_count_dist
10220: FROM po_distributions_interface
10221: WHERE interface_header_id = x_interface_header_id;
10222:
10223: l_progress:='180';
10224: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >

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

10281: params.inventory_organization_id);
10282:
10283: END IF; -- IF i.ship_to_organization_id IS NOT NULL
10284:
10285: -- SQL WHAT: insert minimal data into po_distributions_interface
10286: -- SQL WHY: this is required because the global interface cursor
10287: -- joins to the distributions interface table and uses
10288: -- some of the following fields for defaulting purposes
10289:

Line 10290: INSERT INTO po_distributions_interface(

10286: -- SQL WHY: this is required because the global interface cursor
10287: -- joins to the distributions interface table and uses
10288: -- some of the following fields for defaulting purposes
10289:
10290: INSERT INTO po_distributions_interface(
10291: interface_header_id
10292: , interface_line_id
10293: , interface_distribution_id
10294: , destination_type_code

Line 10300: , PO_DISTRIBUTIONS_INTERFACE_S.nextval

10296: , destination_organization_id
10297: ) VALUES (
10298: i.interface_header_id
10299: , i.interface_line_id
10300: , PO_DISTRIBUTIONS_INTERFACE_S.nextval
10301: , 'EXPENSE'
10302: , i.ship_to_location_id
10303: , l_ship_to_org_id
10304: );

Line 10455: DELETE po_distributions_interface

10451: IF g_debug_stmt THEN --< Bug 3210331: use proper debugging >
10452: PO_DEBUG.debug_begin(p_log_head => g_log_head||'wrapup');
10453: END IF;
10454:
10455: DELETE po_distributions_interface
10456: WHERE interface_header_id = x_interface_header_id;
10457:
10458: --
10459: DELETE po_price_diff_interface

Line 10613: po_distributions_interface pld

10609: pli.consigned_flag, -- CONSIGNED FPI
10610: pli.contract_id, --
10611: pli.supplier_ref_number --
10612: FROM po_lines_interface pli,
10613: po_distributions_interface pld
10614: WHERE pli.interface_header_id=x_interface_header_id
10615: AND pli.interface_line_id=pld.interface_line_id
10616: AND pld.interface_distribution_id =
10617: ( SELECT min(pdi2.interface_distribution_id)

Line 10618: FROM po_distributions_interface pdi2

10614: WHERE pli.interface_header_id=x_interface_header_id
10615: AND pli.interface_line_id=pld.interface_line_id
10616: AND pld.interface_distribution_id =
10617: ( SELECT min(pdi2.interface_distribution_id)
10618: FROM po_distributions_interface pdi2
10619: WHERE pdi2.interface_line_id = pli.interface_line_id)
10620: ORDER BY pli.item_id,
10621: pli.item_description,
10622: pli.unit_price,

Line 14578: -- PO_DISTRIBUTIONS_INTERFACE

14574: --Name: update_award_distributions
14575: --Pre-reqs:
14576: -- None
14577: --Modifies:
14578: -- PO_DISTRIBUTIONS_INTERFACE
14579: -- GMS_AWARD_DISTRIBUTIONS
14580: --Locks:
14581: -- None
14582: --Function:

Line 14650: -- po_distributions_interface table

14646: ELSE
14647:
14648: --SQL WHAT: For distributions with award_id references, select
14649: -- the columns that Grants needs from the
14650: -- po_distributions_interface table
14651: --SQL WHY : Need to call GMS API to update award distribution
14652: -- lines table.
14653:
14654: SELECT po_distribution_id,

Line 14667: FROM PO_DISTRIBUTIONS_INTERFACE

14663: l_gms_po_interface_obj.project_id,
14664: l_gms_po_interface_obj.task_id,
14665: l_gms_po_interface_obj.award_set_id_in,
14666: l_gms_po_interface_obj.award_set_id_out
14667: FROM PO_DISTRIBUTIONS_INTERFACE
14668: WHERE interface_header_id = interface.interface_header_id
14669: AND interface_line_id = interface.interface_line_id
14670: AND award_id IS NOT NULL;
14671:

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

14710: l_gms_po_interface_obj.distribution_id(i);
14711:
14712: ELSE
14713:
14714: --SQL WHAT: Update po_distributions_interface table with the new
14715: -- award_id's
14716: --SQL WHY : award_id's in PO tables need to be synchronized with
14717: -- award_id's in GMS tables.
14718:

Line 14720: UPDATE po_distributions_interface

14716: --SQL WHY : award_id's in PO tables need to be synchronized with
14717: -- award_id's in GMS tables.
14718:
14719: FORALL i IN 1..l_gms_po_interface_obj.distribution_id.COUNT
14720: UPDATE po_distributions_interface
14721: SET award_id = l_gms_po_interface_obj.award_set_id_out(i)
14722: WHERE po_distribution_id = l_gms_po_interface_obj.distribution_id(i);
14723:
14724: END IF; -- if p_table_type = 'ALL'