APPS.OE_GSA_UTIL dependencies on OE_ORDER_PUB

Line 8: g_header_rec OE_Order_PUB.Header_Rec_Type;

4: -- Global constants holding the package name.
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_GSA_UTIL';
7:
8: g_header_rec OE_Order_PUB.Header_Rec_Type;
9:
10:
11: FUNCTION Check_GSA_Main
12: (p_line_rec IN OE_Order_Pub.Line_Rec_Type,

Line 12: (p_line_rec IN OE_Order_Pub.Line_Rec_Type,

8: g_header_rec OE_Order_PUB.Header_Rec_Type;
9:
10:
11: FUNCTION Check_GSA_Main
12: (p_line_rec IN OE_Order_Pub.Line_Rec_Type,
13: x_resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2) RETURN VARCHAR2
14: IS
15: l_gsa_enabled_flag VARCHAR2(1):= 'N';
16: l_gsa_indicator_flag VARCHAR2(1):= 'N';

Line 92: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2

88: end Check_GSA_Main;
89:
90:
91: FUNCTION Check_GSA_Enabled
92: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2
93: IS
94: l_profile_option_value VARCHAR2(1):= 'N';
95: --
96: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 133: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2

129:
130: END Check_GSA_Enabled;
131:
132: FUNCTION Check_GSA_Indicator
133: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2
134: IS
135: l_invoice_to_org_id NUMBER;
136: l_site_use_id NUMBER;
137: l_customer_id NUMBER;

Line 250: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2

246: -- Function which checks if any GSA customer has got more price for
247: -- the item as compared to the NonGSA customer's price .
248:
249: FUNCTION Check_NonGSA_Customer
250: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2
251: IS
252: l_gsa_count NUMBER := 0;
253: l_gsa_passed_flag VARCHAR2(1) := 'Y';
254:

Line 285: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN NUMBER

281: END Check_NONGSA_CUSTOMER;
282:
283:
284: FUNCTION Get_GSA_Count
285: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN NUMBER
286: IS
287:
288: --PERFORMANCE no use
289:

Line 374: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2

370: --Function which checks if any NonGSA customer has got less price for
371: -- the item as compared to the GSA customer's price .
372:
373: FUNCTION Check_GSA_CUSTOMER
374: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN VARCHAR2
375: IS
376: l_nongsa_count NUMBER := 0;
377: l_gsa_passed_flag VARCHAR2(1) := 'Y';
378:

Line 398: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN NUMBER

394: END Check_GSA_Customer;
395:
396:
397: FUNCTION Get_NonGSA_Count
398: (p_line_rec IN OE_Order_Pub.Line_Rec_Type) RETURN NUMBER
399: IS
400: l_nongsa_count NUMBER := 0;
401: l_header_id NUMBER := 0;
402: l_inventory_item_id NUMBER;

Line 516: (p_line_rec IN OE_Order_Pub.Line_Rec_Type,

512: END Get_Source_id;
513:
514:
515: FUNCTION Release_Hold
516: (p_line_rec IN OE_Order_Pub.Line_Rec_Type,
517: x_resultout IN OUT NOCOPY /* file.sql.39 change */ VARCHAR2) RETURN VARCHAR2
518: IS
519: l_header_id NUMBER := 0;
520: l_hold_release_id NUMBER := 0;