eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ACKNOWLEDGMENT_PVT dependencies on OE_ID_TO_VALUE

Line 1079: l_line_val_tbl(i).line_type := OE_Id_To_Value.Line_Type

1075: oe_debug_pub.add( 'UNABLE TO GET ITEM NAME' ) ;
1076: END IF;
1077: END;
1078: /* 1944673 */
1079: l_line_val_tbl(i).line_type := OE_Id_To_Value.Line_Type
1080: ( p_line_type_id => l_line_tbl(i).line_type_id );
1081:
1082: l_line_val_tbl(i).price_list := OE_Id_To_Value.price_list
1083: ( p_price_list_id => l_line_tbl(i).price_list_id );

Line 1082: l_line_val_tbl(i).price_list := OE_Id_To_Value.price_list

1078: /* 1944673 */
1079: l_line_val_tbl(i).line_type := OE_Id_To_Value.Line_Type
1080: ( p_line_type_id => l_line_tbl(i).line_type_id );
1081:
1082: l_line_val_tbl(i).price_list := OE_Id_To_Value.price_list
1083: ( p_price_list_id => l_line_tbl(i).price_list_id );
1084:
1085: l_line_val_tbl(i).salesrep := OE_Id_To_Value.salesrep
1086: ( p_salesrep_id => l_line_tbl(i).salesrep_id );

Line 1085: l_line_val_tbl(i).salesrep := OE_Id_To_Value.salesrep

1081:
1082: l_line_val_tbl(i).price_list := OE_Id_To_Value.price_list
1083: ( p_price_list_id => l_line_tbl(i).price_list_id );
1084:
1085: l_line_val_tbl(i).salesrep := OE_Id_To_Value.salesrep
1086: ( p_salesrep_id => l_line_tbl(i).salesrep_id );
1087:
1088: l_line_val_tbl(i).fob_point := OE_Id_To_Value.Fob_Point
1089: ( p_Fob_Point_code => l_line_tbl(i).fob_point_code );

Line 1088: l_line_val_tbl(i).fob_point := OE_Id_To_Value.Fob_Point

1084:
1085: l_line_val_tbl(i).salesrep := OE_Id_To_Value.salesrep
1086: ( p_salesrep_id => l_line_tbl(i).salesrep_id );
1087:
1088: l_line_val_tbl(i).fob_point := OE_Id_To_Value.Fob_Point
1089: ( p_Fob_Point_code => l_line_tbl(i).fob_point_code );
1090:
1091: l_line_val_tbl(i).freight_terms := OE_Id_To_Value.freight_terms
1092: ( p_freight_terms_code => l_line_tbl(i).freight_terms_code );

Line 1091: l_line_val_tbl(i).freight_terms := OE_Id_To_Value.freight_terms

1087:
1088: l_line_val_tbl(i).fob_point := OE_Id_To_Value.Fob_Point
1089: ( p_Fob_Point_code => l_line_tbl(i).fob_point_code );
1090:
1091: l_line_val_tbl(i).freight_terms := OE_Id_To_Value.freight_terms
1092: ( p_freight_terms_code => l_line_tbl(i).freight_terms_code );
1093:
1094: l_line_val_tbl(i).Agreement := OE_Id_To_Value.Agreement
1095: ( p_agreement_id => l_line_tbl(i).agreement_id );

Line 1094: l_line_val_tbl(i).Agreement := OE_Id_To_Value.Agreement

1090:
1091: l_line_val_tbl(i).freight_terms := OE_Id_To_Value.freight_terms
1092: ( p_freight_terms_code => l_line_tbl(i).freight_terms_code );
1093:
1094: l_line_val_tbl(i).Agreement := OE_Id_To_Value.Agreement
1095: ( p_agreement_id => l_line_tbl(i).agreement_id );
1096:
1097: l_line_val_tbl(i).payment_term := OE_Id_To_Value.payment_term
1098: ( p_payment_term_id => l_line_tbl(i).payment_term_id );

Line 1097: l_line_val_tbl(i).payment_term := OE_Id_To_Value.payment_term

1093:
1094: l_line_val_tbl(i).Agreement := OE_Id_To_Value.Agreement
1095: ( p_agreement_id => l_line_tbl(i).agreement_id );
1096:
1097: l_line_val_tbl(i).payment_term := OE_Id_To_Value.payment_term
1098: ( p_payment_term_id => l_line_tbl(i).payment_term_id );
1099:
1100: --Added for bug 4034441 start
1101: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id

Line 1101: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id

1097: l_line_val_tbl(i).payment_term := OE_Id_To_Value.payment_term
1098: ( p_payment_term_id => l_line_tbl(i).payment_term_id );
1099:
1100: --Added for bug 4034441 start
1101: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id
1102: , x_end_customer_name => l_line_val_tbl(i).end_customer_name
1103: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1104: );
1105: l_line_val_tbl(i).end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_tbl(i).end_customer_contact_id);

Line 1105: l_line_val_tbl(i).end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_tbl(i).end_customer_contact_id);

1101: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id
1102: , x_end_customer_name => l_line_val_tbl(i).end_customer_name
1103: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1104: );
1105: l_line_val_tbl(i).end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_tbl(i).end_customer_contact_id);
1106:
1107: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_tbl(i).end_customer_site_use_id
1108: , x_end_customer_address1 => l_line_val_tbl(i).end_customer_site_address1
1109: , x_end_customer_address2 => l_line_val_tbl(i).end_customer_site_address2

Line 1107: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_tbl(i).end_customer_site_use_id

1103: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1104: );
1105: l_line_val_tbl(i).end_customer_contact := Oe_Id_To_Value.End_Customer_Contact(p_end_customer_contact_id => l_line_tbl(i).end_customer_contact_id);
1106:
1107: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_tbl(i).end_customer_site_use_id
1108: , x_end_customer_address1 => l_line_val_tbl(i).end_customer_site_address1
1109: , x_end_customer_address2 => l_line_val_tbl(i).end_customer_site_address2
1110: , x_end_customer_address3 => l_line_val_tbl(i).end_customer_site_address3
1111: , x_end_customer_address4 => l_line_val_tbl(i).end_customer_site_address4

Line 1292: OE_ID_TO_VALUE.Customer_Location(p_sold_to_site_use_id => l_header_rec.sold_to_site_use_id,

1288: IF l_debug_level > 0 THEN
1289: oe_debug_pub.add( 'SOLD_TO_SITE_USE_ID: ' || l_header_rec.sold_to_site_use_id) ;
1290: END IF;
1291:
1292: OE_ID_TO_VALUE.Customer_Location(p_sold_to_site_use_id => l_header_rec.sold_to_site_use_id,
1293: x_sold_to_location_address1 => l_header_val_rec.sold_to_location_address1,
1294: x_sold_to_location_address2 => l_header_val_rec.sold_to_location_address2,
1295: x_sold_to_location_address3 => l_header_val_rec.sold_to_location_address3,
1296: x_sold_to_location_address4 => l_header_val_rec.sold_to_location_address4,

Line 1323: OE_ID_TO_VALUE.End_Customer( p_end_customer_id => l_header_rec.end_customer_id

1319: IF l_debug_level > 0 THEN
1320: oe_debug_pub.add( 'END CUSTOMER ID: ' || l_header_rec.end_customer_id) ;
1321: END IF;
1322:
1323: OE_ID_TO_VALUE.End_Customer( p_end_customer_id => l_header_rec.end_customer_id
1324: , x_end_customer_name => l_header_val_rec.end_customer_name
1325: , x_end_customer_number => l_header_val_rec.end_customer_number
1326: );
1327:

Line 1348: l_header_val_rec.end_customer_contact := OE_ID_TO_VALUE.End_Customer_Contact( p_end_customer_contact_id => l_header_rec.end_customer_contact_id);

1344: IF l_debug_level > 0 THEN
1345: oe_debug_pub.add( 'END CUSTOMER CONTACT ID: ' || l_header_rec.end_customer_contact_id) ;
1346: END IF;
1347:
1348: l_header_val_rec.end_customer_contact := OE_ID_TO_VALUE.End_Customer_Contact( p_end_customer_contact_id => l_header_rec.end_customer_contact_id);
1349:
1350: EXCEPTION
1351: WHEN OTHERS THEN
1352: NULL;

Line 1370: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_header_rec.end_customer_site_use_id

1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add( 'END CUSTOMER SITE USE ID: ' || l_header_rec.end_customer_site_use_id) ;
1368: END IF;
1369:
1370: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_header_rec.end_customer_site_use_id
1371: , x_end_customer_address1 => l_header_val_rec.end_customer_site_address1
1372: , x_end_customer_address2 => l_header_val_rec.end_customer_site_address2
1373: , x_end_customer_address3 => l_header_val_rec.end_customer_site_address3
1374: , x_end_customer_address4 => l_header_val_rec.end_customer_site_address4

Line 1635: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type

1631: IF l_debug_level > 0 THEN
1632: oe_debug_pub.add( 'UNABLE TO DERIVE SHIP_TO_CONTACT LAST NAME FOR HEAD' ) ;
1633: END IF;
1634: END;
1635: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type
1636: ( p_order_type_id => l_header_rec.order_type_id );
1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_HEADER_REC: '||L_HEADER_VAL_REC.ORDER_TYPE ) ;

Line 1641: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term

1637:
1638: IF l_debug_level > 0 THEN
1639: oe_debug_pub.add( 'L_HEADER_REC: '||L_HEADER_VAL_REC.ORDER_TYPE ) ;
1640: END IF;
1641: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term
1642: ( p_payment_term_id => l_header_rec.payment_term_id );
1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_HEADER_REC: PAYMENT TERM :'||L_HEADER_VAL_REC.PAYMENT_TERM ) ;
1645: END IF;

Line 1647: l_header_val_rec.price_list := OE_Id_To_Value.Price_List

1643: IF l_debug_level > 0 THEN
1644: oe_debug_pub.add( 'L_HEADER_REC: PAYMENT TERM :'||L_HEADER_VAL_REC.PAYMENT_TERM ) ;
1645: END IF;
1646:
1647: l_header_val_rec.price_list := OE_Id_To_Value.Price_List
1648: ( p_price_list_id => l_header_rec.price_list_id );
1649: IF l_debug_level > 0 THEN
1650: oe_debug_pub.add( 'L_HEADER_REC: PRICE LIST '||L_HEADER_VAL_REC.PRICE_LIST ) ;
1651: END IF;

Line 1656: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep

1652: IF l_debug_level > 0 THEN
1653: oe_debug_pub.add( 'L_HEADER_REC: ORDER_CATEGORY_CODE '||L_HEADER_REC.ORDER_CATEGORY_CODE ) ;
1654: END IF;
1655:
1656: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
1657: ( p_salesrep_id => l_header_rec.salesrep_id
1658: );
1659:
1660: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point

Line 1660: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point

1656: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
1657: ( p_salesrep_id => l_header_rec.salesrep_id
1658: );
1659:
1660: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point
1661: ( p_fob_point_code => l_header_rec.fob_point_code
1662: );
1663:
1664: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms

Line 1664: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms

1660: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point
1661: ( p_fob_point_code => l_header_rec.fob_point_code
1662: );
1663:
1664: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms
1665: ( p_freight_terms_code => l_header_rec.freight_terms_code
1666: );
1667:
1668: l_header_val_rec.agreement := OE_Id_To_Value.agreement

Line 1668: l_header_val_rec.agreement := OE_Id_To_Value.agreement

1664: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms
1665: ( p_freight_terms_code => l_header_rec.freight_terms_code
1666: );
1667:
1668: l_header_val_rec.agreement := OE_Id_To_Value.agreement
1669: ( p_agreement_id => l_header_rec.agreement_id
1670: );
1671:
1672: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

Line 1672: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

1668: l_header_val_rec.agreement := OE_Id_To_Value.agreement
1669: ( p_agreement_id => l_header_rec.agreement_id
1670: );
1671:
1672: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
1673: ( p_conversion_type_code => l_header_rec.conversion_type_code
1674: );
1675:
1676: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

Line 1676: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

1672: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
1673: ( p_conversion_type_code => l_header_rec.conversion_type_code
1674: );
1675:
1676: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
1677: ( p_tax_exempt_reason_code => l_header_rec.tax_exempt_reason_code
1678: );
1679:
1680: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

Line 1680: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

1676: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
1677: ( p_tax_exempt_reason_code => l_header_rec.tax_exempt_reason_code
1678: );
1679:
1680: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
1681: ( p_tax_point_code => l_header_rec.tax_point_code
1682: );
1683:
1684: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

Line 1684: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

1680: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
1681: ( p_tax_point_code => l_header_rec.tax_point_code
1682: );
1683:
1684: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
1685: ( p_invoicing_rule_id => l_header_rec.invoicing_rule_id
1686: );
1687:
1688: OE_Id_To_Value.Sold_To_Org

Line 1688: OE_Id_To_Value.Sold_To_Org

1684: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
1685: ( p_invoicing_rule_id => l_header_rec.invoicing_rule_id
1686: );
1687:
1688: OE_Id_To_Value.Sold_To_Org
1689: ( p_sold_to_org_id => l_header_rec.sold_to_org_id
1690: , x_org => l_header_val_rec.sold_to_org
1691: , x_customer_number => l_header_val_rec.customer_number
1692: );

Line 1694: Oe_Id_To_Value.Deliver_To_Org -- For bug 2701018

1690: , x_org => l_header_val_rec.sold_to_org
1691: , x_customer_number => l_header_val_rec.customer_number
1692: );
1693:
1694: Oe_Id_To_Value.Deliver_To_Org -- For bug 2701018
1695: ( p_deliver_to_org_id => l_header_rec.deliver_to_org_id
1696: , x_deliver_to_address1 => l_header_val_rec.deliver_to_address1
1697: , x_deliver_to_address2 => l_header_val_rec.deliver_to_address2
1698: , x_deliver_to_address3 => l_header_val_rec.deliver_to_address3

Line 1709: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact

1705: , x_deliver_to_country => l_header_val_rec.deliver_to_country
1706: );
1707: l_header_val_rec.deliver_to_customer_number := NULL; --For bug 2701018
1708:
1709: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
1710: ( p_sold_to_contact_id => l_header_rec.sold_to_contact_id
1711: );
1712:
1713: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

Line 1713: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

1709: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
1710: ( p_sold_to_contact_id => l_header_rec.sold_to_contact_id
1711: );
1712:
1713: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
1714: ( p_ship_to_contact_id => l_header_rec.ship_to_contact_id
1715: );
1716:
1717: if (l_header_val_rec.customer_payment_term is NULL OR

Line 1726: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_rec.ship_to_org_id,

1722: l_header_val_rec.ship_to_org :=l_header_val_rec.ship_to_location;
1723: l_header_val_rec.invoice_to_org :=l_header_val_rec.invoice_to_location;
1724:
1725: -- for bug 3656640
1726: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_rec.ship_to_org_id,
1727: x_ship_to_customer_name => l_header_val_rec.ship_to_customer_name);
1728:
1729: -- for bug 4489065
1730: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_rec.invoice_to_org_id,

Line 1730: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_rec.invoice_to_org_id,

1726: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_rec.ship_to_org_id,
1727: x_ship_to_customer_name => l_header_val_rec.ship_to_customer_name);
1728:
1729: -- for bug 4489065
1730: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_rec.invoice_to_org_id,
1731: x_invoice_to_customer_name => l_header_val_rec.invoice_to_customer_name);
1732:
1733:
1734: IF l_debug_level > 0 THEN

Line 2373: OE_ID_TO_VALUE.sold_to_org(p_sold_to_org_id => l_header_rec.sold_to_org_id,

2369: -- do id to value conversion to get sold_to_org to pass when getting rejected lines
2370:
2371: begin
2372: IF l_header_rec.sold_to_org_id is not null THEN
2373: OE_ID_TO_VALUE.sold_to_org(p_sold_to_org_id => l_header_rec.sold_to_org_id,
2374: x_org => l_sold_to_org,
2375: x_customer_number => l_customer_number);
2376: END IF;
2377: