DBA Data[Home] [Help]

APPS.PO_AUTO_HEADER_PROCESS_PVT dependencies on PO_VENDORS

Line 667: * Get the vendor details (po_vendors_sv.get_vendor_info

663:
664: /* ============================================================================
665: NAME: derive_and_default_headers
666: DESC: Perform derive logic on header records from Interface table.
667: * Get the vendor details (po_vendors_sv.get_vendor_info
668: * Get the vendor site info (po_vendor_sites_sv.get_vendor_site_info)
669: (These values needs to be transferred to validation logic)
670: * Derive Pay On Code
671: * Derive Rate (get_rate_for_req_price)

Line 794: po_vendors_sv.get_vendor_info(x_headers.vendor_id,

790: x_headers.fob := NULL;
791: x_headers.freight_term := NULL;
792: x_headers.terms_id := NULL;
793:
794: po_vendors_sv.get_vendor_info(x_headers.vendor_id,
795: g_vendor_ship_to_loc_id,
796: g_vendor_bill_to_loc_id,
797: g_ship_via_lookup_code,
798: g_fob, g_freight_term,

Line 1131: po_vendors_sv.val_freight_carrier(g_vs_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);

1127: **
1128: ========================================================================== */
1129: -- Validate ship via
1130: IF g_vs_ship_via_lookup_code IS NOT NULL THEN
1131: po_vendors_sv.val_freight_carrier(g_vs_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);
1132: END IF;
1133: IF x_headers.ship_via_lookup_code IS NULL THEN
1134: po_vendors_sv.val_freight_carrier(g_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);
1135: END IF;

Line 1134: po_vendors_sv.val_freight_carrier(g_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);

1130: IF g_vs_ship_via_lookup_code IS NOT NULL THEN
1131: po_vendors_sv.val_freight_carrier(g_vs_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);
1132: END IF;
1133: IF x_headers.ship_via_lookup_code IS NULL THEN
1134: po_vendors_sv.val_freight_carrier(g_ship_via_lookup_code, PO_AUTOCREATE_PARAMS.g_sys.def_inv_org_id, x_headers.ship_via_lookup_code);
1135: END IF;
1136:
1137: l_progress := '040';
1138: -- Validate fob code

Line 1140: po_vendors_sv.val_fob(g_vs_fob,x_headers.fob);

1136:
1137: l_progress := '040';
1138: -- Validate fob code
1139: IF g_vs_fob IS NOT NULL THEN
1140: po_vendors_sv.val_fob(g_vs_fob,x_headers.fob);
1141: END IF;
1142: IF x_headers.fob IS NULL THEN
1143: po_vendors_sv.val_fob(g_fob,x_headers.fob);
1144: END IF;

Line 1143: po_vendors_sv.val_fob(g_fob,x_headers.fob);

1139: IF g_vs_fob IS NOT NULL THEN
1140: po_vendors_sv.val_fob(g_vs_fob,x_headers.fob);
1141: END IF;
1142: IF x_headers.fob IS NULL THEN
1143: po_vendors_sv.val_fob(g_fob,x_headers.fob);
1144: END IF;
1145:
1146: l_progress := '050';
1147: -- Validate freight terms

Line 1149: po_vendors_sv.val_freight_terms(g_vs_freight_term, x_headers.freight_term);

1145:
1146: l_progress := '050';
1147: -- Validate freight terms
1148: IF g_vs_freight_term IS NOT NULL THEN
1149: po_vendors_sv.val_freight_terms(g_vs_freight_term, x_headers.freight_term);
1150: END IF;
1151: IF x_headers.freight_term IS NULL THEN
1152: po_vendors_sv.val_freight_terms(g_freight_term, x_headers.freight_term);
1153: END IF;

Line 1152: po_vendors_sv.val_freight_terms(g_freight_term, x_headers.freight_term);

1148: IF g_vs_freight_term IS NOT NULL THEN
1149: po_vendors_sv.val_freight_terms(g_vs_freight_term, x_headers.freight_term);
1150: END IF;
1151: IF x_headers.freight_term IS NULL THEN
1152: po_vendors_sv.val_freight_terms(g_freight_term, x_headers.freight_term);
1153: END IF;
1154:
1155: -- Validate payment terms
1156: IF g_vs_terms_id IS NOT NULL THEN

Line 2035: FROM po_vendors

2031: IF (X_vendor_id IS NOT NULL) THEN
2032: l_progress := '020';
2033: SELECT match_option
2034: INTO x_invoice_match_option
2035: FROM po_vendors
2036: WHERE vendor_id = X_vendor_id;
2037: END IF;
2038: END IF;
2039: