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

Line 740: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;

736: X_db_sequence_name VARCHAR2(50);
737: X_set_Of_Books_id NUMBER;
738: seqassid integer;
739: x_Trx_Date DATE;
740: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
741: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
742:
743: l_dummy VARCHAR2(80);
744: BEGIN

Line 741: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

737: X_set_Of_Books_id NUMBER;
738: seqassid integer;
739: x_Trx_Date DATE;
740: l_order_type_rec OE_Order_Cache.Order_Type_Rec_Type;
741: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
742:
743: l_dummy VARCHAR2(80);
744: BEGIN
745:

Line 753: l_order_type_rec := OE_ORDER_CACHE.Load_Order_Type(p_order_type_id);

749: RETURN TRUE;
750: END IF;
751:
752: --changes for bug 4200055
753: l_order_type_rec := OE_ORDER_CACHE.Load_Order_Type(p_order_type_id);
754: IF l_order_type_rec.order_type_id <> FND_API.G_MISS_NUM
755: and l_order_type_rec.order_type_id IS NOT NULL
756: and l_order_type_rec.order_type_id = p_order_type_id
757: THEN

Line 829: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;

825: X_db_sequence_name VARCHAR2(50);
826: X_set_Of_Books_id NUMBER;
827: seqassid integer;
828: x_Trx_Date DATE;
829: l_set_of_books_rec OE_Order_Cache.Set_Of_Books_Rec_Type;
830: l_dummy VARCHAR2(10);
831: t VARCHAR2(1);
832: BEGIN
833:

Line 841: OE_Order_Cache.Load_Set_Of_Books;

837:
838: RETURN TRUE;
839: END IF;
840: /* l_set_of_books_rec :=
841: OE_Order_Cache.Load_Set_Of_Books;
842: x_Set_Of_Books_Id := l_set_of_books_rec.set_of_books_id;
843: X_Doc_Category_Code := to_char(p_order_type_id);
844: IF (p_order_type_id = 1000) OR
845: (p_order_type_id = 1026) THEN

Line 1550: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type := OE_ORDER_CACHE.g_price_list_rec ; -- add for bug 4200055

1546: FUNCTION Price_List ( p_price_list_id IN NUMBER )
1547: RETURN BOOLEAN
1548: IS
1549: l_dummy VARCHAR2(10);
1550: l_price_list_rec OE_ORDER_CACHE.Price_List_Rec_Type := OE_ORDER_CACHE.g_price_list_rec ; -- add for bug 4200055
1551: BEGIN
1552: IF p_price_list_id IS NULL OR
1553: p_price_list_id = FND_API.G_MISS_NUM
1554: THEN

Line 1560: IF ( OE_ORDER_CACHE.g_price_list_rec.price_list_id = FND_API.G_MISS_NUM

1556: RETURN TRUE;
1557: END IF;
1558:
1559: -- added for bug 4200055
1560: IF ( OE_ORDER_CACHE.g_price_list_rec.price_list_id = FND_API.G_MISS_NUM
1561: OR OE_ORDER_CACHE.g_price_list_rec.price_list_id <> p_price_list_id ) THEN
1562: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_price_list_id) ;
1563: END IF ;
1564:

Line 1561: OR OE_ORDER_CACHE.g_price_list_rec.price_list_id <> p_price_list_id ) THEN

1557: END IF;
1558:
1559: -- added for bug 4200055
1560: IF ( OE_ORDER_CACHE.g_price_list_rec.price_list_id = FND_API.G_MISS_NUM
1561: OR OE_ORDER_CACHE.g_price_list_rec.price_list_id <> p_price_list_id ) THEN
1562: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_price_list_id) ;
1563: END IF ;
1564:
1565: IF ( l_price_list_rec.price_list_id <> FND_API.G_MISS_NUM

Line 1562: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_price_list_id) ;

1558:
1559: -- added for bug 4200055
1560: IF ( OE_ORDER_CACHE.g_price_list_rec.price_list_id = FND_API.G_MISS_NUM
1561: OR OE_ORDER_CACHE.g_price_list_rec.price_list_id <> p_price_list_id ) THEN
1562: l_price_list_rec := OE_ORDER_CACHE.Load_Price_List(p_price_list_id) ;
1563: END IF ;
1564:
1565: IF ( l_price_list_rec.price_list_id <> FND_API.G_MISS_NUM
1566: AND l_price_list_rec.price_list_id IS NOT NULL

Line 2962: l_payment_term_rec OE_ORDER_CACHE.Payment_Term_Rec_Type ; -- add for bug 4200055

2958: FUNCTION Payment_Term ( p_payment_term_id IN NUMBER )
2959: RETURN BOOLEAN
2960: IS
2961: l_dummy VARCHAR2(10);
2962: l_payment_term_rec OE_ORDER_CACHE.Payment_Term_Rec_Type ; -- add for bug 4200055
2963: BEGIN
2964:
2965:
2966: IF p_payment_term_id IS NULL OR

Line 2974: l_payment_term_rec := OE_Order_Cache.Load_Payment_Term(p_payment_term_id);

2970: RETURN TRUE;
2971: END IF;
2972:
2973: -- added for bug 4200055
2974: l_payment_term_rec := OE_Order_Cache.Load_Payment_Term(p_payment_term_id);
2975: IF ( l_payment_term_rec.term_id <> FND_API.G_MISS_NUM AND
2976: l_payment_term_rec.term_id is not null AND
2977: l_payment_term_rec.term_id = p_payment_term_id ) THEN
2978:

Line 3962: l_invoice_to_rec OE_ORDER_CACHE.Invoice_to_Org_Rec_Type ; -- add for bug 4200055

3958: FUNCTION Invoice_To_Org ( p_invoice_to_org_id IN NUMBER )
3959: RETURN BOOLEAN
3960: IS
3961: l_dummy VARCHAR2(10);
3962: l_invoice_to_rec OE_ORDER_CACHE.Invoice_to_Org_Rec_Type ; -- add for bug 4200055
3963: BEGIN
3964:
3965:
3966: IF p_invoice_to_org_id IS NULL OR

Line 3974: l_invoice_to_rec := OE_ORDER_CACHE.Load_Invoice_To_Org(p_invoice_to_org_id);

3970: RETURN TRUE;
3971: END IF;
3972:
3973: --added for bug 4200055
3974: l_invoice_to_rec := OE_ORDER_CACHE.Load_Invoice_To_Org(p_invoice_to_org_id);
3975: IF ( l_invoice_to_rec.org_id <> FND_API.G_MISS_NUM
3976: AND l_invoice_to_rec.org_id IS NOT NULL
3977: AND l_invoice_to_rec.org_id = p_invoice_to_org_id ) THEN
3978: if ( l_invoice_to_rec.status = 'A'

Line 5988: l_salesrep_rec_type OE_Order_Cache.Salesrep_Rec_type ; -- add for bug 4200055

5984: IS
5985: l_dummy VARCHAR2(10);
5986: l_is_salesrep_active VARCHAR2(10);
5987: l_org_id NUMBER;
5988: l_salesrep_rec_type OE_Order_Cache.Salesrep_Rec_type ; -- add for bug 4200055
5989:
5990: -- comment out for bug 4200055
5991: /*cursor c_salesrep( p_salesrep_id IN number) is
5992: select 'VALID'

Line 6028: l_salesrep_rec_type := OE_Order_Cache.Load_Salesrep_Rec(p_salesrep_id);

6024: oe_debug_pub.add('OEXSVATB: p_salesrep_id- '||p_salesrep_id);
6025: end if;
6026:
6027: --added for bug 4200055
6028: l_salesrep_rec_type := OE_Order_Cache.Load_Salesrep_Rec(p_salesrep_id);
6029: IF (l_salesrep_rec_type.salesrep_id is not null
6030: AND l_salesrep_rec_type.salesrep_id = p_salesrep_id ) THEN
6031: if nvl(l_salesrep_rec_type.start_date_active,trunc(sysdate)) <= trunc(sysdate) --12675100, added trunc on sysdate
6032: and nvl(l_salesrep_rec_type.end_date_active,trunc(sysdate)) >= trunc(sysdate) --12675100, added trunc on sysdate

Line 6299: IF (OE_Order_Cache.g_line_type_rec.line_type_id = FND_API.G_MISS_NUM)

6295: RETURN TRUE;
6296: END IF;
6297:
6298: --changes for bug 4200055
6299: IF (OE_Order_Cache.g_line_type_rec.line_type_id = FND_API.G_MISS_NUM)
6300: OR (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_type_id) THEN
6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;
6302: END IF ;
6303:

Line 6300: OR (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_type_id) THEN

6296: END IF;
6297:
6298: --changes for bug 4200055
6299: IF (OE_Order_Cache.g_line_type_rec.line_type_id = FND_API.G_MISS_NUM)
6300: OR (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_type_id) THEN
6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;
6302: END IF ;
6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)

Line 6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;

6297:
6298: --changes for bug 4200055
6299: IF (OE_Order_Cache.g_line_type_rec.line_type_id = FND_API.G_MISS_NUM)
6300: OR (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_type_id) THEN
6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;
6302: END IF ;
6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )

Line 6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)

6300: OR (OE_Order_Cache.g_line_type_rec.line_type_id <> p_line_type_id) THEN
6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;
6302: END IF ;
6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )
6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN
6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))
6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))

Line 6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )

6301: OE_Order_Cache.Load_Line_type(p_line_type_id) ;
6302: END IF ;
6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )
6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN
6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))
6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))
6309: ) then

Line 6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN

6302: END IF ;
6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )
6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN
6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))
6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))
6309: ) then
6310: RETURN TRUE ;

Line 6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))

6303:
6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )
6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN
6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))
6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))
6309: ) then
6310: RETURN TRUE ;
6311: else

Line 6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))

6304: IF (OE_Order_Cache.g_line_type_rec.line_type_id <> FND_API.G_MISS_NUM)
6305: AND (OE_Order_Cache.g_line_type_rec.line_type_id IS NOT NULL )
6306: AND (OE_Order_Cache.g_line_type_rec.line_type_id = p_line_type_id) THEN
6307: if ( (nvl(OE_Order_Cache.g_line_type_rec.Start_Date_Active,trunc(sysdate)) <= trunc(sysdate))
6308: and (nvl(OE_Order_Cache.g_line_type_rec.End_Date_Active,trunc(sysdate)) >= trunc(sysdate))
6309: ) then
6310: RETURN TRUE ;
6311: else
6312: RAISE NO_DATA_FOUND ;