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_CREDIT_PUB dependencies on OE_ORDER_PUB

Line 9: p_header_rec IN OE_Order_PUB.Header_Rec_Type

5:
6:
7:
8: procedure chk_past_due_invoice (
9: p_header_rec IN OE_Order_PUB.Header_Rec_Type
10: ,p_credit_rule_id IN NUMBER
11: ,p_credit_level IN VARCHAR2
12: ,p_check_past_due OUT NOCOPY /* file.sql.39 change */ VARCHAR2
13: ,p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 92: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

88: an additional input parameter */
89:
90:
91: PROCEDURE Check_Trx_Limit
92: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
93: , p_credit_rule_id IN NUMBER
94: , p_trx_credit_limit IN NUMBER := FND_API.G_MISS_NUM
95: , p_total_exposure IN NUMBER
96: , p_overall_credit_limit IN NUMBER

Line 208: l_header_rec OE_Order_PUB.Header_Rec_Type;

204: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Pass or Fail Credit Check
205: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
206: )
207: IS
208: l_header_rec OE_Order_PUB.Header_Rec_Type;
209: l_credit_rule_id NUMBER;
210: l_credit_level VARCHAR2(30); -- are the limits at the customer
211: -- or site level
212: l_order_value NUMBER;

Line 397: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

393: */
394:
395:
396: PROCEDURE Check_Order
397: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
398: , p_calling_action IN VARCHAR2 := 'BOOKING'
399: , p_check_order_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2
400: , p_credit_rule_out OUT NOCOPY /* file.sql.39 change */ NUMBER
401: , p_credit_check_lvl_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 700: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

696:
697:
698:
699: PROCEDURE Check_Exposure
700: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
701: , p_credit_check_rule_id IN NUMBER
702: , p_credit_level IN VARCHAR2
703: , p_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
704: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1659: p_header_rec IN OE_Order_PUB.Header_Rec_Type

1655: END Check_Exposure;
1656:
1657: -- bug 1830389, new procedures introduced for line level credit checking.
1658: procedure chk_past_due_invoice_line (
1659: p_header_rec IN OE_Order_PUB.Header_Rec_Type
1660: ,p_invoice_to_org_id IN NUMBER
1661: ,p_customer_id IN NUMBER
1662: ,p_credit_rule_id IN NUMBER
1663: ,p_credit_level IN VARCHAR2

Line 1729: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1725: an additional input parameter */
1726:
1727:
1728: PROCEDURE Check_Trx_Limit_Line
1729: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1730: , p_invoice_to_org_id IN NUMBER
1731: , p_customer_id IN NUMBER
1732: , p_credit_rule_id IN NUMBER
1733: , p_credit_level IN VARCHAR2

Line 1874: l_header_rec OE_Order_PUB.Header_Rec_Type;

1870: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Pass or Fail Credit Check
1871: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1872: )
1873: IS
1874: l_header_rec OE_Order_PUB.Header_Rec_Type;
1875: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1876: l_credit_rule_id NUMBER;
1877: l_credit_level VARCHAR2(30); -- are the limits at the customer
1878: -- or site level

Line 1875: --l_line_rec OE_Order_PUB.Line_Rec_Type;

1871: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1872: )
1873: IS
1874: l_header_rec OE_Order_PUB.Header_Rec_Type;
1875: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1876: l_credit_rule_id NUMBER;
1877: l_credit_level VARCHAR2(30); -- are the limits at the customer
1878: -- or site level
1879: --l_order_value NUMBER;

Line 2090: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2086: */
2087:
2088:
2089: PROCEDURE Check_Order_Line
2090: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2091: , p_invoice_to_org_id IN NUMBER
2092: , p_customer_id IN NUMBER
2093: , p_calling_action IN VARCHAR2 := 'BOOKING'
2094: , p_check_Order_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2381: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2377: END Check_Order_line;
2378:
2379:
2380: PROCEDURE Check_Exposure_Line
2381: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2382: , p_invoice_to_org_id IN NUMBER
2383: , p_customer_id IN NUMBER
2384: , p_credit_check_rule_id IN NUMBER
2385: , p_credit_level IN VARCHAR2