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 682: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

678:
679:
680:
681: PROCEDURE Check_Exposure
682: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
683: , p_credit_check_rule_id IN NUMBER
684: , p_credit_level IN VARCHAR2
685: , p_total_exposure OUT NOCOPY /* file.sql.39 change */ NUMBER
686: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1641: p_header_rec IN OE_Order_PUB.Header_Rec_Type

1637: END Check_Exposure;
1638:
1639: -- bug 1830389, new procedures introduced for line level credit checking.
1640: procedure chk_past_due_invoice_line (
1641: p_header_rec IN OE_Order_PUB.Header_Rec_Type
1642: ,p_invoice_to_org_id IN NUMBER
1643: ,p_customer_id IN NUMBER
1644: ,p_credit_rule_id IN NUMBER
1645: ,p_credit_level IN VARCHAR2

Line 1711: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

1707: an additional input parameter */
1708:
1709:
1710: PROCEDURE Check_Trx_Limit_Line
1711: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
1712: , p_invoice_to_org_id IN NUMBER
1713: , p_customer_id IN NUMBER
1714: , p_credit_rule_id IN NUMBER
1715: , p_credit_level IN VARCHAR2

Line 1856: l_header_rec OE_Order_PUB.Header_Rec_Type;

1852: , p_result_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2 -- Pass or Fail Credit Check
1853: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1854: )
1855: IS
1856: l_header_rec OE_Order_PUB.Header_Rec_Type;
1857: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1858: l_credit_rule_id NUMBER;
1859: l_credit_level VARCHAR2(30); -- are the limits at the customer
1860: -- or site level

Line 1857: --l_line_rec OE_Order_PUB.Line_Rec_Type;

1853: , p_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1854: )
1855: IS
1856: l_header_rec OE_Order_PUB.Header_Rec_Type;
1857: --l_line_rec OE_Order_PUB.Line_Rec_Type;
1858: l_credit_rule_id NUMBER;
1859: l_credit_level VARCHAR2(30); -- are the limits at the customer
1860: -- or site level
1861: --l_order_value NUMBER;

Line 2072: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2068: */
2069:
2070:
2071: PROCEDURE Check_Order_Line
2072: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2073: , p_invoice_to_org_id IN NUMBER
2074: , p_customer_id IN NUMBER
2075: , p_calling_action IN VARCHAR2 := 'BOOKING'
2076: , p_check_Order_out OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 2345: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type

2341: END Check_Order_line;
2342:
2343:
2344: PROCEDURE Check_Exposure_Line
2345: ( p_header_rec IN OE_Order_PUB.Header_Rec_Type
2346: , p_invoice_to_org_id IN NUMBER
2347: , p_customer_id IN NUMBER
2348: , p_credit_check_rule_id IN NUMBER
2349: , p_credit_level IN VARCHAR2