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_DEFAULT_PVT dependencies on OE_ORDER_CACHE

Line 625: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

621: ,p_attribute_code IN VARCHAR2)
622: RETURN VARCHAR2
623: IS
624: l_tax_exempt_number VARCHAR2(80);
625: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
626: /***
627: CURSOR C_Std_Tax_Exemption(X_Ship_To_Org_Id NUMBER,
628: X_Invoice_To_Org_id NUMBER,
629: X_Date_Ordered DATE) is

Line 689: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

685: ,p_attribute_code IN VARCHAR2)
686: RETURN VARCHAR2
687: IS
688: l_tax_exempt_reason_code VARCHAR2(80);
689: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
690: /***
691: CURSOR C_Std_Tax_Exemption(X_Ship_To_Org_Id NUMBER,
692: X_Invoice_To_Org_id NUMBER,
693: X_Date_Ordered DATE) is

Line 750: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

746: IS
747: l_tax_exempt_flag VARCHAR2(1) := NULL;
748: l_tax_exempt_number VARCHAR2(80) := NULL;
749: l_tax_exempt_reason_code VARCHAR2(80) := NULL;
750: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
751:
752: -- eBTax changes
753: /*
754: CURSOR C_Line_Std_Tax_Exemption(X_Ship_To_Org_Id NUMBER,

Line 798: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);

794: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
795: --
796: BEGIN
797:
798: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);
799:
800: IF nvl(ONT_LINE_DEF_HDLR.g_record.tax_exempt_flag, 'S') <> 'R' AND
801: l_line_type_rec.calculate_tax_flag = 'N' THEN
802:

Line 854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)

850: ONT_LINE_Def_Hdlr.g_record.tax_code <> FND_API.G_MISS_CHAR
851: THEN
852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)

Line 856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)

852: --bsadri if the cached values are the same do not fetch them
853: IF nvl(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,FND_API.G_MISS_NUM)
854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)

Line 858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)

854: <>nvl( OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
855: OR nvl(ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id,FND_API.G_MISS_NUM) <>
856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)

Line 860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)

856: NVL( OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
857: OR NVL(ONT_LINE_Def_Hdlr.g_record.sold_to_org_id,FND_API.G_MISS_NUM) <>
858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{
864: -- eBTax changes

Line 862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)

858: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id,FND_API.G_MISS_NUM)
859: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_date,FND_API.G_MISS_DATE) <>
860: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date,FND_API.G_MISS_DATE)
861: OR nvl(ONT_LINE_Def_Hdlr.g_record.tax_code,FND_API.G_MISS_CHAR) <>
862: nvl(OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code ,FND_API.G_MISS_CHAR)
863: THEN --{
864: -- eBTax changes
865: /* OPEN C_Line_Std_Tax_Exemption(ONT_LINE_Def_Hdlr.g_record.ship_to_org_id,
866: ONT_LINE_Def_Hdlr.g_record.Invoice_To_Org_id,

Line 921: OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id :=

917:
918: -- end eBtax changes
919:
920:
921: OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id :=
922: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id ;
923: OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id :=
924: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id;
925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=

Line 923: OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id :=

919:
920:
921: OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id :=
922: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id ;
923: OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id :=
924: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id;
925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=
926: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id ;
927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=

Line 925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=

921: OE_Order_Cache.g_TAX_EXEMPTION_CACH.ship_to_org_id :=
922: ONT_LINE_Def_Hdlr.g_record.ship_to_org_id ;
923: OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id :=
924: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id;
925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=
926: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id ;
927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=
928: ONT_LINE_Def_Hdlr.g_record.tax_date;
929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=

Line 927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=

923: OE_Order_Cache.g_TAX_EXEMPTION_CACH.invoice_to_org_id :=
924: ONT_LINE_Def_Hdlr.g_record.invoice_to_org_id;
925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=
926: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id ;
927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=
928: ONT_LINE_Def_Hdlr.g_record.tax_date;
929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=
930: ONT_LINE_Def_Hdlr.g_record.tax_code;
931: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number :=

Line 929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=

925: OE_Order_Cache.g_TAX_EXEMPTION_CACH.sold_to_org_id :=
926: ONT_LINE_Def_Hdlr.g_record.sold_to_org_id ;
927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=
928: ONT_LINE_Def_Hdlr.g_record.tax_date;
929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=
930: ONT_LINE_Def_Hdlr.g_record.tax_code;
931: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number :=
932: l_tax_exempt_number;
933: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code :=

Line 931: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number :=

927: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_date :=
928: ONT_LINE_Def_Hdlr.g_record.tax_date;
929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=
930: ONT_LINE_Def_Hdlr.g_record.tax_code;
931: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number :=
932: l_tax_exempt_number;
933: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code :=
934: l_tax_exempt_reason_code;
935:

Line 933: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code :=

929: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_code :=
930: ONT_LINE_Def_Hdlr.g_record.tax_code;
931: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number :=
932: l_tax_exempt_number;
933: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code :=
934: l_tax_exempt_reason_code;
935:
936:
937: ELSE --}{

Line 940: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number;

936:
937: ELSE --}{
938: --use the cached values
939: l_tax_exempt_number :=
940: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number;
941: l_tax_exempt_reason_code :=
942: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code;
943: END IF; --}
944: END IF;

Line 942: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code;

938: --use the cached values
939: l_tax_exempt_number :=
940: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_number;
941: l_tax_exempt_reason_code :=
942: OE_Order_Cache.g_TAX_EXEMPTION_CACH.tax_exempt_reason_code;
943: END IF; --}
944: END IF;
945:
946: ELSIF ONT_LINE_Def_Hdlr.g_record.tax_exempt_flag = 'R' THEN

Line 1056: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

1052: ,p_attribute_code IN VARCHAR2)
1053: RETURN VARCHAR2
1054: IS
1055: X_Currency_Code VARCHAR2(15);
1056: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
1057: --
1058: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1059: --
1060: BEGIN

Line 1063: OE_Order_Cache.Load_Set_Of_Books;

1059: --
1060: BEGIN
1061:
1062: l_set_of_books_rec :=
1063: OE_Order_Cache.Load_Set_Of_Books;
1064: x_Currency_Code := l_set_of_books_rec.Currency_Code;
1065:
1066: IF x_Currency_Code = FND_API.G_MISS_CHAR THEN
1067:

Line 1108: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

1104: l_Set_Of_Books_Id NUMBER;
1105: l_Ord_Type_Id NUMBER;
1106: x_tax_code VARCHAR2(50);
1107: l_trx_type_id NUMBER;
1108: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
1109: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
1110: l_organization_id NUMBER := -1;
1111: l_cust_trx_type_id NUMBER := 0;
1112: l_calculate_tax_flag VARCHAR2(1) ;

Line 1109: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;

1105: l_Ord_Type_Id NUMBER;
1106: x_tax_code VARCHAR2(50);
1107: l_trx_type_id NUMBER;
1108: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
1109: l_line_type_rec OE_Order_Cache.line_type_Rec_Type;
1110: l_organization_id NUMBER := -1;
1111: l_cust_trx_type_id NUMBER := 0;
1112: l_calculate_tax_flag VARCHAR2(1) ;
1113:

Line 1170: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);

1166: --bug 3175277 begin
1167: --There is no need to load line_type cache again because
1168: --OE_Invoice_PUB.Get_Customer_Transaction_Type checks the line_type cache to get cust_trx_type_id
1169: /*if (l_cust_trx_type_id = 0 or l_cust_trx_type_id is null) then
1170: l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);
1171: l_cust_trx_type_id := l_line_type_rec.cust_trx_type_id;
1172: oe_debug_pub.add( 'customer trx type id:'||l_cust_trx_type_id,1);
1173: end if; */
1174: --bug 3175277 end

Line 1177: IF OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id = l_cust_trx_type_id THEN

1173: end if; */
1174: --bug 3175277 end
1175:
1176: -- performance fix for bug 4200055
1177: IF OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id = l_cust_trx_type_id THEN
1178: l_calculate_tax_flag := OE_ORDER_CACHE.g_line_type_rec.calculate_tax_flag ;
1179: ELSE
1180: SELECT tax_calculation_flag
1181: into l_calculate_tax_flag

Line 1178: l_calculate_tax_flag := OE_ORDER_CACHE.g_line_type_rec.calculate_tax_flag ;

1174: --bug 3175277 end
1175:
1176: -- performance fix for bug 4200055
1177: IF OE_ORDER_CACHE.g_line_type_rec.cust_trx_type_id = l_cust_trx_type_id THEN
1178: l_calculate_tax_flag := OE_ORDER_CACHE.g_line_type_rec.calculate_tax_flag ;
1179: ELSE
1180: SELECT tax_calculation_flag
1181: into l_calculate_tax_flag
1182: FROM RA_CUST_TRX_TYPES

Line 1192: --l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);

1188: FROM RA_CUST_TRX_TYPES
1189: WHERE CUST_TRX_TYPE_ID = l_cust_trx_type_id;
1190: end if; */
1191: -- end bug 4200055
1192: --l_line_type_rec := oe_order_cache.load_line_type(ONT_LINE_DEF_HDLR.g_record.line_type_id);
1193:
1194: IF l_debug_level > 0 THEN
1195: oe_debug_pub.add('l_calculate_tax_flag : '|| l_calculate_tax_flag);
1196: END IF;

Line 1262: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;

1258: IF l_debug_level > 0 THEN
1259: oe_debug_pub.add( 'REN 1' , 3 ) ;
1260: END IF;
1261: -- Get Set of book ID
1262: l_set_of_books_rec := OE_Order_Cache.Load_Set_Of_Books;
1263: l_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
1264: oe_debug_pub.add('Set of books id:'||l_set_of_books_id , 3 ) ;
1265:
1266: IF l_debug_level > 0 THEN

Line 1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)

1277: --bsadri caching the values
1278:
1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)

Line 1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)

1279: IF nvl(ONT_LINE_DEF_HDLR.g_record.ship_to_org_id,FND_API.G_MISS_NUM)<>
1280:
1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)

Line 1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)

1281: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id,FND_API.G_MISS_NUM)
1282: OR nvl(ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id,FND_API.G_MISS_NUM)<>
1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)

Line 1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)

1283: nvl(OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id,FND_API.G_MISS_NUM)
1284: OR nvl(ONT_LINE_DEF_HDLR.g_record.inventory_item_id,FND_API.G_MISS_NUM) <>
1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)

Line 1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)

1285: nvl(OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id,FND_API.G_MISS_NUM)
1286: OR nvl(ONT_LINE_DEF_HDLR.g_record.ship_from_org_id,FND_API.G_MISS_NUM)<>
1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)
1292: THEN
1293:

Line 1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)

1287: nvl(OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id ,FND_API.G_MISS_NUM)
1288: OR nvl(ONT_LINE_DEF_HDLR.g_record.tax_date,FND_API.G_MISS_DATE) <>
1289: nvl(OE_Order_Cache.g_TAX_CODE_CACH.tax_date,FND_API.G_MISS_DATE)
1290: OR nvl(l_trx_type_id,FND_API.G_MISS_NUM) <>
1291: nvl( OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id,FND_API.G_MISS_NUM)
1292: THEN
1293:
1294: IF l_debug_level > 0 THEN
1295: oe_debug_pub.add( 'REN INSIDE TC 1 ' , 3 ) ;

Line 1314: OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id :=

1310: p_event_class_code => 'SALES_TRANSACTION_TAX_QUOTE',
1311: p_application_id => 660,
1312: p_internal_organization_id => l_org_id);
1313:
1314: OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id :=
1315: ONT_LINE_DEF_HDLR.g_record.ship_to_org_id;
1316: OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id :=
1317: ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id;
1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=

Line 1316: OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id :=

1312: p_internal_organization_id => l_org_id);
1313:
1314: OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id :=
1315: ONT_LINE_DEF_HDLR.g_record.ship_to_org_id;
1316: OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id :=
1317: ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id;
1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=
1319: ONT_LINE_DEF_HDLR.g_record.inventory_item_id;
1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=

Line 1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=

1314: OE_Order_Cache.g_TAX_CODE_CACH.ship_to_org_id :=
1315: ONT_LINE_DEF_HDLR.g_record.ship_to_org_id;
1316: OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id :=
1317: ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id;
1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=
1319: ONT_LINE_DEF_HDLR.g_record.inventory_item_id;
1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=
1321: ONT_LINE_DEF_HDLR.g_record.ship_from_org_id;
1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=

Line 1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=

1316: OE_Order_Cache.g_TAX_CODE_CACH.invoice_to_org_id :=
1317: ONT_LINE_DEF_HDLR.g_record.invoice_to_org_id;
1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=
1319: ONT_LINE_DEF_HDLR.g_record.inventory_item_id;
1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=
1321: ONT_LINE_DEF_HDLR.g_record.ship_from_org_id;
1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=
1323: ONT_LINE_DEF_HDLR.g_record.tax_date;
1324: OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id :=

Line 1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=

1318: OE_Order_Cache.g_TAX_CODE_CACH.inventory_item_id :=
1319: ONT_LINE_DEF_HDLR.g_record.inventory_item_id;
1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=
1321: ONT_LINE_DEF_HDLR.g_record.ship_from_org_id;
1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=
1323: ONT_LINE_DEF_HDLR.g_record.tax_date;
1324: OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id :=
1325: l_trx_type_id;
1326: OE_Order_Cache.g_TAX_CODE_CACH.tax_code := x_tax_code;

Line 1324: OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id :=

1320: OE_Order_Cache.g_TAX_CODE_CACH.ship_from_org_id :=
1321: ONT_LINE_DEF_HDLR.g_record.ship_from_org_id;
1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=
1323: ONT_LINE_DEF_HDLR.g_record.tax_date;
1324: OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id :=
1325: l_trx_type_id;
1326: OE_Order_Cache.g_TAX_CODE_CACH.tax_code := x_tax_code;
1327:
1328: ELSE

Line 1326: OE_Order_Cache.g_TAX_CODE_CACH.tax_code := x_tax_code;

1322: OE_Order_Cache.g_TAX_CODE_CACH.tax_date :=
1323: ONT_LINE_DEF_HDLR.g_record.tax_date;
1324: OE_Order_Cache.g_TAX_CODE_CACH.trx_type_id :=
1325: l_trx_type_id;
1326: OE_Order_Cache.g_TAX_CODE_CACH.tax_code := x_tax_code;
1327:
1328: ELSE
1329: --use the cached values
1330: x_tax_code := OE_Order_Cache.g_TAX_CODE_CACH.tax_code ;

Line 1330: x_tax_code := OE_Order_Cache.g_TAX_CODE_CACH.tax_code ;

1326: OE_Order_Cache.g_TAX_CODE_CACH.tax_code := x_tax_code;
1327:
1328: ELSE
1329: --use the cached values
1330: x_tax_code := OE_Order_Cache.g_TAX_CODE_CACH.tax_code ;
1331:
1332: END IF; /* if cached values are different than passed values */
1333:
1334: IF l_debug_level > 0 THEN

Line 1787: OE_ORDER_CACHE.Load_Order_Header(Ont_Line_Def_Hdlr.G_Record.header_id);

1783: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1784: --
1785: BEGIN
1786:
1787: OE_ORDER_CACHE.Load_Order_Header(Ont_Line_Def_Hdlr.G_Record.header_id);
1788: l_latest_acceptable_date := Ont_Line_Def_Hdlr.G_Record.request_date
1789: + OE_ORDER_CACHE.g_header_rec.latest_schedule_limit ;
1790:
1791: RETURN l_latest_acceptable_date;

Line 1789: + OE_ORDER_CACHE.g_header_rec.latest_schedule_limit ;

1785: BEGIN
1786:
1787: OE_ORDER_CACHE.Load_Order_Header(Ont_Line_Def_Hdlr.G_Record.header_id);
1788: l_latest_acceptable_date := Ont_Line_Def_Hdlr.G_Record.request_date
1789: + OE_ORDER_CACHE.g_header_rec.latest_schedule_limit ;
1790:
1791: RETURN l_latest_acceptable_date;
1792:
1793: EXCEPTION