DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER dependencies on OE_ID_TO_VALUE

Line 1014: x_freight_carrier := OE_ID_TO_VALUE.Freight_Carrier

1010: --kmuruges end
1011: --start 4159701
1012: x_shipping_method_code := l_x_header_rec.shipping_method_code;
1013: x_freight_carrier_code := l_x_header_rec.freight_carrier_code;
1014: x_freight_carrier := OE_ID_TO_VALUE.Freight_Carrier
1015: ( p_freight_carrier_code => l_x_header_rec.freight_carrier_code
1016: , p_ship_from_org_id =>l_x_header_rec.ship_from_org_id
1017: );
1018:

Line 1019: x_shipping_method := OE_ID_TO_VALUE.Ship_Method

1015: ( p_freight_carrier_code => l_x_header_rec.freight_carrier_code
1016: , p_ship_from_org_id =>l_x_header_rec.ship_from_org_id
1017: );
1018:
1019: x_shipping_method := OE_ID_TO_VALUE.Ship_Method
1020: (p_ship_method_code =>l_x_header_rec.shipping_method_code
1021: );
1022: --bug 4348011
1023: x_freight_terms_code := l_x_header_rec.freight_terms_code;

Line 1025: x_freight_terms := OE_ID_TO_VALUE.Freight_Terms

1021: );
1022: --bug 4348011
1023: x_freight_terms_code := l_x_header_rec.freight_terms_code;
1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);
1025: x_freight_terms := OE_ID_TO_VALUE.Freight_Terms
1026: (p_freight_terms_code => l_x_header_rec.freight_terms_code);
1027: x_payment_term_id := l_x_header_rec.payment_term_id;
1028: x_payment_term := OE_ID_TO_VALUE.Payment_Term
1029: (p_payment_term_id => l_x_header_rec.payment_term_id);

Line 1028: x_payment_term := OE_ID_TO_VALUE.Payment_Term

1024: oe_debug_pub.add('ksurendr Freight terms code after PO'||x_freight_terms_code, 1);
1025: x_freight_terms := OE_ID_TO_VALUE.Freight_Terms
1026: (p_freight_terms_code => l_x_header_rec.freight_terms_code);
1027: x_payment_term_id := l_x_header_rec.payment_term_id;
1028: x_payment_term := OE_ID_TO_VALUE.Payment_Term
1029: (p_payment_term_id => l_x_header_rec.payment_term_id);
1030: --bug 4348011
1031: -- Clear header record cache
1032:

Line 2215: /*OE_Id_To_Value.Ship_To_Customer_Name

2211: x_customer_name => x_header_val_rec.ship_To_customer_name,
2212: x_customer_number => x_header_val_rec.ship_To_customer_number
2213: );
2214:
2215: /*OE_Id_To_Value.Ship_To_Customer_Name
2216: (
2217: p_ship_to_org_id => p_header_rec_type.ship_to_org_id,
2218: x_ship_to_customer_name=> x_header_val_rec.ship_to_customer_name
2219: );*/

Line 2239: OE_ID_TO_VALUE.CUSTOMER_LOCATION

2235:
2236: END IF;
2237: --kmuruges
2238: IF (p_header_rec_type.sold_to_site_use_id IS NOT NULL) THEN
2239: OE_ID_TO_VALUE.CUSTOMER_LOCATION
2240: ( p_sold_to_site_use_id => p_header_rec_type.sold_to_site_use_id,
2241: x_sold_to_location_address1 => x_header_val_rec.SOLD_TO_LOCATION_ADDRESS1,
2242: x_sold_to_location_address2 => x_header_val_rec.SOLD_TO_LOCATION_ADDRESS2,
2243: x_sold_to_location_address3 => x_header_val_rec.SOLD_TO_LOCATION_ADDRESS3,

Line 2255: X_header_val_rec.transaction_phase := oe_id_to_value.transaction_phase(p_header_rec_type.transaction_phase_code);

2251:
2252: END IF;
2253:
2254: IF (p_header_rec_type.transaction_phase_code IS NOT NULL) THEN
2255: X_header_val_rec.transaction_phase := oe_id_to_value.transaction_phase(p_header_rec_type.transaction_phase_code);
2256: END IF;
2257:
2258: IF (p_header_rec_type.User_Status_code IS NOT NULL) THEN
2259: X_header_val_rec.User_Status := oe_id_to_value.User_Status(p_header_rec_type.User_Status_code);

Line 2259: X_header_val_rec.User_Status := oe_id_to_value.User_Status(p_header_rec_type.User_Status_code);

2255: X_header_val_rec.transaction_phase := oe_id_to_value.transaction_phase(p_header_rec_type.transaction_phase_code);
2256: END IF;
2257:
2258: IF (p_header_rec_type.User_Status_code IS NOT NULL) THEN
2259: X_header_val_rec.User_Status := oe_id_to_value.User_Status(p_header_rec_type.User_Status_code);
2260: END IF;
2261:
2262: IF (p_header_rec_type.end_customer_site_use_id IS NOT NULL) THEN
2263: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE

Line 2263: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE

2259: X_header_val_rec.User_Status := oe_id_to_value.User_Status(p_header_rec_type.User_Status_code);
2260: END IF;
2261:
2262: IF (p_header_rec_type.end_customer_site_use_id IS NOT NULL) THEN
2263: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE
2264: ( p_end_customer_site_use_id => p_header_rec_type.end_customer_site_use_id,
2265: x_end_customer_address1 => x_header_val_rec.END_CUSTOMER_SITE_ADDRESS1,
2266: x_end_customer_address2 => x_header_val_rec.END_CUSTOMER_SITE_ADDRESS2,
2267: x_end_customer_address3 => x_header_val_rec.END_CUSTOMER_SITE_ADDRESS3,

Line 2279: OE_ID_TO_VALUE.END_CUSTOMER

2275:
2276: END IF;
2277:
2278: IF (p_header_rec_type.end_customer_id IS NOT NULL) THEN
2279: OE_ID_TO_VALUE.END_CUSTOMER
2280: ( p_end_customer_id => p_header_rec_type.end_customer_id,
2281: x_end_customer_name => x_header_val_rec.END_CUSTOMER_NAME,
2282: x_end_customer_number => x_header_val_rec.END_CUSTOMER_NUMBER
2283: );

Line 2287: x_header_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT

2283: );
2284: END IF;
2285:
2286: IF (p_header_rec_type.end_customer_contact_id IS NOT NULL) THEN
2287: x_header_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT
2288: ( p_end_customer_contact_id => p_header_rec_type.end_customer_contact_id);
2289: END IF;
2290:
2291: --kmuruges end

Line 2294: /*OE_Id_To_Value.Invoice_To_Customer_Name

2290:
2291: --kmuruges end
2292: IF (p_header_rec_type.invoice_to_org_id IS NOT NULL) THEN
2293: BEGIN
2294: /*OE_Id_To_Value.Invoice_To_Customer_Name
2295: (
2296: p_invoice_to_org_id => p_header_rec_type.invoice_to_org_id,
2297: x_invoice_to_customer_name=> x_header_val_rec.invoice_to_customer_name
2298: );*/

Line 2682: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card

2678: oe_debug_pub.add('Security code'||x_header_val_rec.instrument_security_code);
2679: --oe_debug_pub.add('Credit card code in populate control fields'||x_header_val_rec.credit_card_code);
2680: BEGIN
2681: IF x_header_val_rec.credit_card_code is not null then
2682: x_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
2683: ( p_credit_card_code => x_header_val_rec.credit_card_code
2684: );
2685: END IF;
2686: exception