3:
4: g_pkg_name constant varchar2(30) := 'cse_fa_stage_pkg';
5:
6: PROCEDURE stage_addition(
7: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
4: g_pkg_name constant varchar2(30) := 'cse_fa_stage_pkg';
5:
6: PROCEDURE stage_addition(
7: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
5:
6: PROCEDURE stage_addition(
7: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
6: PROCEDURE stage_addition(
7: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
14: PROCEDURE stage_unit_adjustment(
7: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
14: PROCEDURE stage_unit_adjustment(
15: p_trans_rec IN fa_api_types.trans_rec_type,
8: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
9: p_asset_desc_rec IN fa_api_types.asset_desc_rec_type,
10: p_asset_fin_rec IN fa_api_types.asset_fin_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
14: PROCEDURE stage_unit_adjustment(
15: p_trans_rec IN fa_api_types.trans_rec_type,
16: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
11: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type,
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
14: PROCEDURE stage_unit_adjustment(
15: p_trans_rec IN fa_api_types.trans_rec_type,
16: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
17: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
18:
19: PROCEDURE stage_adjustment(
12: p_inv_tbl IN fa_api_types.inv_tbl_type);
13:
14: PROCEDURE stage_unit_adjustment(
15: p_trans_rec IN fa_api_types.trans_rec_type,
16: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
17: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
18:
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
13:
14: PROCEDURE stage_unit_adjustment(
15: p_trans_rec IN fa_api_types.trans_rec_type,
16: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
17: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
18:
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
21: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
16: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
17: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
18:
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
21: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
22: p_asset_fin_rec_adj IN fa_api_types.asset_fin_rec_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
17: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
18:
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
21: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
22: p_asset_fin_rec_adj IN fa_api_types.asset_fin_rec_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
25: PROCEDURE stage_transfer(
18:
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
21: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
22: p_asset_fin_rec_adj IN fa_api_types.asset_fin_rec_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
25: PROCEDURE stage_transfer(
26: p_trans_rec IN fa_api_types.trans_rec_type,
19: PROCEDURE stage_adjustment(
20: p_trans_rec IN fa_api_types.trans_rec_type,
21: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
22: p_asset_fin_rec_adj IN fa_api_types.asset_fin_rec_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
25: PROCEDURE stage_transfer(
26: p_trans_rec IN fa_api_types.trans_rec_type,
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
22: p_asset_fin_rec_adj IN fa_api_types.asset_fin_rec_type,
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
25: PROCEDURE stage_transfer(
26: p_trans_rec IN fa_api_types.trans_rec_type,
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
28: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
29:
30: PROCEDURE stage_retirement(
23: p_inv_tbl IN fa_api_types.inv_tbl_type);
24:
25: PROCEDURE stage_transfer(
26: p_trans_rec IN fa_api_types.trans_rec_type,
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
28: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
29:
30: PROCEDURE stage_retirement(
31: p_asset_id IN number,
24:
25: PROCEDURE stage_transfer(
26: p_trans_rec IN fa_api_types.trans_rec_type,
27: p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
28: p_asset_dist_tbl IN fa_api_types.asset_dist_tbl_type);
29:
30: PROCEDURE stage_retirement(
31: p_asset_id IN number,
32: p_book_type_code IN varchar2,