1 PACKAGE PJM_BORROW_PAYBACK AUTHID CURRENT_USER AS
2 /* $Header: PJMBWPYS.pls 115.9 2002/10/29 20:13:43 alaw ship $ */
3
4 --
5 -- Name : Set_Bucket_Size
6 -- Pre-reqs : None
7 -- Function : This procedure sets the global variable
8 -- G_Bucket_Size
9 --
10 --
11 -- Parameters :
12 -- IN : X_Bucket_Size NUMBER
13 --
14 -- Returns : None
15 --
16 PROCEDURE Set_Bucket_Size
17 ( X_Bucket_Size IN NUMBER
18 );
19
20
21 --
22 -- Name : Bucket_Size
23 -- Pre-reqs : None
24 -- Function : This procedure gets the value in global variable
25 -- G_Bucket_Size
26 --
27 --
28 -- Parameters :
29 -- IN : None
30 --
31 -- Returns : VARCHAR2
32 --
33 FUNCTION Bucket_Size
34 RETURN NUMBER;
35 PRAGMA RESTRICT_REFERENCES (Bucket_Size, WNDS, WNPS);
36
37
38 --
39 -- Name : Validate_Trx
40 -- Pre-reqs : None
41 -- Function : This function validates a transaction in the context of
42 -- borrow/payback and project transfer
43 --
44 --
45 -- Parameters :
46 -- IN : X_trx_type_id NUMBER
47 -- X_trx_action_id NUMBER
48 -- X_organization_id NUMBER
49 -- X_item_id NUMBER
50 -- X_from_subinventory VARCHAR2
51 -- X_from_locator_id NUMBER
52 -- X_to_subinventory VARCHAR2
53 -- X_to_locator_id NUMBER
54 -- X_primary_quantity NUMBER
55 -- X_transaction_date DATE
56 -- X_payback_date DATE
57 --
58 -- OUT : X_error_code VARCHAR2
59 --
60 -- Returns : Number
61 --
62 FUNCTION VALIDATE_TRX(X_Transaction_Type_Id IN NUMBER,
63 X_Transaction_Action_Id IN NUMBER,
64 X_Organization_Id IN NUMBER,
65 X_From_SubInventory IN VARCHAR2,
66 X_From_Locator_Id IN NUMBER,
67 X_To_Subinventory IN VARCHAR2,
68 X_To_Locator_Id IN NUMBER,
69 X_Inventory_Item_Id IN NUMBER,
70 X_Revision IN VARCHAR2,
71 X_Primary_Quantity IN NUMBER,
72 X_Transaction_Date IN DATE,
73 X_Payback_Date IN DATE,
74 X_Error_Code OUT NOCOPY VARCHAR2) RETURN NUMBER;
75
76 --
77 -- Name : Trx_Callback
78 -- Pre-reqs : Non
79 -- Function : This function performs the following tasks:
80 -- 1) for a borrow transaction, it inserts a record
81 -- into PJM_BORROW_TRANSACTIONS
82 --
83 -- 2) for a payback transaction, it allocates the
84 -- payback quantity to borrow transactions and
85 -- insert the results in PJM_BORROW_PAYBACKS
86 --
87 --
88 -- Parameters :
89 -- IN : X_transaction_id NUMBER
90 -- X_transaction_temp_id NUMBER
91 --
92 -- OUT : X_error_code VARCHAR2
93 --
94 -- Returns : Boolean
95 --
96 FUNCTION Trx_Callback
97 ( X_transaction_id IN NUMBER
98 , X_transaction_temp_id IN NUMBER
99 , X_error_code OUT NOCOPY VARCHAR2
100 ) RETURN BOOLEAN;
101
102
103 END;