eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_CIP_PUB dependencies on FA_API_TYPES

Line 10: g_log_level_rec fa_api_types.log_level_rec_type;

6: G_PKG_NAME CONSTANT varchar2(30) := 'FA_CIP_PUB';
7: G_API_NAME CONSTANT varchar2(30) := 'Capitalization/Reverse API';
8: G_API_VERSION CONSTANT number := 1.0;
9:
10: g_log_level_rec fa_api_types.log_level_rec_type;
11:
12: --*********************** Private functions ******************************--
13:
14: FUNCTION do_cap_rev

Line 24: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23:
24: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
25: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
26: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
27: p_cap_rev IN VARCHAR2
28: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

Line 25: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23:
24: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
25: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
26: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
27: p_cap_rev IN VARCHAR2
28: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
29:

Line 26: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

22: x_msg_data OUT NOCOPY VARCHAR2,
23:
24: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
25: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
26: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
27: p_cap_rev IN VARCHAR2
28: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
29:
30: -- private declaration for books (mrc) wrapper

Line 28: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

24: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
25: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
26: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
27: p_cap_rev IN VARCHAR2
28: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
29:
30: -- private declaration for books (mrc) wrapper
31:
32: FUNCTION do_all_books

Line 33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

29:
30: -- private declaration for books (mrc) wrapper
31:
32: FUNCTION do_all_books
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

30: -- private declaration for books (mrc) wrapper
31:
32: FUNCTION do_all_books
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type

Line 35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

31:
32: FUNCTION do_all_books
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

Line 36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

32: FUNCTION do_all_books
33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:

Line 37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

33: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:
41: --*********************** Public procedures ******************************--

Line 38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type

34: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:
41: --*********************** Public procedures ******************************--
42:

Line 39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;

35: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
36: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
37: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
38: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
39: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
40:
41: --*********************** Public procedures ******************************--
42:
43: PROCEDURE do_capitalization

Line 53: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

49: x_return_status OUT NOCOPY VARCHAR2,
50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,
52:
53: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
54: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
55: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
56:
57: l_cap_rev VARCHAR2(10) := 'CAPITALIZE';

Line 54: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

50: x_msg_count OUT NOCOPY NUMBER,
51: x_msg_data OUT NOCOPY VARCHAR2,
52:
53: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
54: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
55: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
56:
57: l_cap_rev VARCHAR2(10) := 'CAPITALIZE';
58: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_capitalization';

Line 55: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS

51: x_msg_data OUT NOCOPY VARCHAR2,
52:
53: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
54: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
55: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
56:
57: l_cap_rev VARCHAR2(10) := 'CAPITALIZE';
58: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_capitalization';
59: cap_err EXCEPTION;

Line 150: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

146: x_return_status OUT NOCOPY VARCHAR2,
147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149:
150: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
151: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
152: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
153:
154: l_cap_rev VARCHAR2(10) := 'REVERSE';

Line 151: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

147: x_msg_count OUT NOCOPY NUMBER,
148: x_msg_data OUT NOCOPY VARCHAR2,
149:
150: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
151: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
152: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
153:
154: l_cap_rev VARCHAR2(10) := 'REVERSE';
155: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_reverse';

Line 152: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS

148: x_msg_data OUT NOCOPY VARCHAR2,
149:
150: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
151: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
152: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type) IS
153:
154: l_cap_rev VARCHAR2(10) := 'REVERSE';
155: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_reverse';
156: rev_err EXCEPTION;

Line 250: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

246: x_return_status OUT NOCOPY VARCHAR2,
247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249:
250: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
251: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
252: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
253: p_cap_rev IN VARCHAR2
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 251: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

247: x_msg_count OUT NOCOPY NUMBER,
248: x_msg_data OUT NOCOPY VARCHAR2,
249:
250: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
251: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
252: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
253: p_cap_rev IN VARCHAR2
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
255:

Line 252: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

248: x_msg_data OUT NOCOPY VARCHAR2,
249:
250: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
251: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
252: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
253: p_cap_rev IN VARCHAR2
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
255:
256: l_reporting_flag VARCHAR2(1);

Line 254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

250: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
251: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
252: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
253: p_cap_rev IN VARCHAR2
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
255:
256: l_reporting_flag VARCHAR2(1);
257: l_count NUMBER := 0;
258:

Line 259: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

255:
256: l_reporting_flag VARCHAR2(1);
257: l_count NUMBER := 0;
258:
259: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
260: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
261: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
262:
263: -- Bug 8252607/5475276 Cursor to get the book_type_code

Line 260: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

256: l_reporting_flag VARCHAR2(1);
257: l_count NUMBER := 0;
258:
259: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
260: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
261: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
262:
263: -- Bug 8252607/5475276 Cursor to get the book_type_code
264: CURSOR c_corp_book( p_asset_id number ) IS

Line 261: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

257: l_count NUMBER := 0;
258:
259: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
260: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
261: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
262:
263: -- Bug 8252607/5475276 Cursor to get the book_type_code
264: CURSOR c_corp_book( p_asset_id number ) IS
265: SELECT bc.book_type_code

Line 274: l_trans_rec FA_API_TYPES.trans_rec_type;

270: AND bks.asset_id = p_asset_id
271: AND bks.transaction_header_id_out is null;
272:
273: -- used for tax books when doing cip-in-tax or autocopy
274: l_trans_rec FA_API_TYPES.trans_rec_type;
275: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
276: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
277: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
278: l_tax_index NUMBER; -- index for tax loop

Line 275: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

271: AND bks.transaction_header_id_out is null;
272:
273: -- used for tax books when doing cip-in-tax or autocopy
274: l_trans_rec FA_API_TYPES.trans_rec_type;
275: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
276: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
277: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
278: l_tax_index NUMBER; -- index for tax loop
279:

Line 276: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

272:
273: -- used for tax books when doing cip-in-tax or autocopy
274: l_trans_rec FA_API_TYPES.trans_rec_type;
275: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
276: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
277: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
278: l_tax_index NUMBER; -- index for tax loop
279:
280: l_calling_fn VARCHAR2(30) := 'fa_cip_pub.do_cap_rev';

Line 285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

281: cap_rev_err EXCEPTION;
282:
283: --Added following variables for bugfix# 5155488
284: l_period_of_addition_flag varchar2(1);
285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

282:
283: --Added following variables for bugfix# 5155488
284: l_period_of_addition_flag varchar2(1);
285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
290: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

283: --Added following variables for bugfix# 5155488
284: l_period_of_addition_flag varchar2(1);
285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
290: l_inv_tbl FA_API_TYPES.inv_tbl_type;
291: l_return_status VARCHAR2(1);

Line 288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

284: l_period_of_addition_flag varchar2(1);
285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
290: l_inv_tbl FA_API_TYPES.inv_tbl_type;
291: l_return_status VARCHAR2(1);
292: l_mesg_count number := 0;

Line 289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

285: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
290: l_inv_tbl FA_API_TYPES.inv_tbl_type;
291: l_return_status VARCHAR2(1);
292: l_mesg_count number := 0;
293: l_mesg_len number;

Line 290: l_inv_tbl FA_API_TYPES.inv_tbl_type;

286: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
287: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
288: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
289: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
290: l_inv_tbl FA_API_TYPES.inv_tbl_type;
291: l_return_status VARCHAR2(1);
292: l_mesg_count number := 0;
293: l_mesg_len number;
294: l_mesg varchar2(4000);

Line 684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

680:
681: -------------------------------------------------------------------------------
682:
683: FUNCTION do_all_books
684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

Line 685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

681: -------------------------------------------------------------------------------
682:
683: FUNCTION do_all_books
684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type

Line 686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

682:
683: FUNCTION do_all_books
684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

Line 687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,

683: FUNCTION do_all_books
684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:

Line 688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,

684: (px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:
692: -- used for calling private api for reporting books

Line 689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type

685: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:
692: -- used for calling private api for reporting books
693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS

686: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
687: px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
688: p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:
692: -- used for calling private api for reporting books
693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
694: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

689: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type
690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:
692: -- used for calling private api for reporting books
693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
694: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
695: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
696:
697: -- used for retrieving "new" structs from private api calls

Line 694: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

690: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
691:
692: -- used for calling private api for reporting books
693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
694: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
695: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
696:
697: -- used for retrieving "new" structs from private api calls
698: l_reporting_flag varchar2(1);

Line 695: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;

691:
692: -- used for calling private api for reporting books
693: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
694: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
695: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
696:
697: -- used for retrieving "new" structs from private api calls
698: l_reporting_flag varchar2(1);
699: l_period_rec FA_API_TYPES.period_rec_type;

Line 699: l_period_rec FA_API_TYPES.period_rec_type;

695: l_asset_fin_rec_old FA_API_TYPES.asset_fin_rec_type;
696:
697: -- used for retrieving "new" structs from private api calls
698: l_reporting_flag varchar2(1);
699: l_period_rec FA_API_TYPES.period_rec_type;
700: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
701:
702: -- used for get_rate
703: l_exchange_date date;

Line 716: l_group_trans_rec fa_api_types.trans_rec_type;

712: l_transaction_date date;
713: l_date_placed_in_service date;
714:
715: -- used for new group code
716: l_group_trans_rec fa_api_types.trans_rec_type;
717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;

Line 717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;

713: l_date_placed_in_service date;
714:
715: -- used for new group code
716: l_group_trans_rec fa_api_types.trans_rec_type;
717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;

Line 718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;

714:
715: -- used for new group code
716: l_group_trans_rec fa_api_types.trans_rec_type;
717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;

Line 719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;

715: -- used for new group code
716: l_group_trans_rec fa_api_types.trans_rec_type;
717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

Line 720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;

716: l_group_trans_rec fa_api_types.trans_rec_type;
717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;

Line 721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;

717: l_group_asset_hdr_rec fa_api_types.asset_hdr_rec_type;
718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;

Line 722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;

718: l_group_asset_desc_rec fa_api_types.asset_desc_rec_type;
719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;

Line 723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;

719: l_group_asset_type_rec fa_api_types.asset_type_rec_type;
720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;

Line 724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;

720: l_group_asset_cat_rec fa_api_types.asset_cat_rec_type;
721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;

Line 725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;

721: l_group_asset_fin_rec_old fa_api_types.asset_fin_rec_type;
722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
729:

Line 726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;

722: l_group_asset_fin_rec_adj fa_api_types.asset_fin_rec_type;
723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
729:
730: l_calling_fn varchar2(30) := 'fa_cip_pub.do_all_books';

Line 727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;

723: l_group_asset_fin_rec_new fa_api_types.asset_fin_rec_type;
724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
729:
730: l_calling_fn varchar2(30) := 'fa_cip_pub.do_all_books';
731: cap_rev_err EXCEPTION;

Line 728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;

724: l_group_asset_deprn_rec_old fa_api_types.asset_deprn_rec_type;
725: l_group_asset_deprn_rec_adj fa_api_types.asset_deprn_rec_type;
726: l_group_asset_deprn_rec_new fa_api_types.asset_deprn_rec_type;
727: l_inv_trans_rec fa_api_types.inv_trans_rec_type;
728: l_group_reclass_options_rec fa_api_types.group_reclass_options_rec_type;
729:
730: l_calling_fn varchar2(30) := 'fa_cip_pub.do_all_books';
731: cap_rev_err EXCEPTION;
732: