1 PACKAGE gme_incremental_backflush_pvt AS
2 /* $Header: GMEVIBFS.pls 120.3 2005/12/22 05:44:17 svgonugu noship $ */
3
4 PROCEDURE incremental_backflush
5 (p_batch_header_rec IN GME_BATCH_HEADER%ROWTYPE
6 ,p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
7 ,p_qty IN NUMBER
8 ,p_qty_type IN NUMBER
9 ,p_trans_date IN DATE
10 ,p_backflush_rsrc_usg_ind IN NUMBER
11 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
12 ,x_return_status OUT NOCOPY VARCHAR2);
13
14 PROCEDURE derive_factor
15 (p_material_detail_rec IN gme_material_details%ROWTYPE
16 ,p_qty IN NUMBER
17 ,p_qty_type IN NUMBER
18 --FPBug#4667093
19 ,p_gme_ib_factor IN NUMBER DEFAULT 0
20 ,x_pct_plan OUT NOCOPY NUMBER
21 ,x_pct_plan_res OUT NOCOPY NUMBER
22 ,x_return_status OUT NOCOPY VARCHAR2);
23
24 PROCEDURE update_dependent_steps(p_batchstep_id IN NUMBER
25 ,p_backflush_factor IN NUMBER
26 ,x_return_status OUT NOCOPY VARCHAR2);
27
28 PROCEDURE revert_material_partial
29 (p_material_detail_rec IN gme_material_details%ROWTYPE
30 ,p_qty IN NUMBER
31 ,p_lot_control_code IN NUMBER -- 1 = not lot control; 2 = lot control
32 ,p_create_resv_pend_lots IN NUMBER
33 ,p_lot_divisible_flag IN VARCHAR2
34 ,x_actual_qty OUT NOCOPY NUMBER
35 ,x_exception_material_tbl IN OUT NOCOPY gme_common_pvt.exceptions_tab
36 ,x_return_status OUT NOCOPY VARCHAR2);
37
38 PROCEDURE validate_material_for_IB(p_material_detail_rec IN gme_material_details%ROWTYPE
39 ,p_batch_header_rec IN gme_batch_header%ROWTYPE
40 ,p_adjust_cmplt IN VARCHAR2
41 ,x_return_status OUT NOCOPY VARCHAR2);
42
43 PROCEDURE validate_qty_for_IB (p_qty_type IN NUMBER
44 ,p_qty IN NUMBER
45 ,p_actual_qty IN NUMBER
46 ,x_return_status OUT NOCOPY VARCHAR2);
47
48 PROCEDURE get_converted_qty (
49 p_org_id IN NUMBER
50 ,p_item_id IN NUMBER
51 ,p_lot_number IN VARCHAR2 DEFAULT NULL
52 ,p_qty IN NUMBER
53 ,p_from_um IN VARCHAR2
54 ,p_to_um IN VARCHAR2
55 ,x_conv_qty OUT NOCOPY NUMBER
56 ,x_return_status OUT NOCOPY VARCHAR2);
57
58 END gme_incremental_backflush_pvt;