1 PACKAGE Okl_Acc_Call_Pvt AUTHID CURRENT_USER AS
2 /* $Header: OKLRACCS.pls 120.2 2007/07/04 09:33:08 vpanwar ship $ */
3
4 SUBTYPE taiv_rec_type IS Okl_Tai_Pvt.taiv_rec_type;
5
6 --Declare id for record and table type implementations
7
8 TYPE bpd_acc_rec_type IS RECORD
9 (
10 id NUMBER := Okl_Api.G_MISS_NUM, -- Id of the table
11 source_table VARCHAR2(100) := Okl_Api.G_MISS_CHAR, -- Source Name
12 source_trx_id NUMBER := Okl_Api.G_MISS_NUM -- Id of Source Transaction
13 );
14
15 TYPE bpd_acc_tbl_type IS TABLE OF bpd_acc_rec_type
16 INDEX BY BINARY_INTEGER;
17
18 ------------------------------------------------------------------------------
19 -- Global Variables
20 ------------------------------------------------------------------------------
21
22 G_MISS_NUM CONSTANT NUMBER := Okl_Api.G_MISS_NUM;
23 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNTING_CALL_PVT';
24 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
25 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
28 ------------------------------------------------------------------------------
29 --Global Exception
30 ------------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32 ------------------------------------------------------------------------------
33
34 l_msg_data VARCHAR2(4000);
35
36 PROCEDURE Okl_Populate_Acc_Gen (
37 p_contract_id IN NUMBER DEFAULT NULL,
38 p_contract_line_id IN NUMBER DEFAULT NULL,
39 x_acc_gen_tbl OUT NOCOPY Okl_Account_Dist_Pub.acc_gen_primary_key,
40 x_return_status OUT NOCOPY VARCHAR2);
41
42 PROCEDURE create_acc_trans(
43 p_api_version IN NUMBER
44 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
45 ,x_return_status OUT NOCOPY VARCHAR2
46 ,x_msg_count OUT NOCOPY NUMBER
47 ,x_msg_data OUT NOCOPY VARCHAR2
48 ,p_bpd_acc_rec IN bpd_acc_rec_type
49 );
50
51 PROCEDURE create_acc_trans(
52 p_api_version IN NUMBER
53 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
54 ,x_return_status OUT NOCOPY VARCHAR2
55 ,x_msg_count OUT NOCOPY NUMBER
56 ,x_msg_data OUT NOCOPY VARCHAR2
57 ,p_bpd_acc_tbl IN bpd_acc_tbl_type
58 );
59
60 PROCEDURE create_acc_trans_new(
61 p_api_version IN NUMBER
62 ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
63 ,x_return_status OUT NOCOPY VARCHAR2
64 ,x_msg_count OUT NOCOPY NUMBER
65 ,x_msg_data OUT NOCOPY VARCHAR2
66 ,p_bpd_acc_rec IN bpd_acc_rec_type
67 ,x_tmpl_identify_rec OUT NOCOPY Okl_Account_Dist_Pub.TMPL_IDENTIFY_REC_TYPE
68 ,x_dist_info_rec OUT NOCOPY Okl_Account_Dist_Pub.DIST_INFO_REC_TYPE
69 ,x_ctxt_val_tbl OUT NOCOPY Okl_Account_Dist_Pub.CTXT_VAL_TBL_TYPE
70 ,x_acc_gen_primary_key_tbl OUT NOCOPY Okl_Account_Dist_Pub.ACC_GEN_PRIMARY_KEY
71 );
72
73 END Okl_Acc_Call_Pvt;