DBA Data[Home] [Help]

PACKAGE: APPS.CSTPAPPR

Source


1 PACKAGE CSTPAPPR AS
2 /* $Header: CSTAPPRS.pls 120.2.12010000.2 2008/11/10 13:11:08 anjha ship $ */
3 
4 PROCEDURE create_acct_lines (
5         i_legal_entity          in      number,
6         i_cost_type_id          in      number,
7         i_cost_group_id         in      number,
8         i_period_id             in      number,
9         i_transaction_id        in      number,
10         i_event_type_id         in      varchar2,
11 	i_txn_type_flag         IN      VARCHAR2, --Bug 4586534
12 	o_err_num		out NOCOPY	number,
13 	o_err_code		out NOCOPY	varchar2,
14 	o_err_msg		out NOCOPY	varchar2
15 );
16 
17 
18 procedure create_rcv_ae_lines(
19   i_ae_txn_rec          IN     CSTPALTY.cst_ae_txn_rec_type,
20   o_ae_line_rec_tbl     OUT NOCOPY    CSTPALTY.cst_ae_line_tbl_type,
21   o_ae_err_rec          OUT NOCOPY    CSTPALTY.cst_ae_err_rec_type
22 ) ;
23 
24 procedure create_adj_ae_lines(
25   p_ae_txn_rec          IN     CSTPALTY.cst_ae_txn_rec_type,
26   x_ae_line_rec_tbl     OUT NOCOPY    CSTPALTY.cst_ae_line_tbl_type,
27   x_ae_err_rec          OUT NOCOPY    CSTPALTY.cst_ae_err_rec_type
28 ) ;
29 
30 PROCEDURE create_rae_ae_lines(
31   i_ae_txn_rec          IN     CSTPALTY.cst_ae_txn_rec_type,
32   o_ae_line_rec_tbl     OUT NOCOPY    CSTPALTY.cst_ae_line_tbl_type,
33   o_ae_err_rec          OUT NOCOPY    CSTPALTY.cst_ae_err_rec_type
34 );
35 PROCEDURE create_lc_adj_ae_lines(
36   p_ae_txn_rec            IN         CSTPALTY.cst_ae_txn_rec_type,
37   x_ae_line_rec_tbl       OUT NOCOPY CSTPALTY.cst_ae_line_tbl_type,
38   x_ae_err_rec            OUT NOCOPY CSTPALTY.cst_ae_err_rec_type
39 );
40 procedure create_per_end_ae_lines(
41   i_ae_txn_rec          IN     CSTPALTY.cst_ae_txn_rec_type,
42   o_ae_line_rec_tbl     OUT NOCOPY    CSTPALTY.cst_ae_line_tbl_type,
43   o_ae_err_rec          OUT NOCOPY    CSTPALTY.cst_ae_err_rec_type
44 ) ;
45 
46 PROCEDURE check_encumbrance(
47 i_transaction_id        IN      NUMBER,
48 i_set_of_books_id       IN      NUMBER,
49 i_period_name           IN      VARCHAR2,   --???
50 i_encumbrance_account_id        IN      NUMBER,
51 o_enc_flag              OUT NOCOPY     VARCHAR2,
52 o_purch_encumbrance_type_id     OUT NOCOPY     NUMBER,
53 o_purch_encumbrance_flag OUT NOCOPY     VARCHAR2,
54 o_ae_err_rec          OUT NOCOPY    CSTPALTY.cst_ae_err_rec_type
55 );
56 
57 
58 PROCEDURE insert_account(
59   i_ae_txn_rec          IN    	CSTPALTY.cst_ae_txn_rec_type,
60   i_ae_curr_rec         IN    	CSTPALTY.cst_ae_curr_rec_type,
61   i_dr_flag             IN    	BOOLEAN,
62   i_ae_line_rec         IN    	CSTPALTY.cst_ae_line_rec_type,
63   l_ae_line_tbl         IN OUT NOCOPY  CSTPALTY.cst_ae_line_tbl_type,
64   o_ae_err_rec          OUT NOCOPY   	CSTPALTY.cst_ae_err_rec_type
65 );
66 
67 FUNCTION get_net_del_qty(
68         i_po_distribution_id    IN      NUMBER,
69         i_transaction_id        IN      NUMBER)
70 RETURN NUMBER ;
71 
72 procedure balance_account (
73    l_ae_line_tbl               IN OUT NOCOPY    CSTPALTY.cst_ae_line_tbl_type,
74    o_ae_err_rec                OUT NOCOPY       CSTPALTY.cst_ae_err_rec_type
75 );
76 
77 end CSTPAPPR;