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 1080: l_line_val_tbl(i).line_type := OE_Id_To_Value.Line_Type

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

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

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

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

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

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

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

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

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

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

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

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

1094:
1095: l_line_val_tbl(i).Agreement := OE_Id_To_Value.Agreement
1096: ( p_agreement_id => l_line_tbl(i).agreement_id );
1097:
1098: l_line_val_tbl(i).payment_term := OE_Id_To_Value.payment_term
1099: ( p_payment_term_id => l_line_tbl(i).payment_term_id );
1100:
1101: --sol_ord_er #16014165 start
1102: IF (l_line_tbl(i).service_subs_template_id IS NOT NULL AND

Line 1105: l_line_val_tbl(i).service_subs_template := OE_ID_TO_VALUE.Subscription_Template(p_service_subs_template_id => l_line_tbl(i).service_subs_template_id);

1101: --sol_ord_er #16014165 start
1102: IF (l_line_tbl(i).service_subs_template_id IS NOT NULL AND
1103: l_line_tbl(i).service_subs_template_id <> FND_API.G_MISS_NUM)
1104: THEN
1105: l_line_val_tbl(i).service_subs_template := OE_ID_TO_VALUE.Subscription_Template(p_service_subs_template_id => l_line_tbl(i).service_subs_template_id);
1106: END IF;
1107:
1108: IF (l_line_tbl(i).service_cov_template_id IS NOT NULL AND
1109: l_line_tbl(i).service_cov_template_id <> FND_API.G_MISS_NUM)

Line 1111: l_line_val_tbl(i).service_cov_template := OE_ID_TO_VALUE.Coverage_Template(p_service_cov_template_id => l_line_tbl(i).service_cov_template_id);

1107:
1108: IF (l_line_tbl(i).service_cov_template_id IS NOT NULL AND
1109: l_line_tbl(i).service_cov_template_id <> FND_API.G_MISS_NUM)
1110: THEN
1111: l_line_val_tbl(i).service_cov_template := OE_ID_TO_VALUE.Coverage_Template(p_service_cov_template_id => l_line_tbl(i).service_cov_template_id);
1112: END IF;
1113:
1114: IF (l_line_tbl(i).service_bill_profile_id IS NOT NULL AND
1115: l_line_tbl(i).service_bill_profile_id <> FND_API.G_MISS_NUM)

Line 1117: l_line_val_tbl(i).service_bill_profile := OE_ID_TO_VALUE.Billing_Profile(p_service_bill_profile_id => l_line_tbl(i).service_bill_profile_id);

1113:
1114: IF (l_line_tbl(i).service_bill_profile_id IS NOT NULL AND
1115: l_line_tbl(i).service_bill_profile_id <> FND_API.G_MISS_NUM)
1116: THEN
1117: l_line_val_tbl(i).service_bill_profile := OE_ID_TO_VALUE.Billing_Profile(p_service_bill_profile_id => l_line_tbl(i).service_bill_profile_id);
1118: END IF;
1119:
1120: IF (l_line_tbl(i).service_bill_option_code IS NOT NULL AND
1121: l_line_tbl(i).service_bill_option_code <> FND_API.G_MISS_CHAR)

Line 1123: l_line_val_tbl(i).service_bill_option :=OE_ID_TO_VALUE.Billing_Option(p_service_bill_option_code => l_line_tbl(i).service_bill_option_code);

1119:
1120: IF (l_line_tbl(i).service_bill_option_code IS NOT NULL AND
1121: l_line_tbl(i).service_bill_option_code <> FND_API.G_MISS_CHAR)
1122: THEN
1123: l_line_val_tbl(i).service_bill_option :=OE_ID_TO_VALUE.Billing_Option(p_service_bill_option_code => l_line_tbl(i).service_bill_option_code);
1124: END IF;
1125: --sol_ord_er #16014165 end
1126:
1127: --Added for bug 4034441 start

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

1124: END IF;
1125: --sol_ord_er #16014165 end
1126:
1127: --Added for bug 4034441 start
1128: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id
1129: , x_end_customer_name => l_line_val_tbl(i).end_customer_name
1130: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1131: );
1132: 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 1132: 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);

1128: Oe_Id_To_Value.End_Customer( p_end_customer_id => l_line_tbl(i).end_customer_id
1129: , x_end_customer_name => l_line_val_tbl(i).end_customer_name
1130: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1131: );
1132: 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);
1133:
1134: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_tbl(i).end_customer_site_use_id
1135: , x_end_customer_address1 => l_line_val_tbl(i).end_customer_site_address1
1136: , x_end_customer_address2 => l_line_val_tbl(i).end_customer_site_address2

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

1130: , x_end_customer_number => l_line_val_tbl(i).end_customer_number
1131: );
1132: 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);
1133:
1134: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_line_tbl(i).end_customer_site_use_id
1135: , x_end_customer_address1 => l_line_val_tbl(i).end_customer_site_address1
1136: , x_end_customer_address2 => l_line_val_tbl(i).end_customer_site_address2
1137: , x_end_customer_address3 => l_line_val_tbl(i).end_customer_site_address3
1138: , x_end_customer_address4 => l_line_val_tbl(i).end_customer_site_address4

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

1315: IF l_debug_level > 0 THEN
1316: oe_debug_pub.add( 'SOLD_TO_SITE_USE_ID: ' || l_header_rec.sold_to_site_use_id) ;
1317: END IF;
1318:
1319: OE_ID_TO_VALUE.Customer_Location(p_sold_to_site_use_id => l_header_rec.sold_to_site_use_id,
1320: x_sold_to_location_address1 => l_header_val_rec.sold_to_location_address1,
1321: x_sold_to_location_address2 => l_header_val_rec.sold_to_location_address2,
1322: x_sold_to_location_address3 => l_header_val_rec.sold_to_location_address3,
1323: x_sold_to_location_address4 => l_header_val_rec.sold_to_location_address4,

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

1346: IF l_debug_level > 0 THEN
1347: oe_debug_pub.add( 'END CUSTOMER ID: ' || l_header_rec.end_customer_id) ;
1348: END IF;
1349:
1350: OE_ID_TO_VALUE.End_Customer( p_end_customer_id => l_header_rec.end_customer_id
1351: , x_end_customer_name => l_header_val_rec.end_customer_name
1352: , x_end_customer_number => l_header_val_rec.end_customer_number
1353: );
1354:

Line 1375: 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);

1371: IF l_debug_level > 0 THEN
1372: oe_debug_pub.add( 'END CUSTOMER CONTACT ID: ' || l_header_rec.end_customer_contact_id) ;
1373: END IF;
1374:
1375: 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);
1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: NULL;

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

1393: IF l_debug_level > 0 THEN
1394: oe_debug_pub.add( 'END CUSTOMER SITE USE ID: ' || l_header_rec.end_customer_site_use_id) ;
1395: END IF;
1396:
1397: OE_ID_TO_VALUE.End_Customer_Site_Use( p_end_customer_site_use_id => l_header_rec.end_customer_site_use_id
1398: , x_end_customer_address1 => l_header_val_rec.end_customer_site_address1
1399: , x_end_customer_address2 => l_header_val_rec.end_customer_site_address2
1400: , x_end_customer_address3 => l_header_val_rec.end_customer_site_address3
1401: , x_end_customer_address4 => l_header_val_rec.end_customer_site_address4

Line 1662: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type

1658: IF l_debug_level > 0 THEN
1659: oe_debug_pub.add( 'UNABLE TO DERIVE SHIP_TO_CONTACT LAST NAME FOR HEAD' ) ;
1660: END IF;
1661: END;
1662: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type
1663: ( p_order_type_id => l_header_rec.order_type_id );
1664:
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add( 'L_HEADER_REC: '||L_HEADER_VAL_REC.ORDER_TYPE ) ;

Line 1668: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term

1664:
1665: IF l_debug_level > 0 THEN
1666: oe_debug_pub.add( 'L_HEADER_REC: '||L_HEADER_VAL_REC.ORDER_TYPE ) ;
1667: END IF;
1668: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term
1669: ( p_payment_term_id => l_header_rec.payment_term_id );
1670: IF l_debug_level > 0 THEN
1671: oe_debug_pub.add( 'L_HEADER_REC: PAYMENT TERM :'||L_HEADER_VAL_REC.PAYMENT_TERM ) ;
1672: END IF;

Line 1674: l_header_val_rec.price_list := OE_Id_To_Value.Price_List

1670: IF l_debug_level > 0 THEN
1671: oe_debug_pub.add( 'L_HEADER_REC: PAYMENT TERM :'||L_HEADER_VAL_REC.PAYMENT_TERM ) ;
1672: END IF;
1673:
1674: l_header_val_rec.price_list := OE_Id_To_Value.Price_List
1675: ( p_price_list_id => l_header_rec.price_list_id );
1676: IF l_debug_level > 0 THEN
1677: oe_debug_pub.add( 'L_HEADER_REC: PRICE LIST '||L_HEADER_VAL_REC.PRICE_LIST ) ;
1678: END IF;

Line 1683: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep

1679: IF l_debug_level > 0 THEN
1680: oe_debug_pub.add( 'L_HEADER_REC: ORDER_CATEGORY_CODE '||L_HEADER_REC.ORDER_CATEGORY_CODE ) ;
1681: END IF;
1682:
1683: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
1684: ( p_salesrep_id => l_header_rec.salesrep_id
1685: );
1686:
1687: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point

Line 1687: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point

1683: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
1684: ( p_salesrep_id => l_header_rec.salesrep_id
1685: );
1686:
1687: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point
1688: ( p_fob_point_code => l_header_rec.fob_point_code
1689: );
1690:
1691: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms

Line 1691: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms

1687: l_header_val_rec.fob_point := OE_Id_To_Value.fob_point
1688: ( p_fob_point_code => l_header_rec.fob_point_code
1689: );
1690:
1691: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms
1692: ( p_freight_terms_code => l_header_rec.freight_terms_code
1693: );
1694:
1695: l_header_val_rec.agreement := OE_Id_To_Value.agreement

Line 1695: l_header_val_rec.agreement := OE_Id_To_Value.agreement

1691: l_header_val_rec.freight_terms := OE_Id_To_Value.freight_terms
1692: ( p_freight_terms_code => l_header_rec.freight_terms_code
1693: );
1694:
1695: l_header_val_rec.agreement := OE_Id_To_Value.agreement
1696: ( p_agreement_id => l_header_rec.agreement_id
1697: );
1698:
1699: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

Line 1699: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

1695: l_header_val_rec.agreement := OE_Id_To_Value.agreement
1696: ( p_agreement_id => l_header_rec.agreement_id
1697: );
1698:
1699: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
1700: ( p_conversion_type_code => l_header_rec.conversion_type_code
1701: );
1702:
1703: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

Line 1703: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

1699: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
1700: ( p_conversion_type_code => l_header_rec.conversion_type_code
1701: );
1702:
1703: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
1704: ( p_tax_exempt_reason_code => l_header_rec.tax_exempt_reason_code
1705: );
1706:
1707: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

Line 1707: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

1703: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
1704: ( p_tax_exempt_reason_code => l_header_rec.tax_exempt_reason_code
1705: );
1706:
1707: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
1708: ( p_tax_point_code => l_header_rec.tax_point_code
1709: );
1710:
1711: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

Line 1711: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

1707: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
1708: ( p_tax_point_code => l_header_rec.tax_point_code
1709: );
1710:
1711: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
1712: ( p_invoicing_rule_id => l_header_rec.invoicing_rule_id
1713: );
1714:
1715: OE_Id_To_Value.Sold_To_Org

Line 1715: OE_Id_To_Value.Sold_To_Org

1711: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
1712: ( p_invoicing_rule_id => l_header_rec.invoicing_rule_id
1713: );
1714:
1715: OE_Id_To_Value.Sold_To_Org
1716: ( p_sold_to_org_id => l_header_rec.sold_to_org_id
1717: , x_org => l_header_val_rec.sold_to_org
1718: , x_customer_number => l_header_val_rec.customer_number
1719: );

Line 1721: Oe_Id_To_Value.Deliver_To_Org -- For bug 2701018

1717: , x_org => l_header_val_rec.sold_to_org
1718: , x_customer_number => l_header_val_rec.customer_number
1719: );
1720:
1721: Oe_Id_To_Value.Deliver_To_Org -- For bug 2701018
1722: ( p_deliver_to_org_id => l_header_rec.deliver_to_org_id
1723: , x_deliver_to_address1 => l_header_val_rec.deliver_to_address1
1724: , x_deliver_to_address2 => l_header_val_rec.deliver_to_address2
1725: , x_deliver_to_address3 => l_header_val_rec.deliver_to_address3

Line 1736: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact

1732: , x_deliver_to_country => l_header_val_rec.deliver_to_country
1733: );
1734: l_header_val_rec.deliver_to_customer_number := NULL; --For bug 2701018
1735:
1736: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
1737: ( p_sold_to_contact_id => l_header_rec.sold_to_contact_id
1738: );
1739:
1740: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

Line 1740: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

1736: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
1737: ( p_sold_to_contact_id => l_header_rec.sold_to_contact_id
1738: );
1739:
1740: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
1741: ( p_ship_to_contact_id => l_header_rec.ship_to_contact_id
1742: );
1743:
1744: if (l_header_val_rec.customer_payment_term is NULL OR

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

1749: l_header_val_rec.ship_to_org :=l_header_val_rec.ship_to_location;
1750: l_header_val_rec.invoice_to_org :=l_header_val_rec.invoice_to_location;
1751:
1752: -- for bug 3656640
1753: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_rec.ship_to_org_id,
1754: x_ship_to_customer_name => l_header_val_rec.ship_to_customer_name);
1755:
1756: -- for bug 4489065
1757: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_rec.invoice_to_org_id,

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

1753: OE_ID_TO_VALUE.Ship_To_Customer_Name(p_ship_to_org_id => l_header_rec.ship_to_org_id,
1754: x_ship_to_customer_name => l_header_val_rec.ship_to_customer_name);
1755:
1756: -- for bug 4489065
1757: OE_ID_TO_VALUE.Invoice_To_Customer_Name(p_invoice_to_org_id => l_header_rec.invoice_to_org_id,
1758: x_invoice_to_customer_name => l_header_val_rec.invoice_to_customer_name);
1759:
1760:
1761: IF l_debug_level > 0 THEN

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

2399: -- do id to value conversion to get sold_to_org to pass when getting rejected lines
2400:
2401: begin
2402: IF l_header_rec.sold_to_org_id is not null THEN
2403: OE_ID_TO_VALUE.sold_to_org(p_sold_to_org_id => l_header_rec.sold_to_org_id,
2404: x_org => l_sold_to_org,
2405: x_customer_number => l_customer_number);
2406: END IF;
2407: