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:
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(
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,
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:
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(
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,
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(
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,
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,
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(
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,
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,
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:
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(
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,
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(
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,
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
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:
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(
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;
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;