[Home] [Help]
PACKAGE: APPS.OKL_ACCOUNT_DIST_PUB
Source
1 PACKAGE OKL_ACCOUNT_DIST_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKLPTDTS.pls 115.6 2003/07/24 00:37:19 santonyr noship $ */
3
4 SUBTYPE ctxt_val_tbl_type IS Okl_Account_Dist_Pvt.CTXT_VAL_TBL_TYPE;
5
6 SUBTYPE tmpl_identify_rec_type IS Okl_Account_Dist_Pvt.TMPL_IDENTIFY_REC_TYPE;
7 SUBTYPE dist_info_rec_type IS Okl_Account_Dist_Pvt.dist_info_REC_TYPE;
8 SUBTYPE amount_tbl_type IS Okl_Account_Dist_Pvt.AMOUNT_TBL_TYPE;
9
10 SUBTYPE tabv_rec_type IS Okl_Trns_Acc_Dstrs_Pub.tabv_rec_type;
11 SUBTYPE tabv_tbl_type IS Okl_Trns_Acc_Dstrs_Pub.tabv_tbl_type;
12
13 SUBTYPE avlv_rec_type IS OKL_TMPT_SET_PUB.avlv_rec_type;
14 SUBTYPE avlv_tbl_type IS OKL_TMPT_SET_PUB.avlv_tbl_type;
15
16 SUBTYPE acc_gen_primary_key IS Okl_Account_Generator_Pub.primary_key_tbl;
17
18
19 PROCEDURE CREATE_ACCOUNTING_DIST(p_api_version IN NUMBER,
20 p_init_msg_list IN VARCHAR2,
21 x_return_status OUT NOCOPY VARCHAR2,
22 x_msg_count OUT NOCOPY NUMBER,
23 x_msg_data OUT NOCOPY VARCHAR2,
24 p_tmpl_identify_rec IN TMPL_IDENTIFY_REC_TYPE,
25 p_dist_info_rec IN dist_info_REC_TYPE,
26 p_ctxt_val_tbl IN CTXT_VAL_TBL_TYPE,
27 p_acc_gen_primary_key_tbl IN acc_gen_primary_key,
28 x_template_tbl OUT NOCOPY AVLV_TBL_TYPE,
29 x_amount_tbl OUT NOCOPY AMOUNT_TBL_TYPE);
30
31 PROCEDURE CREATE_ACCOUNTING_DIST(p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_tmpl_identify_rec IN TMPL_IDENTIFY_REC_TYPE,
37 p_dist_info_rec IN dist_info_REC_TYPE,
38 p_ctxt_val_tbl IN CTXT_VAL_TBL_TYPE,
39 p_acc_gen_primary_key_tbl IN acc_gen_primary_key,
40 x_template_tbl OUT NOCOPY AVLV_TBL_TYPE,
41 x_amount_tbl OUT NOCOPY AMOUNT_TBL_TYPE,
42 x_gl_date OUT NOCOPY DATE);
43
44 PROCEDURE GET_TEMPLATE_INFO(p_api_version IN NUMBER,
45 p_init_msg_list IN VARCHAR2,
46 x_return_status OUT NOCOPY VARCHAR2,
47 x_msg_count OUT NOCOPY NUMBER,
48 x_msg_data OUT NOCOPY VARCHAR2,
49 p_tmpl_identify_rec IN TMPL_IDENTIFY_REC_TYPE,
50 x_template_tbl OUT NOCOPY AVLV_TBL_TYPE,
51 p_validity_date IN DATE DEFAULT sysdate);
52
53
54
55 PROCEDURE UPDATE_POST_TO_GL(p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 x_return_status OUT NOCOPY VARCHAR2,
58 x_msg_count OUT NOCOPY NUMBER,
59 x_msg_data OUT NOCOPY VARCHAR2,
60 p_source_id IN NUMBER,
61 p_source_table IN VARCHAR2);
62
63 PROCEDURE DELETE_ACCT_ENTRIES(p_api_version IN NUMBER,
64 p_init_msg_list IN VARCHAR2,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2,
68 p_source_id IN NUMBER,
69 p_source_table IN VARCHAR2);
70
71
72 PROCEDURE REVERSE_ENTRIES(p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_source_id IN NUMBER,
78 p_source_table IN VARCHAR2,
79 p_acct_date IN DATE);
80
81
82 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_ACCOUNT_DIST_PUB';
83 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
84
85
86 END OKL_ACCOUNT_DIST_PUB;