1 PACKAGE PJM_UEFF_ONHAND AUTHID CURRENT_USER AS
2 /* $Header: PJMUEOHS.pls 115.9 2003/01/28 23:41:52 alaw ship $ */
3 --
4 -- Name : Onhand_Quantity
5 -- Pre-reqs : None
6 -- Function : This function returns onhand quantity for a specific
7 -- unit number and item/org/rev/subinv/locator/lot that
8 -- matches the unit number on the OE line
9 --
10 --
11 -- Parameters :
12 -- IN : X_source_line NUMBER
13 -- X_item_id NUMBER
14 -- X_organization_id NUMBER
15 -- X_revision VARCHAR2
16 -- X_subinventory VARCHAR2
17 -- X_locator_id NUMBER
18 -- X_lot_number VARCHAR2
19 -- X_lpn_id NUMBER BUG 2752979
20 -- X_cost_group_id NUMBER BUG 2752979
21 --
22 --
23 -- Returns : NUMBER
24 --
25 FUNCTION Onhand_Quantity
26 ( X_source_line IN NUMBER
27 , X_item_id IN NUMBER
28 , X_organization_id IN NUMBER
29 , X_revision IN VARCHAR2
30 , X_subinventory IN VARCHAR2
31 , X_locator_id IN NUMBER
32 , X_lot_number IN VARCHAR2
33 , X_lpn_id IN NUMBER DEFAULT NULL
34 , X_cost_group_id IN NUMBER DEFAULT NULL
35 ) RETURN NUMBER;
36 -- PRAGMA RESTRICT_REFERENCES (Onhand_Quantity, WNDS, WNPS);
37
38
39 --
40 -- Name : Txn_Quantity
41 -- Pre-reqs : None
42 -- Function : This function returns transaction quantity for a specific
43 -- transaction that matches the unit number on the OE line
44 --
45 --
46 -- Parameters :
47 -- IN : X_source_line NUMBER
48 -- X_trx_temp_id NUMBER
49 -- X_lot_number VARCHAR2
50 --
51 -- Returns : NUMBER
52 --
53 FUNCTION Txn_Quantity
54 ( X_source_line IN NUMBER
55 , X_trx_temp_id IN NUMBER
56 , X_lot_number IN VARCHAR2
57 , X_Fetch_From_DB IN VARCHAR2 DEFAULT 'Y'
58 , X_item_id IN NUMBER DEFAULT NULL
59 , X_organization_id IN NUMBER DEFAULT NULL
60 , X_src_type_id IN NUMBER DEFAULT NULL
61 , X_trx_src_id IN NUMBER DEFAULT NULL
62 , X_rcv_trx_id IN NUMBER DEFAULT NULL
63 , X_trx_sign IN NUMBER DEFAULT NULL
64 , X_trx_src_line_id IN NUMBER DEFAULT NULL
65 ) RETURN NUMBER;
66 -- PRAGMA RESTRICT_REFERENCES (Txn_Quantity, WNDS, WNPS);
67
68
69 END;