[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,
1061: x_owning_org_id NUMBER; -- FPI GA
1062: x_valid_flag VARCHAR2(1) := 'N';
1063: --
1064: x_vendor_contact_name PO_VENDOR_CONTACTS.last_name%TYPE;
1065: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE;
1066: l_vendor_site_sourcing_flag VARCHAR2(1) := p_vendor_site_sourcing_flag;
1067: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'document_sourcing';
1068: --
1069:
1469: x_sourcing_date DATE := trunc(nvl(x_autosource_date, sysdate));
1470: x_auto_source_doc VARCHAR2(1);
1471: x_asl_purchasing_uom VARCHAR2(25);
1472: x_source_doc_not_found VARCHAR2(1) := 'N'; -- Bug 2373004
1473: l_sequence_number PO_ASL_DOCUMENTS.sequence_num%TYPE; --
1475: x_enable_vmi_flag VARCHAR2(1);
1476: x_return_status VARCHAR2(1); --
1477: l_global_agreement_flag PO_HEADERS_ALL.global_agreement_flag%type;
1530: poh.global_agreement_flag,
1531: poh.org_id,
1532: -- Bug 3361128: also select the UOM on the doc
1533: pol.unit_meas_lookup_code
1534: FROM po_asl_documents pad,
1535: po_approved_supplier_list pasl,
1536: po_headers_all poh, --CTO changes FPH
1537: po_lines_all pol --CTO changes FPH
1538: WHERE pasl.asl_id = x_local_asl_id
1723: x_vendor_product_num,
1724: poh.global_agreement_flag,
1725: poh.org_id,
1726: NULL unit_meas_lookup_code
1727: FROM po_asl_documents pad,
1728: po_approved_supplier_list pasl,
1729: po_headers_all poh --CTO changes FPH
1730: WHERE pasl.asl_id = x_local_asl_id
1731: AND pad.asl_id = pasl.asl_id
2917: --values returned by the procedure. We are interested only in asl_id and do not want the
2918: --source document related info.
2919: l_dummy_cons_from_sup_flag PO_ASL_ATTRIBUTES.consigned_from_supplier_flag%type := NULL;
2920: l_dummy_enable_vmi_flag PO_ASL_ATTRIBUTES.enable_vmi_flag%type := NULL;
2921: l_dummy_sequence_number PO_ASL_DOCUMENTS.sequence_num%type := NULL;
2922: l_dummy_vendor_product_num PO_REQUISITIONS_INTERFACE_ALL.suggested_vendor_item_num%type := x_vendor_product_num;
2923: l_dummy_asl_purchasing_uom PO_REQUISITIONS_INTERFACE_ALL.unit_of_measure%type := x_purchasing_uom;
2924: l_dummy_category_id PO_REQUISITIONS_INTERFACE_ALL.category_id%type := p_category_id;
2925: l_dummy_using_organization_id FINANCIALS_SYSTEM_PARAMS_ALL.inventory_organization_id%type := p_using_organization_id;
3635: )
3636: IS
3637: l_progress VARCHAR2(3) := '000';
3638: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'asl_sourcing';
3639: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
3640:
3641: BEGIN
3642:
3643: l_progress := '010';
3807: )
3808: IS
3809: l_progress VARCHAR2(3) := '000';
3810: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'item_based_asl_sourcing';
3811: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
3812:
3813: --This cursor is used to look for ITEM ASLs in current OU
3814: --Note: If you make any change in this cursor then consider whether you
3815: -- need to make change to cursor L_CATEGORY_ASL_IN_CUR_OU_CSR as well
3867: pad.sequence_num
3868: FROM po_approved_supplier_lis_val_v pasl,
3869: po_asl_attributes paa,
3870: po_asl_status_rules_v pasr,
3871: po_asl_documents pad,
3872: po_headers_all poh,
3873: po_lines_all pol
3874: WHERE pasl.item_id = p_item_id --
3875: AND pasl.vendor_id = p_vendor_id
4182: )
4183: IS
4184: l_progress VARCHAR2(3) := '000';
4185: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'category_based_asl_sourcing';
4186: l_using_organization_id po_asl_documents.using_organization_id%TYPE;
4187:
4188: --This cursor is used to look for CATEGORY based ASLs in current OU
4189: --Note: If you make any change in this cursor then consider whether you
4190: -- need to make change to cursor L_ITEM_ASL_IN_CUR_OU_CSR as well
4240: pad.sequence_num
4241: FROM po_approved_supplier_lis_val_v pasl,
4242: po_asl_attributes paa,
4243: po_asl_status_rules_v pasr,
4244: po_asl_documents pad,
4245: po_headers_all poh,
4246: po_lines_all pol
4247: WHERE pasl.category_id = p_category_id --
4248: AND pasl.vendor_id = p_vendor_id
4801:
4802: l_negotiated_by_preparer_flag PO_LINES_ALL.NEGOTIATED_BY_PREPARER_FLAG%TYPE; -- PO DBI FPJ
4803:
4804: --
4805: l_asl_id PO_ASL_DOCUMENTS.ASL_ID%type;
4806: l_req_dist_sequence_id PO_REQUISITIONS_INTERFACE.req_dist_sequence_id%type;
4807: l_primary_uom MTL_SYSTEM_ITEMS.primary_unit_of_measure%type;
4808: l_unit_of_issue MTL_SYSTEM_ITEMS.unit_of_issue%type;
4809: l_rounding_factor MTL_SYSTEM_ITEMS.rounding_factor%type;
5631: -- Added a variable for making local copy of x_asl_id It is required because now x_asl_id
5632: -- would be a IN OUT parameter in document_sourcing procedure, which return a value.
5633: -- In order to maintain the existing flow we make a local copy and pass it to the document_sourcing.
5634:
5635: l_local_asl_id PO_ASL_DOCUMENTS.asl_id%type;
5636: --
5637: begin
5638: x_msg_data :='No error';
5639: x_msg_count := 0;
5968: pad.document_type_code,
5969: nvl(pol.allow_price_override_flag,'N'),
5970: pol.not_to_exceed_price,
5971: pol.unit_meas_lookup_code
5972: FROM po_asl_documents pad,
5973: po_headers_all poh,
5974: po_lines_all pol
5975: WHERE pad.asl_id = l_asl_id
5976: AND pad.document_header_id = poh.po_header_id