1 package jai_cmn_bond_register_pkg AUTHID CURRENT_USER as
2 /* $Header: jai_cmn_bond_reg.pls 120.1 2005/07/20 12:57:04 avallabh ship $ */
3
4
5 /*--------------------------------------------------------------------------------------------------
6 Change History :
7
8 SlNo Date Details
9
10 1. 22-aug-03 Ssumaith (bug # 3021588) Version 616.1
11
12 This package has been created by sriram. It is to be used for all business validations
13 that require Bond Register information such as bond number , expiry date , register balance
14
15 Get_register_id procedure returns the relevant register id irrespective of whether the register
16 is a bond register or not. where ever you need to get the register id based on the parameters,
17 should issue a call to this procedure and not use a cursor directly.
18
19 get_register_details procedure returns bond specific details of a passed register id such as
20 bond number , validity date , letter of undertaking flag set
21
22 This fix has introduced huge dependency.
23 This bug is a prerequisite for all fixes made on this object
24
25
26 2. 12-nov-03 ssumaith file version 617.1 bug # 3021588
27
28 The length of the comment line was 258 lines,which was causing a problem when mrc program is run.
29 all the comment lines and code lines are now ensured to fit within the screen length in
30 order to ensure no further error occurs because of this.
31
32
33 3. 08-Jun-2005 Version 116.1 jai_cmn_bond_reg -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
34 as required for CASE COMPLAINCE.
35
36
37 Future Dependencies For the release Of this Object:-
38 ------------------------------------------------------------------------------------------------------------------------
39 (Please add a row in the section below only if your bug introduces a dependency due to spec change.
40 A new call to a object/ A datamodel change )
41
42 ------------------------------------------------------------------------------------------------------------------------
43
44 Current Version Current Bug Dependent Files Version Author Date Remarks
45 Of File On Bug/Patchset Dependent On
46 jai_cmn_bond_register_pkg.sql
47 ------------------------------------------------------------------------------------------------------------------------
48 616.1 3021588 IN60104D + ssumaith 22/08/2003 Bond Register Enhancement
49 2801751 +
50 2769440
51
52
53
54 ------------------------------------------------------------------------------------------------------------------------
55 ---------------------------------------------------------------------------------------------------*/
56
57 /*
58 This procedure is used to return the register id and register code applicable for the passed
59 organization id , location id , order or invoice type id , order or invoice type
60 */
61 procedure get_register_id(p_organization_id Number ,
62 p_location_id Number ,
63 p_order_invoice_id Number ,
64 p_order_invoice_type varchar2 , -- ( 'Y' means order , 'N' means invoice)
65 p_register_id OUT NOCOPY Number ,
66 p_register_code OUT NOCOPY varchar2);
67
68 /*
69 This procedure returns the bond register balance , register expiry date and whether the register is a letter of undertaking .
70 It is assumed that this procedure is called by passing a register id which is of bond register type.
71 */
72
73 procedure get_register_details(p_register_id in number,
74 p_register_balance OUT NOCOPY number,
75 p_register_expiry_date OUT NOCOPY date,
76 p_lou_flag OUT NOCOPY varchar2);
77
78 end jai_cmn_bond_register_pkg ;