[Home] [Help]
511: p_style_id IN NUMBER DEFAULT NULL
512: --
513: ) IS
514:
515: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
516:
517: begin
518: l_asl_id := NULL;
519: autosource(x_mode => x_mode,
1057: x_owning_org_id NUMBER; -- FPI GA
1058: x_valid_flag VARCHAR2(1) := 'N';
1059: --
1060: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
1061: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE;
1062: l_vendor_site_sourcing_flag VARCHAR2(1) := p_vendor_site_sourcing_flag;
1063: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'document_sourcing';
1064: --
1065:
1465: x_sourcing_date DATE := trunc(nvl(x_autosource_date, sysdate));
1466: x_auto_source_doc VARCHAR2(1);
1467: x_asl_purchasing_uom VARCHAR2(25);
1468: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
1469: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE; --
1471: x_enable_vmi_flag VARCHAR2(1);
1472: x_return_status VARCHAR2(1); --
1473: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
1522: poh.global_agreement_flag,
1523: poh.org_id,
1524: -- Bug 3361128: also select the UOM on the doc
1525: pol.unit_meas_lookup_code
1526: FROM po_asl_documents pad,
1527: po_approved_supplier_list pasl,
1528: po_headers_all poh, --CTO changes FPH
1529: po_lines_all pol --CTO changes FPH
1530: WHERE pasl.asl_id = x_local_asl_id
1710: x_vendor_product_num,
1711: poh.global_agreement_flag,
1712: poh.org_id,
1713: NULL unit_meas_lookup_code
1714: FROM po_asl_documents pad,
1715: po_approved_supplier_list pasl,
1716: po_headers_all poh --CTO changes FPH
1717: WHERE pasl.asl_id = x_local_asl_id
1718: AND pad.asl_id = pasl.asl_id
2894: --values returned by the procedure. We are interested only in asl_id and do not want the
2895: --source document related info.
2896: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2897: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2898: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2899: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2900: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2901: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2902: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
3609: )
3610: IS
3611: l_progress VARCHAR2(3) := '000';
3612: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'asl_sourcing';
3613: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
3614:
3615: BEGIN
3616:
3617: l_progress := '010';
3781: )
3782: IS
3783: l_progress VARCHAR2(3) := '000';
3784: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'item_based_asl_sourcing';
3785: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
3786:
3787: --This cursor is used to look for ITEM ASLs in current OU
3788: --Note: If you make any change in this cursor then consider whether you
3789: -- need to make change to cursor L_CATEGORY_ASL_IN_CUR_OU_CSR as well
3839: pad.sequence_num
3840: FROM po_approved_supplier_lis_val_v pasl,
3841: po_asl_attributes paa,
3842: po_asl_status_rules_v pasr,
3843: po_asl_documents pad,
3844: po_headers_all poh,
3845: po_lines_all pol
3846: WHERE pasl.item_id = p_item_id --
3847: AND pasl.vendor_id = p_vendor_id
4154: )
4155: IS
4156: l_progress VARCHAR2(3) := '000';
4157: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'category_based_asl_sourcing';
4158: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
4159:
4160: --This cursor is used to look for CATEGORY based ASLs in current OU
4161: --Note: If you make any change in this cursor then consider whether you
4162: -- need to make change to cursor L_ITEM_ASL_IN_CUR_OU_CSR as well
4212: pad.sequence_num
4213: FROM po_approved_supplier_lis_val_v pasl,
4214: po_asl_attributes paa,
4215: po_asl_status_rules_v pasr,
4216: po_asl_documents pad,
4217: po_headers_all poh,
4218: po_lines_all pol
4219: WHERE pasl.category_id = p_category_id --
4220: AND pasl.vendor_id = p_vendor_id
4763:
4764: l_negotiated_by_preparer_flag PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG%TYPE; -- PO DBI FPJ
4765:
4766: --
4767: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4768: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4769: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4770: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4771: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
5554: -- Added a variable for making local copy of x_asl_id It is required because now x_asl_id
5555: -- would be a IN OUT parameter in document_sourcing procedure, which return a value.
5556: -- In order to maintain the existing flow we make a local copy and pass it to the document_sourcing.
5557:
5558: l_local_asl_id PO_ASL_DOCUMENTS.asl_id%type;
5559: --
5560: begin
5561: x_msg_data :='No error';
5562: x_msg_count := 0;
5891: pad.document_type_code,
5892: nvl(pol.allow_price_override_flag,'N'),
5893: pol.not_to_exceed_price,
5894: pol.unit_meas_lookup_code
5895: FROM po_asl_documents pad,
5896: po_headers_all poh,
5897: po_lines_all pol
5898: WHERE pad.asl_id = l_asl_id
5899: AND pad.document_header_id = poh.po_header_id