1 PACKAGE OE_BULK_PRICEORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEBVOPRS.pls 120.0.12010000.1 2008/07/25 07:44:48 appldev ship $ */
3
4
5 G_SEED_GSA_HOLD_ID CONSTANT NUMBER := 2; --bug 3716296
6
7 Procedure Insert_Adjs_From_Iface
8 (p_batch_id IN NUMBER,
9 x_return_status OUT NOCOPY VARCHAR2);
10
11 PROCEDURE Price_Orders
12 (p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE
13 , p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
14 , p_adjustments_exist VARCHAR2 --pibadj
15 , x_return_status OUT NOCOPY VARCHAR2
16 );
17
18
19 /**************************************************************************************************
20 PROCEDURE Credit_Check
21 1. OE_BULK_HEADER_UTIL.Insert_Headers will always insert booked_flag = 'N' for the header.
22 2. The g_header_rec memory always contains the correct booked_flag.
23 3. Before process acknowledgment, we call credit_check
24 4. Credit_Check will one by one loop through the G_HEADER_REC updates the db header book_flag as 'BOOKED' and then perform the credit check for each order
25 ****************************************************************************************************/
26
27 PROCEDURE Credit_Check (p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE);
28
29 Procedure set_calc_flag_incl_item(p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE
30 , p_index in Number);
31
32
33
34 Procedure set_price_flag(p_line_rec IN OUT NOCOPY OE_WSH_BULK_GRP.LINE_REC_TYPE,
35 p_index Number,
36 p_header_counter Number
37 );
38
39 Procedure set_hdr_price_flag(p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE);
40
41
42 End OE_BULK_PRICEORDER_PVT;
[Home] [Help]