1 Package OKL_ACTIVATE_IB_PVT AS
2 /* $Header: OKLRAIBS.pls 120.3 2006/05/12 22:29:21 rpillay noship $ */
3 -- simple entity object subtype definitions
4 subtype iipv_rec_type is okl_txl_itm_insts_pub.iipv_rec_type;
5 subtype iipv_tbl_type is okl_txl_itm_insts_pub.iipv_tbl_type;
6 subtype inst_rec_type is CSI_DATASTRUCTURES_PUB.instance_rec;
7 subtype ext_attrib_tbl_type is CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
8 subtype trx_rec_type is CSI_DATASTRUCTURES_PUB.transaction_rec;
9 subtype party_tbl_type is CSI_DATASTRUCTURES_PUB.party_tbl;
10 subtype party_account_tbl_type is CSI_DATASTRUCTURES_PUB.party_account_tbl;
11 subtype pricing_attribs_tbl_type is CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
12 subtype org_units_tbl_type is CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13 subtype instance_asset_tbl_type is CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
14 subtype cimv_rec_type is okl_okc_migration_pvt.cimv_rec_type;
15 subtype cimv_tbl_type is okl_okc_migration_pvt.cimv_tbl_type;
16
17 ---------------------------------------------------------------------------
18 -- GLOBAL MESSAGE CONSTANTS
19 ---------------------------------------------------------------------------
20 G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
21 ---------------------------------------------------------------------------
22 -- GLOBAL VARIABLES
23 ---------------------------------------------------------------------------
24 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACTIVATE_IB_PVT';
25 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
26 ---------------------------------------------------------------------------
27 -- Procedures and Functions
28 ---------------------------------------------------------------------------
29 PROCEDURE qc;
30 PROCEDURE api_copy;
31 --------------------------------------------------------------------------------
32 --Start of Comments
33 --API Name : Activate_Ib_Instance
34 --Description : API to activate item instances in Install Base for
35 -- an OKL contract
36 --Notes : IN Parameters
37 -- p_chrv_id - contract header id of the contract being activated
38 -- p_call_mode - 'BOOK' for booking
39 -- - 'REBOOK' for re-booking
40 -- -'RELEASE' for re-lease
41 -- right now this has no function it is supposed to
42 -- take care of branching of logic for different
43 -- processes in future
44 -- End of comments
45 --------------------------------------------------------------------------------
46 Procedure ACTIVATE_IB_INSTANCE(p_api_version IN NUMBER,
47 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2,
51 p_chrv_id IN NUMBER,
52 p_call_mode IN VARCHAR2,
53 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
54 ------------------------------------------------------------------------------
55 --Start of comments
56 --
57 --API Name : ACTIVATE_RBK_IB_INST
58 --Purpose : Calls IB API to create an item instance in IB
59 -- Selects ib instance to create given a top line
60 -- for a new line created during rebook
61 --Modification History :
62 --01-May-2002 avsingh Created
63 --Notes : Assigns values to transaction_type_id and source_line_ref_id
64 --End of Comments
65 ------------------------------------------------------------------------------
66 Procedure ACTIVATE_RBK_IB_INST(p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_fin_ast_cle_id IN NUMBER,
72 x_cimv_tbl OUT NOCOPY cimv_tbl_type);
73 --Bug# 3533936
74 ------------------------------------------------------------------------------
75 --Start of comments
76 --
77 --API Name : RELEASE_IB_INSTANCE
78 --Purpose : Calls IB API to modify item instance in IB
79 -- during re-lease asset
80 --Modification History :
81 --05-APR-2004 avsingh Created
82 --Notes : Assigns values to transaction_type_id and source_line_ref_id
83 --End of Comments
84 ------------------------------------------------------------------------------
85 PROCEDURE RELEASE_IB_INSTANCE
86 (p_api_version IN NUMBER,
87 p_init_msg_list IN VARCHAR2,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 p_rel_chr_id IN NUMBER
92 );
93
94 --Bug# 5207066
95 PROCEDURE RBK_SRL_NUM_IB_INSTANCE
96 (p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_rbk_fin_ast_cle_id IN NUMBER,
102 p_rbk_chr_id IN NUMBER
103 );
104
105 End OKL_ACTIVATE_IB_PVT;