DBA Data[Home] [Help]

APPS.PO_VALIDATIONS dependencies on PO_VAL_HEADERS2

Line 1967: PO_VAL_HEADERS2.po_header_id(p_id_tbl => p_headers.interface_id,

1963: -------------------------------------------------------------------------
1964: WHEN c_po_header_id THEN
1965: -- validate that the PO Header Id is not null and
1966: -- does not already exist in the Transaction table (for create case).
1967: PO_VAL_HEADERS2.po_header_id(p_id_tbl => p_headers.interface_id,
1968: p_po_header_id_tbl => p_headers.po_header_id,
1969: x_result_set_id => l_result_set_id,
1970: x_result_type => l_result_type);
1971: WHEN c_end_date THEN

Line 1987: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,

1983: x_result_type => l_result_type);
1984:
1985: WHEN c_type_lookup_code THEN
1986: -- validate type_lookup_code not null and equal to BLANKET, STANDARD or QUOTATION.
1987: PO_VAL_HEADERS2.type_lookup_code(p_id_tbl => p_headers.interface_id,
1988: p_type_lookup_code_tbl => p_headers.type_lookup_code,
1989: x_results => x_results,
1990: x_result_type => l_result_type);
1991: WHEN c_document_num THEN

Line 1993: PO_VAL_HEADERS2.document_num(p_id_tbl => p_headers.interface_id,

1989: x_results => x_results,
1990: x_result_type => l_result_type);
1991: WHEN c_document_num THEN
1992: -- document_num must not be null, must be unique, greater than or equal to zero and be of the correct type.
1993: PO_VAL_HEADERS2.document_num(p_id_tbl => p_headers.interface_id,
1994: p_po_header_id_tbl => p_headers.po_header_id,
1995: p_document_num_tbl => p_headers.document_num,
1996: p_type_lookup_code_tbl => p_headers.type_lookup_code,
1997: p_manual_po_num_type => l_manual_po_num_type,

Line 2005: PO_VAL_HEADERS2.acceptance_required_flag

2001: x_result_type => l_result_type);
2002:
2003: WHEN c_acceptance_required_flag THEN
2004: -- bug4911383
2005: PO_VAL_HEADERS2.acceptance_required_flag
2006: ( p_id_tbl => p_headers.interface_id,
2007: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2008: p_acceptance_required_flag_tbl => p_headers.acceptance_required_flag,
2009: x_results => x_results,

Line 2027: PO_VAL_HEADERS2.currency_code(p_id_tbl => p_headers.interface_id,

2023: x_results => x_results,
2024: x_result_type => l_result_type);
2025: WHEN c_currency_code THEN
2026: -- validate currency_code is not null and valid in FND_CURRENCIES.
2027: PO_VAL_HEADERS2.currency_code(p_id_tbl => p_headers.interface_id,
2028: p_currency_code_tbl => p_headers.currency_code,
2029: x_result_set_id => l_result_set_id,
2030: x_result_type => l_result_type);
2031: WHEN c_rate_info THEN

Line 2033: PO_VAL_HEADERS2.rate_info(p_id_tbl => p_headers.interface_id,

2029: x_result_set_id => l_result_set_id,
2030: x_result_type => l_result_type);
2031: WHEN c_rate_info THEN
2032: -- validate rate information
2033: PO_VAL_HEADERS2.rate_info(p_id_tbl => p_headers.interface_id,
2034: p_currency_code_tbl => p_headers.currency_code,
2035: p_rate_type_tbl => p_headers.rate_type,
2036: p_rate_tbl => p_headers.rate,
2037: p_rate_date_tbl => p_headers.rate_date,

Line 2045: PO_VAL_HEADERS2.agent_id(p_id_tbl => p_headers.interface_id,

2041: x_results => x_results,
2042: x_result_type => l_result_type);
2043: WHEN c_agent_id THEN
2044: -- validate agent_id is not null and valid in PO_AGENTS.
2045: PO_VAL_HEADERS2.agent_id(p_id_tbl => p_headers.interface_id,
2046: p_agent_id_tbl => p_headers.agent_id,
2047: x_result_set_id => l_result_set_id,
2048: x_result_type => l_result_type);
2049: WHEN c_vendor_info THEN

Line 2051: PO_VAL_HEADERS2.vendor_info(p_id_tbl => p_headers.interface_id,

2047: x_result_set_id => l_result_set_id,
2048: x_result_type => l_result_type);
2049: WHEN c_vendor_info THEN
2050: -- validate vendor information
2051: PO_VAL_HEADERS2.vendor_info(p_id_tbl => p_headers.interface_id,
2052: p_vendor_id_tbl => p_headers.vendor_id,
2053: p_vendor_site_id_tbl => p_headers.vendor_site_id,
2054: p_vendor_contact_id_tbl => p_headers.vendor_contact_id,
2055: p_federal_instance => l_federal_instance,

Line 2060: PO_VAL_HEADERS2.ship_to_location_id(p_id_tbl => p_headers.interface_id,

2056: x_result_set_id => l_result_set_id,
2057: x_results => x_results,
2058: x_result_type => l_result_type);
2059: WHEN c_ship_to_location_id THEN
2060: PO_VAL_HEADERS2.ship_to_location_id(p_id_tbl => p_headers.interface_id,
2061: p_ship_to_location_id_tbl => p_headers.ship_to_location_id,
2062: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2063: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2064: x_result_set_id => l_result_set_id,

Line 2067: PO_VAL_HEADERS2.bill_to_location_id(p_id_tbl => p_headers.interface_id,

2063: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2064: x_result_set_id => l_result_set_id,
2065: x_result_type => l_result_type);
2066: WHEN c_bill_to_location_id THEN
2067: PO_VAL_HEADERS2.bill_to_location_id(p_id_tbl => p_headers.interface_id,
2068: p_bill_to_location_id_tbl => p_headers.bill_to_location_id,
2069: -- Bug 7007502: Added new param p_type_lookup_code_tbl
2070: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2071: x_result_set_id => l_result_set_id,

Line 2074: PO_VAL_HEADERS2.style_id(p_id_tbl => p_headers.interface_id,

2070: p_type_lookup_code_tbl => p_headers.type_lookup_code,
2071: x_result_set_id => l_result_set_id,
2072: x_result_type => l_result_type);
2073: WHEN c_style_id THEN
2074: PO_VAL_HEADERS2.style_id(p_id_tbl => p_headers.interface_id,
2075: p_style_id_tbl => p_headers.style_id,
2076: x_result_set_id => l_result_set_id,
2077: x_result_type => l_result_type);
2078: WHEN c_last_update_date THEN

Line 2191: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,

2187: p_validation_id => PO_VAL_CONSTANTS.c_terms_id_header,
2188: x_result_set_id => l_result_set_id,
2189: x_result_type => l_result_type);
2190: WHEN c_ship_via_lookup_code THEN
2191: PO_VAL_HEADERS2.ship_via_lookup_code(p_id_tbl => p_headers.interface_id,
2192: p_ship_via_lookup_code_tbl => p_headers.ship_via_lookup_code,
2193: p_inventory_org_id => l_inventory_org_id,
2194: x_result_set_id => l_result_set_id,
2195: x_result_type => l_result_type);

Line 2197: PO_VAL_HEADERS2.fob_lookup_code(p_id_tbl => p_headers.interface_id,

2193: p_inventory_org_id => l_inventory_org_id,
2194: x_result_set_id => l_result_set_id,
2195: x_result_type => l_result_type);
2196: WHEN c_fob_lookup_code THEN
2197: PO_VAL_HEADERS2.fob_lookup_code(p_id_tbl => p_headers.interface_id,
2198: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2199: x_result_set_id => l_result_set_id,
2200: x_result_type => l_result_type);
2201: WHEN c_freight_terms_lookup_code THEN

Line 2202: PO_VAL_HEADERS2.freight_terms_lookup_code(p_id_tbl => p_headers.interface_id,

2198: p_fob_lookup_code_tbl => p_headers.fob_lookup_code,
2199: x_result_set_id => l_result_set_id,
2200: x_result_type => l_result_type);
2201: WHEN c_freight_terms_lookup_code THEN
2202: PO_VAL_HEADERS2.freight_terms_lookup_code(p_id_tbl => p_headers.interface_id,
2203: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2204: x_result_set_id => l_result_set_id,
2205: x_result_type => l_result_type);
2206: WHEN c_shipping_control THEN

Line 2207: PO_VAL_HEADERS2.shipping_control(p_id_tbl => p_headers.interface_id,

2203: p_freight_terms_lookup_tbl => p_headers.freight_terms_lookup_code,
2204: x_result_set_id => l_result_set_id,
2205: x_result_type => l_result_type);
2206: WHEN c_shipping_control THEN
2207: PO_VAL_HEADERS2.shipping_control(p_id_tbl => p_headers.interface_id,
2208: p_shipping_control_tbl => p_headers.shipping_control,
2209: x_result_set_id => l_result_set_id,
2210: x_result_type => l_result_type);
2211: WHEN c_confirming_order_flag THEN

Line 2226: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,

2222: p_validation_id => PO_VAL_CONSTANTS.c_confirming_order_flag,
2223: x_results => x_results,
2224: x_result_type => l_result_type);
2225: WHEN c_acceptance_due_date THEN
2226: PO_VAL_HEADERS2.acceptance_due_date(p_id_tbl => p_headers.interface_id,
2227: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2228: p_acceptance_due_date_tbl => p_headers.acceptance_due_date,
2229: x_results => x_results,
2230: x_result_type => l_result_type);

Line 2248: PO_VAL_HEADERS2.amount_limit

2244: x_results => x_results,
2245: x_result_type => l_result_type);
2246: WHEN c_amount_limit THEN
2247: -- bug 5352625
2248: PO_VAL_HEADERS2.amount_limit
2249: ( p_id_tbl => p_headers.interface_id,
2250: p_amount_limit_tbl => p_headers.amount_limit,
2251: p_amount_agreed_tbl => p_headers.amount_agreed,
2252: x_results => x_results,

Line 2271: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,

2267: p_validation_id => PO_VAL_CONSTANTS.c_firm_status_lookup_header,
2268: x_results => x_results,
2269: x_result_type => l_result_type);
2270: WHEN c_cancel_flag THEN
2271: PO_VAL_HEADERS2.cancel_flag(p_id_tbl => p_headers.interface_id,
2272: p_cancel_flag_tbl => p_headers.cancel_flag,
2273: x_results => x_results,
2274: x_result_type => l_result_type);
2275: WHEN c_closed_code THEN

Line 2276: PO_VAL_HEADERS2.closed_code(p_id_tbl => p_headers.interface_id,

2272: p_cancel_flag_tbl => p_headers.cancel_flag,
2273: x_results => x_results,
2274: x_result_type => l_result_type);
2275: WHEN c_closed_code THEN
2276: PO_VAL_HEADERS2.closed_code(p_id_tbl => p_headers.interface_id,
2277: p_closed_code_tbl => p_headers.closed_code,
2278: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2279: x_results => x_results,
2280: x_result_type => l_result_type);

Line 2282: PO_VAL_HEADERS2.print_count(p_id_tbl => p_headers.interface_id,

2278: p_acceptance_reqd_flag_tbl => p_headers.acceptance_required_flag,
2279: x_results => x_results,
2280: x_result_type => l_result_type);
2281: WHEN c_print_count THEN
2282: PO_VAL_HEADERS2.print_count(p_id_tbl => p_headers.interface_id,
2283: p_print_count_tbl => p_headers.print_count,
2284: p_approval_status_tbl => p_headers.approval_status,
2285: x_results => x_results,
2286: x_result_type => l_result_type);

Line 2302: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,

2298: p_validation_id => PO_VAL_CONSTANTS.c_frozen_flag,
2299: x_results => x_results,
2300: x_result_type => l_result_type);
2301: WHEN c_approval_status THEN
2302: PO_VAL_HEADERS2.approval_status(p_id_tbl => p_headers.interface_id,
2303: p_approval_status_tbl => p_headers.approval_status,
2304: x_results => x_results,
2305: x_result_type => l_result_type);
2306: WHEN c_amount_to_encumber THEN

Line 2307: PO_VAL_HEADERS2.amount_to_encumber(p_id_tbl => p_headers.interface_id,

2303: p_approval_status_tbl => p_headers.approval_status,
2304: x_results => x_results,
2305: x_result_type => l_result_type);
2306: WHEN c_amount_to_encumber THEN
2307: PO_VAL_HEADERS2.amount_to_encumber(p_id_tbl => p_headers.interface_id,
2308: p_amount_to_encumber_tbl => p_headers.amount_to_encumber,
2309: x_results => x_results,
2310: x_result_type => l_result_type);
2311: WHEN c_quote_warning_delay THEN