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_RETIREMENT_PUB dependencies on FA_API_TYPES

Line 9: g_log_level_rec fa_api_types.log_level_rec_type;

5: G_PKG_NAME CONSTANT varchar2(30) := 'FA_RETIREMENT_PUB';
6: G_API_NAME CONSTANT varchar2(30) := 'Retirement API';
7: G_API_VERSION CONSTANT number := 1.0;
8:
9: g_log_level_rec fa_api_types.log_level_rec_type;
10:
11: g_release number := fa_cache_pkg.fazarel_release;
12:
13: -- l_calling_fn VARCHAR2(100) := 'FA_RETIREMENT_PUB';

Line 35: * g_inv_trans_rec to pass FA_API_TYPES.inv_trans_rec

31: g_value2 varchar2(80) := null;
32:
33: /*
34: * Added for Group Asset uptake
35: * g_inv_trans_rec to pass FA_API_TYPES.inv_trans_rec
36: * when calling FA_GROUP_RETIREMENT_PVT.DO_RETIREMENT
37: * This is necessary without passing this value from
38: * Do_Retirement to do_sub_regular_retirement
39: */

Line 40: g_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

36: * when calling FA_GROUP_RETIREMENT_PVT.DO_RETIREMENT
37: * This is necessary without passing this value from
38: * Do_Retirement to do_sub_regular_retirement
39: */
40: g_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
41: /*** End uptake ***/
42:
43: FUNCTION do_all_books_retirement
44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

Line 44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

40: g_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
41: /*** End uptake ***/
42:
43: FUNCTION do_all_books_retirement
44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

Line 45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

41: /*** End uptake ***/
42:
43: FUNCTION do_all_books_retirement
44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

42:
43: FUNCTION do_all_books_retirement
44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

43: FUNCTION do_all_books_retirement
44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

44: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

45: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

46: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

47: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

48: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:

Line 53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

49: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:
57: FUNCTION do_sub_retirement

Line 54: ,p_period_rec in FA_API_TYPES.period_rec_type

50: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:
57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

Line 55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

51: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
52: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
53: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:
57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

Line 58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

54: ,p_period_rec in FA_API_TYPES.period_rec_type
55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:
57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

Line 59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

55: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
56:
57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

56:
57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

57: FUNCTION do_sub_retirement
58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

58: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

59: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

60: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

61: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type
69: ,p_mrc_sob_type_code in VARCHAR2

Line 66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

62: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type
69: ,p_mrc_sob_type_code in VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

63: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type
69: ,p_mrc_sob_type_code in VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
71:

Line 68: ,p_period_rec in FA_API_TYPES.period_rec_type

64: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
65: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type
69: ,p_mrc_sob_type_code in VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
71:
72: FUNCTION do_sub_regular_retirement

Line 70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

66: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
67: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
68: ,p_period_rec in FA_API_TYPES.period_rec_type
69: ,p_mrc_sob_type_code in VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
71:
72: FUNCTION do_sub_regular_retirement
73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

69: ,p_mrc_sob_type_code in VARCHAR2
70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
71:
72: FUNCTION do_sub_regular_retirement
73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

70: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
71:
72: FUNCTION do_sub_regular_retirement
73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

71:
72: FUNCTION do_sub_regular_retirement
73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

72: FUNCTION do_sub_regular_retirement
73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

73: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

74: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type
82: ,p_mrc_sob_type_code in VARCHAR2

Line 79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

75: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type
82: ,p_mrc_sob_type_code in VARCHAR2
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

76: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type
82: ,p_mrc_sob_type_code in VARCHAR2
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
84:

Line 81: ,p_period_rec in FA_API_TYPES.period_rec_type

77: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
78: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type
82: ,p_mrc_sob_type_code in VARCHAR2
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
84:
85: FUNCTION calculate_gain_loss

Line 83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

79: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
80: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
81: ,p_period_rec in FA_API_TYPES.period_rec_type
82: ,p_mrc_sob_type_code in VARCHAR2
83: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
84:
85: FUNCTION calculate_gain_loss
86: (p_retirement_id in number
87: ,p_mrc_sob_type_code in varchar2

Line 88: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

84:
85: FUNCTION calculate_gain_loss
86: (p_retirement_id in number
87: ,p_mrc_sob_type_code in varchar2
88: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
89:
90: FUNCTION do_all_books_reinstatement
91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

87: ,p_mrc_sob_type_code in varchar2
88: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
89:
90: FUNCTION do_all_books_reinstatement
91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

88: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
89:
90: FUNCTION do_all_books_reinstatement
91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

89:
90: FUNCTION do_all_books_reinstatement
91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

90: FUNCTION do_all_books_reinstatement
91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

91: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

92: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

93: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

94: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:

Line 99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

95: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:
103: FUNCTION do_sub_reinstatement

Line 100: ,p_period_rec in FA_API_TYPES.period_rec_type

96: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:
103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

Line 101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

97: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
98: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
99: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:
103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

100: ,p_period_rec in FA_API_TYPES.period_rec_type
101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:
103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

101: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
102:
103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

102:
103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

103: FUNCTION do_sub_reinstatement
104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

104: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

105: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

106: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type
114: ,p_rate in number

Line 111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

107: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type
114: ,p_rate in number
115: ,p_mrc_sob_type_code in VARCHAR2

Line 112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

108: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type
114: ,p_rate in number
115: ,p_mrc_sob_type_code in VARCHAR2
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 113: ,p_period_rec in FA_API_TYPES.period_rec_type

109: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
110: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
111: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type
114: ,p_rate in number
115: ,p_mrc_sob_type_code in VARCHAR2
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
117:

Line 116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

112: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
113: ,p_period_rec in FA_API_TYPES.period_rec_type
114: ,p_rate in number
115: ,p_mrc_sob_type_code in VARCHAR2
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
117:
118: FUNCTION do_sub_regular_reinstatement
119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

115: ,p_mrc_sob_type_code in VARCHAR2
116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
117:
118: FUNCTION do_sub_regular_reinstatement
119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

116: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
117:
118: FUNCTION do_sub_regular_reinstatement
119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

117:
118: FUNCTION do_sub_regular_reinstatement
119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

118: FUNCTION do_sub_regular_reinstatement
119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

119: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

120: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

121: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type
129: ,p_mrc_sob_type_code in VARCHAR2

Line 126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

122: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type
129: ,p_mrc_sob_type_code in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

123: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type
129: ,p_mrc_sob_type_code in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
131:

Line 128: ,p_period_rec in FA_API_TYPES.period_rec_type

124: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
125: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type
129: ,p_mrc_sob_type_code in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
131:
132: FUNCTION undo_all_books_retirement

Line 130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

126: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
127: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
128: ,p_period_rec in FA_API_TYPES.period_rec_type
129: ,p_mrc_sob_type_code in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
131:
132: FUNCTION undo_all_books_retirement
133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 133: (p_trans_rec in FA_API_TYPES.trans_rec_type

129: ,p_mrc_sob_type_code in VARCHAR2
130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
131:
132: FUNCTION undo_all_books_retirement
133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

130: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
131:
132: FUNCTION undo_all_books_retirement
133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:

Line 135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242

131:
132: FUNCTION undo_all_books_retirement
133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:
139: FUNCTION undo_sub_retirement

Line 136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

132: FUNCTION undo_all_books_retirement
133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:
139: FUNCTION undo_sub_retirement
140: (p_trans_rec in FA_API_TYPES.trans_rec_type

Line 137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

133: (p_trans_rec in FA_API_TYPES.trans_rec_type
134: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
135: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:
139: FUNCTION undo_sub_retirement
140: (p_trans_rec in FA_API_TYPES.trans_rec_type
141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 140: (p_trans_rec in FA_API_TYPES.trans_rec_type

136: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:
139: FUNCTION undo_sub_retirement
140: (p_trans_rec in FA_API_TYPES.trans_rec_type
141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
142: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
143: ,p_mrc_sob_type_code in VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

137: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
138:
139: FUNCTION undo_sub_retirement
140: (p_trans_rec in FA_API_TYPES.trans_rec_type
141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
142: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
143: ,p_mrc_sob_type_code in VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
145:

Line 142: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

138:
139: FUNCTION undo_sub_retirement
140: (p_trans_rec in FA_API_TYPES.trans_rec_type
141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
142: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
143: ,p_mrc_sob_type_code in VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
145:
146: FUNCTION undo_all_books_reinstatement

Line 144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

140: (p_trans_rec in FA_API_TYPES.trans_rec_type
141: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
142: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
143: ,p_mrc_sob_type_code in VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
145:
146: FUNCTION undo_all_books_reinstatement
147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 147: (p_trans_rec in FA_API_TYPES.trans_rec_type

143: ,p_mrc_sob_type_code in VARCHAR2
144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
145:
146: FUNCTION undo_all_books_reinstatement
147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

144: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
145:
146: FUNCTION undo_all_books_reinstatement
147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:

Line 149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

145:
146: FUNCTION undo_all_books_reinstatement
147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:
153: FUNCTION undo_sub_reinstatement

Line 150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362

146: FUNCTION undo_all_books_reinstatement
147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:
153: FUNCTION undo_sub_reinstatement
154: (p_trans_rec in FA_API_TYPES.trans_rec_type

Line 151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

147: (p_trans_rec in FA_API_TYPES.trans_rec_type
148: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
149: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:
153: FUNCTION undo_sub_reinstatement
154: (p_trans_rec in FA_API_TYPES.trans_rec_type
155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

Line 154: (p_trans_rec in FA_API_TYPES.trans_rec_type

150: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:
153: FUNCTION undo_sub_reinstatement
154: (p_trans_rec in FA_API_TYPES.trans_rec_type
155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
156: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
157: ,p_mrc_sob_type_code in VARCHAR2
158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
152:
153: FUNCTION undo_sub_reinstatement
154: (p_trans_rec in FA_API_TYPES.trans_rec_type
155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
156: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
157: ,p_mrc_sob_type_code in VARCHAR2
158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
159:

Line 156: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

152:
153: FUNCTION undo_sub_reinstatement
154: (p_trans_rec in FA_API_TYPES.trans_rec_type
155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
156: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
157: ,p_mrc_sob_type_code in VARCHAR2
158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
159:
160: FUNCTION do_validation

Line 158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

154: (p_trans_rec in FA_API_TYPES.trans_rec_type
155: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
156: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
157: ,p_mrc_sob_type_code in VARCHAR2
158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
159:
160: FUNCTION do_validation
161: (p_validation_type in varchar2
162: ,p_trans_rec in FA_API_TYPES.trans_rec_type

Line 162: ,p_trans_rec in FA_API_TYPES.trans_rec_type

158: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
159:
160: FUNCTION do_validation
161: (p_validation_type in varchar2
162: ,p_trans_rec in FA_API_TYPES.trans_rec_type
163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

159:
160: FUNCTION do_validation
161: (p_validation_type in varchar2
162: ,p_trans_rec in FA_API_TYPES.trans_rec_type
163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type

Line 164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

160: FUNCTION do_validation
161: (p_validation_type in varchar2
162: ,p_trans_rec in FA_API_TYPES.trans_rec_type
163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

161: (p_validation_type in varchar2
162: ,p_trans_rec in FA_API_TYPES.trans_rec_type
163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

162: ,p_trans_rec in FA_API_TYPES.trans_rec_type
163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type

163: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

164: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type
172: ,p_calling_fn in varchar2

Line 169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

165: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type
172: ,p_calling_fn in varchar2
173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

166: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type
172: ,p_calling_fn in varchar2
173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
174:

Line 171: ,p_period_rec in FA_API_TYPES.period_rec_type

167: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
168: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type
172: ,p_calling_fn in varchar2
173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
174:
175: FUNCTION reinstate_src_line(

Line 173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

169: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
170: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
171: ,p_period_rec in FA_API_TYPES.period_rec_type
172: ,p_calling_fn in varchar2
173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
174:
175: FUNCTION reinstate_src_line(
176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

Line 176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

172: ,p_calling_fn in varchar2
173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
174:
175: FUNCTION reinstate_src_line(
176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,

Line 177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

173: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
174:
175: FUNCTION reinstate_src_line(
176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,
181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,

Line 178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

174:
175: FUNCTION reinstate_src_line(
176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,
181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
182: p_rowid IN ROWID,

Line 179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

175: FUNCTION reinstate_src_line(
176: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,
181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
182: p_rowid IN ROWID,
183: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

Line 181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,

177: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
178: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,
181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
182: p_rowid IN ROWID,
183: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
184:
185: ------------------------------------------------------------------------------

Line 183: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;

179: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
180: p_invoice_transaction_id IN NUMBER,
181: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
182: p_rowid IN ROWID,
183: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
184:
185: ------------------------------------------------------------------------------
186: PROCEDURE do_retirement
187: (p_api_version in NUMBER

Line 196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

192: ,x_return_status out NOCOPY VARCHAR2
193: ,x_msg_count out NOCOPY NUMBER
194: ,x_msg_data out NOCOPY VARCHAR2
195:
196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

193: ,x_msg_count out NOCOPY NUMBER
194: ,x_msg_data out NOCOPY VARCHAR2
195:
196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type

194: ,x_msg_data out NOCOPY VARCHAR2
195:
196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS

Line 199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

195:
196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:

Line 200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

196: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:
204: -- local asset info

Line 201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

197: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:
204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS

198: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
199: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
200: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:
204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

Line 205: l_trans_rec FA_API_TYPES.trans_rec_type;

201: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:
204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

202: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type) IS
203:
204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

203:
204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

204: -- local asset info
205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

205: l_trans_rec FA_API_TYPES.trans_rec_type;
206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

206: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

207: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;
215: l_period_rec FA_API_TYPES.period_rec_type;

Line 212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

208: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;
215: l_period_rec FA_API_TYPES.period_rec_type;
216:

Line 213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

209: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;
215: l_period_rec FA_API_TYPES.period_rec_type;
216:
217: -- used for loop through tax books

Line 214: l_inv_tbl FA_API_TYPES.inv_tbl_type;

210: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;
215: l_period_rec FA_API_TYPES.period_rec_type;
216:
217: -- used for loop through tax books
218: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

Line 215: l_period_rec FA_API_TYPES.period_rec_type;

211: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
212: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
213: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
214: l_inv_tbl FA_API_TYPES.inv_tbl_type;
215: l_period_rec FA_API_TYPES.period_rec_type;
216:
217: -- used for loop through tax books
218: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
219: l_tax_index number;

Line 222: lv_trans_rec FA_API_TYPES.trans_rec_type;

218: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
219: l_tax_index number;
220:
221: -- used for tax books when doing cip-in-tax or autocopy
222: lv_trans_rec FA_API_TYPES.trans_rec_type;
223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
226:

Line 223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;

219: l_tax_index number;
220:
221: -- used for tax books when doing cip-in-tax or autocopy
222: lv_trans_rec FA_API_TYPES.trans_rec_type;
223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
226:
227: -- local individual variables

Line 224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

220:
221: -- used for tax books when doing cip-in-tax or autocopy
222: lv_trans_rec FA_API_TYPES.trans_rec_type;
223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
226:
227: -- local individual variables
228: l_transaction_type varchar2(30) := null;

Line 225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

221: -- used for tax books when doing cip-in-tax or autocopy
222: lv_trans_rec FA_API_TYPES.trans_rec_type;
223: lv_dist_trans_rec FA_API_TYPES.trans_rec_type;
224: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
225: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
226:
227: -- local individual variables
228: l_transaction_type varchar2(30) := null;
229: l_reporting_flag varchar2(1);

Line 245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

241:
242: /*
243: * Added for Group Asset uptake
244: */
245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

242: /*
243: * Added for Group Asset uptake
244: */
245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
250: /*** End of uptake ***/

Line 247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;

243: * Added for Group Asset uptake
244: */
245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
250: /*** End of uptake ***/
251:

Line 248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

244: */
245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
250: /*** End of uptake ***/
251:
252: -- used to store original sob info upon entry into api

Line 249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

245: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
246: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
247: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
248: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
249: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
250: /*** End of uptake ***/
251:
252: -- used to store original sob info upon entry into api
253: l_orig_set_of_books_id number;

Line 1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

1191:
1192: END do_retirement;
1193:
1194: FUNCTION do_all_books_retirement
1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

Line 1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

1192: END do_retirement;
1193:
1194: FUNCTION do_all_books_retirement
1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

1193:
1194: FUNCTION do_all_books_retirement
1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

1194: FUNCTION do_all_books_retirement
1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

1195: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

1196: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

1197: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

1198: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type
1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

1199: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type
1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1207: -- will return retirement_id of asset_retire_rec

Line 1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

1200: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type
1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1207: -- will return retirement_id of asset_retire_rec
1208: IS

Line 1205: ,p_period_rec in FA_API_TYPES.period_rec_type

1201: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type
1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1207: -- will return retirement_id of asset_retire_rec
1208: IS
1209:

Line 1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

1202: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1203: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1204: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1205: ,p_period_rec in FA_API_TYPES.period_rec_type
1206: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1207: -- will return retirement_id of asset_retire_rec
1208: IS
1209:
1210: -- Returns the reporting GL set_of_books_ids

Line 1227: l_trans_rec FA_API_TYPES.trans_rec_type;

1223: l_distribution_source_book varchar2(30);
1224: l_mc_source_flag varchar2(1);
1225:
1226: -- local asset info
1227: l_trans_rec FA_API_TYPES.trans_rec_type;
1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

1224: l_mc_source_flag varchar2(1);
1225:
1226: -- local asset info
1227: l_trans_rec FA_API_TYPES.trans_rec_type;
1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1225:
1226: -- local asset info
1227: l_trans_rec FA_API_TYPES.trans_rec_type;
1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

1226: -- local asset info
1227: l_trans_rec FA_API_TYPES.trans_rec_type;
1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

1227: l_trans_rec FA_API_TYPES.trans_rec_type;
1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

1228: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

1229: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1237: l_period_rec FA_API_TYPES.period_rec_type;

Line 1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

1230: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1237: l_period_rec FA_API_TYPES.period_rec_type;
1238:

Line 1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

1231: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1237: l_period_rec FA_API_TYPES.period_rec_type;
1238:
1239: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;

Line 1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1232: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1237: l_period_rec FA_API_TYPES.period_rec_type;
1238:
1239: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1240:

Line 1237: l_period_rec FA_API_TYPES.period_rec_type;

1233: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1234: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1235: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1236: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1237: l_period_rec FA_API_TYPES.period_rec_type;
1238:
1239: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1240:
1241: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 1241: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1237: l_period_rec FA_API_TYPES.period_rec_type;
1238:
1239: l_sob_tbl FA_CACHE_PKG.fazcrsob_sob_tbl_type;
1240:
1241: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1242:
1243: -- local individual variables
1244: l_latest_trans_date date;
1245: l_ret_prorate_date date;

Line 1264: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1260: -- msg
1261: g_msg_name varchar2(30);
1262:
1263: --secondary changes
1264: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1265: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
1266: l_seondary_sob_id number;
1267:
1268: l_calling_fn varchar2(80) := 'FA_RETIREMENT_PUB.do_all_books_retirement';

Line 1265: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;

1261: g_msg_name varchar2(30);
1262:
1263: --secondary changes
1264: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1265: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
1266: l_seondary_sob_id number;
1267:
1268: l_calling_fn varchar2(80) := 'FA_RETIREMENT_PUB.do_all_books_retirement';
1269:

Line 1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

1787: END do_all_books_retirement;
1788:
1789:
1790: FUNCTION do_sub_retirement
1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

Line 1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

1788:
1789:
1790: FUNCTION do_sub_retirement
1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

1789:
1790: FUNCTION do_sub_retirement
1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

1790: FUNCTION do_sub_retirement
1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

1791: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

1792: ,px_dist_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

1793: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

1794: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type
1802: ,p_mrc_sob_type_code in VARCHAR2

Line 1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

1795: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type
1802: ,p_mrc_sob_type_code in VARCHAR2
1803: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

1796: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type
1802: ,p_mrc_sob_type_code in VARCHAR2
1803: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1804: -- will return retirement_id of px_asset_retire_rec

Line 1801: ,p_period_rec in FA_API_TYPES.period_rec_type

1797: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
1798: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type
1802: ,p_mrc_sob_type_code in VARCHAR2
1803: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1804: -- will return retirement_id of px_asset_retire_rec
1805: IS

Line 1803: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

1799: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
1800: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
1801: ,p_period_rec in FA_API_TYPES.period_rec_type
1802: ,p_mrc_sob_type_code in VARCHAR2
1803: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
1804: -- will return retirement_id of px_asset_retire_rec
1805: IS
1806:
1807: -- local asset info

Line 1808: l_trans_rec FA_API_TYPES.trans_rec_type;

1804: -- will return retirement_id of px_asset_retire_rec
1805: IS
1806:
1807: -- local asset info
1808: l_trans_rec FA_API_TYPES.trans_rec_type;
1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

1805: IS
1806:
1807: -- local asset info
1808: l_trans_rec FA_API_TYPES.trans_rec_type;
1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

1806:
1807: -- local asset info
1808: l_trans_rec FA_API_TYPES.trans_rec_type;
1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;

Line 1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

1807: -- local asset info
1808: l_trans_rec FA_API_TYPES.trans_rec_type;
1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

1808: l_trans_rec FA_API_TYPES.trans_rec_type;
1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;

Line 1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

1809: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;

1810: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

1811: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;

1812: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;

Line 1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

1813: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;
1821:

Line 1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

1814: l_asset_fin_mrc_rec FA_API_TYPES.asset_fin_rec_type;
1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;
1821:
1822: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;

1815: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;
1821:
1822: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1823:

Line 1820: l_period_rec FA_API_TYPES.period_rec_type;

1816: l_asset_retire_mrc_rec FA_API_TYPES.asset_retire_rec_type;
1817: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;
1821:
1822: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1823:
1824: l_rate number;

Line 1822: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

1818: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
1819: l_inv_tbl FA_API_TYPES.inv_tbl_type;
1820: l_period_rec FA_API_TYPES.period_rec_type;
1821:
1822: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
1823:
1824: l_rate number;
1825:
1826: l_fraction_remaining number;

Line 2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

2223:
2224: END do_sub_retirement;
2225:
2226: FUNCTION do_sub_regular_retirement
2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

2224: END do_sub_retirement;
2225:
2226: FUNCTION do_sub_regular_retirement
2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

2225:
2226: FUNCTION do_sub_regular_retirement
2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

2226: FUNCTION do_sub_regular_retirement
2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

2227: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

2228: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type
2236: ,p_mrc_sob_type_code in VARCHAR2

Line 2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

2229: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type
2236: ,p_mrc_sob_type_code in VARCHAR2
2237: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

2230: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type
2236: ,p_mrc_sob_type_code in VARCHAR2
2237: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
2238: IS

Line 2235: ,p_period_rec in FA_API_TYPES.period_rec_type

2231: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
2232: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type
2236: ,p_mrc_sob_type_code in VARCHAR2
2237: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
2238: IS
2239:

Line 2237: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

2233: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
2234: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
2235: ,p_period_rec in FA_API_TYPES.period_rec_type
2236: ,p_mrc_sob_type_code in VARCHAR2
2237: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
2238: IS
2239:
2240: p_sob_id number;
2241: p_book_type_code varchar2(30);

Line 2356: l_trans_rec FA_API_TYPES.trans_rec_type;

2352: and mt.deprn_basis_rule_id = db.deprn_basis_rule_id; -- ENERGY
2353:
2354:
2355: -- local asset info
2356: l_trans_rec FA_API_TYPES.trans_rec_type;
2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

2353:
2354:
2355: -- local asset info
2356: l_trans_rec FA_API_TYPES.trans_rec_type;
2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

2354:
2355: -- local asset info
2356: l_trans_rec FA_API_TYPES.trans_rec_type;
2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

2355: -- local asset info
2356: l_trans_rec FA_API_TYPES.trans_rec_type;
2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

2356: l_trans_rec FA_API_TYPES.trans_rec_type;
2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

2357: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;

Line 2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

2358: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

2359: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2367:

Line 2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;

2360: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2367:
2368: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 2365: l_period_rec FA_API_TYPES.period_rec_type;

2361: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2367:
2368: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2369:

Line 2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

2362: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
2363: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2367:
2368: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2369:
2370: l_rowid ROWID;

Line 2368: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

2364: l_inv_tbl FA_API_TYPES.inv_tbl_type;
2365: l_period_rec FA_API_TYPES.period_rec_type;
2366: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
2367:
2368: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
2369:
2370: l_rowid ROWID;
2371: l_Fraction_Remaining number;
2372: l_deprn_rounding_flag varchar2(30);

Line 3320: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

3316:
3317: FUNCTION calculate_gain_loss
3318: (p_retirement_id in number
3319: ,p_mrc_sob_type_code in VARCHAR2
3320: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3321: IS
3322:
3323: l_return_status number := 0;
3324:

Line 3383: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

3379: ,x_return_status out NOCOPY VARCHAR2
3380: ,x_msg_count out NOCOPY NUMBER
3381: ,x_msg_data out NOCOPY VARCHAR2
3382:
3383: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
3384: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
3386: IS
3387: -- local asset info

Line 3384: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type

3380: ,x_msg_count out NOCOPY NUMBER
3381: ,x_msg_data out NOCOPY VARCHAR2
3382:
3383: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
3384: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
3386: IS
3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)

3381: ,x_msg_data out NOCOPY VARCHAR2
3382:
3383: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
3384: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
3386: IS
3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;

Line 3388: l_trans_rec FA_API_TYPES.trans_rec_type;

3384: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
3386: IS
3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 3389: lv_trans_rec FA_API_TYPES.trans_rec_type;

3385: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
3386: IS
3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3386: IS
3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3387: -- local asset info
3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

3388: l_trans_rec FA_API_TYPES.trans_rec_type;
3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

3389: lv_trans_rec FA_API_TYPES.trans_rec_type;
3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

3390: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

3391: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

3392: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;

Line 3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

3393: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:

Line 3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

3394: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: -- used to loop through tax books

Line 3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;

3395: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: -- used to loop through tax books
3403: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

Line 3400: l_period_rec FA_API_TYPES.period_rec_type;

3396: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3397: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
3398: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
3399: l_inv_tbl FA_API_TYPES.inv_tbl_type;
3400: l_period_rec FA_API_TYPES.period_rec_type;
3401:
3402: -- used to loop through tax books
3403: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
3404: l_tax_index number; -- index for tax loop

Line 3699: (p_trans_rec in FA_API_TYPES.trans_rec_type

3695: END undo_retirement;
3696: -----------------------------------------------------------------------------
3697:
3698: FUNCTION undo_all_books_retirement
3699: (p_trans_rec in FA_API_TYPES.trans_rec_type
3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

3696: -----------------------------------------------------------------------------
3697:
3698: FUNCTION undo_all_books_retirement
3699: (p_trans_rec in FA_API_TYPES.trans_rec_type
3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3704: IS

Line 3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242

3697:
3698: FUNCTION undo_all_books_retirement
3699: (p_trans_rec in FA_API_TYPES.trans_rec_type
3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3704: IS
3705:

Line 3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

3698: FUNCTION undo_all_books_retirement
3699: (p_trans_rec in FA_API_TYPES.trans_rec_type
3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3704: IS
3705:
3706: -- Returns the reporting GL set_of_books_ids

Line 3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

3699: (p_trans_rec in FA_API_TYPES.trans_rec_type
3700: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3701: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8630242
3702: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3703: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3704: IS
3705:
3706: -- Returns the reporting GL set_of_books_ids
3707: -- associated with the set_of_books_id of given primary book_type_code

Line 3723: l_trans_rec FA_API_TYPES.trans_rec_type;

3719: l_distribution_source_book varchar2(30);
3720: l_mc_source_flag varchar2(1);
3721:
3722: -- local asset info
3723: l_trans_rec FA_API_TYPES.trans_rec_type;
3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3726: l_period_rec FA_API_TYPES.period_rec_type;
3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242

Line 3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3720: l_mc_source_flag varchar2(1);
3721:
3722: -- local asset info
3723: l_trans_rec FA_API_TYPES.trans_rec_type;
3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3726: l_period_rec FA_API_TYPES.period_rec_type;
3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
3728:

Line 3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

3721:
3722: -- local asset info
3723: l_trans_rec FA_API_TYPES.trans_rec_type;
3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3726: l_period_rec FA_API_TYPES.period_rec_type;
3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
3728:
3729: l_ins_status boolean := FALSE;

Line 3726: l_period_rec FA_API_TYPES.period_rec_type;

3722: -- local asset info
3723: l_trans_rec FA_API_TYPES.trans_rec_type;
3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3726: l_period_rec FA_API_TYPES.period_rec_type;
3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
3728:
3729: l_ins_status boolean := FALSE;
3730:

Line 3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242

3723: l_trans_rec FA_API_TYPES.trans_rec_type;
3724: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3725: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3726: l_period_rec FA_API_TYPES.period_rec_type;
3727: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
3728:
3729: l_ins_status boolean := FALSE;
3730:
3731: l_retirement_id number(15);

Line 3923: (p_trans_rec in FA_API_TYPES.trans_rec_type

3919: END undo_all_books_retirement;
3920: ------------------------------------------------------------------------------
3921:
3922: FUNCTION undo_sub_retirement
3923: (p_trans_rec in FA_API_TYPES.trans_rec_type
3924: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3925: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3926: ,p_mrc_sob_type_code in VARCHAR2
3927: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 3924: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

3920: ------------------------------------------------------------------------------
3921:
3922: FUNCTION undo_sub_retirement
3923: (p_trans_rec in FA_API_TYPES.trans_rec_type
3924: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3925: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3926: ,p_mrc_sob_type_code in VARCHAR2
3927: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3928: IS

Line 3925: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

3921:
3922: FUNCTION undo_sub_retirement
3923: (p_trans_rec in FA_API_TYPES.trans_rec_type
3924: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3925: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3926: ,p_mrc_sob_type_code in VARCHAR2
3927: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3928: IS
3929:

Line 3927: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

3923: (p_trans_rec in FA_API_TYPES.trans_rec_type
3924: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
3925: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
3926: ,p_mrc_sob_type_code in VARCHAR2
3927: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
3928: IS
3929:
3930: transfer_id number(15);
3931: l_trans_units number;

Line 3939: l_trans_rec FA_API_TYPES.trans_rec_type;

3935:
3936: l_old_cost number;
3937: l_old_units number;
3938: -- local asset info
3939: l_trans_rec FA_API_TYPES.trans_rec_type;
3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

3936: l_old_cost number;
3937: l_old_units number;
3938: -- local asset info
3939: l_trans_rec FA_API_TYPES.trans_rec_type;
3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3944:

Line 3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

3937: l_old_units number;
3938: -- local asset info
3939: l_trans_rec FA_API_TYPES.trans_rec_type;
3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3944:
3945: cursor get_transfer_id is

Line 3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

3938: -- local asset info
3939: l_trans_rec FA_API_TYPES.trans_rec_type;
3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3944:
3945: cursor get_transfer_id is
3946: select transaction_header_id_out

Line 3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

3939: l_trans_rec FA_API_TYPES.trans_rec_type;
3940: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
3941: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
3942: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
3943: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
3944:
3945: cursor get_transfer_id is
3946: select transaction_header_id_out
3947: ,transaction_units

Line 4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

4439: ,x_return_status out NOCOPY VARCHAR2
4440: ,x_msg_count out NOCOPY NUMBER
4441: ,x_msg_data out NOCOPY VARCHAR2
4442:
4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type

4440: ,x_msg_count out NOCOPY NUMBER
4441: ,x_msg_data out NOCOPY VARCHAR2
4442:
4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)

Line 4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

4441: ,x_msg_data out NOCOPY VARCHAR2
4442:
4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS

Line 4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

4442:
4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS
4450: -- local asset info

Line 4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

4443: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS
4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)

4444: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
4445: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4446: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS
4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;

Line 4451: l_trans_rec FA_API_TYPES.trans_rec_type;

4447: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS
4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 4452: lv_trans_rec FA_API_TYPES.trans_rec_type;

4448: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type)
4449: IS
4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

4449: IS
4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

4450: -- local asset info
4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

4451: l_trans_rec FA_API_TYPES.trans_rec_type;
4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

4452: lv_trans_rec FA_API_TYPES.trans_rec_type;
4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

4453: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

4454: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

4455: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4463: l_period_rec FA_API_TYPES.period_rec_type;

Line 4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

4456: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4463: l_period_rec FA_API_TYPES.period_rec_type;
4464:

Line 4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

4457: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4463: l_period_rec FA_API_TYPES.period_rec_type;
4464:
4465: -- used for loop through tax books

Line 4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;

4458: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4463: l_period_rec FA_API_TYPES.period_rec_type;
4464:
4465: -- used for loop through tax books
4466: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

Line 4463: l_period_rec FA_API_TYPES.period_rec_type;

4459: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
4460: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
4461: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
4462: l_inv_tbl FA_API_TYPES.inv_tbl_type;
4463: l_period_rec FA_API_TYPES.period_rec_type;
4464:
4465: -- used for loop through tax books
4466: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
4467: l_tax_index number;

Line 4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

4962: END do_reinstatement;
4963: -----------------------------------------------------------------------------
4964:
4965: FUNCTION do_all_books_reinstatement
4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

4963: -----------------------------------------------------------------------------
4964:
4965: FUNCTION do_all_books_reinstatement
4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

4964:
4965: FUNCTION do_all_books_reinstatement
4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

4965: FUNCTION do_all_books_reinstatement
4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

4966: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

4967: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

4968: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type
4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

4969: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type
4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
4977: -- will return retirement_id of asset_retire_rec

Line 4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

4970: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type
4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
4977: -- will return retirement_id of asset_retire_rec
4978: IS

Line 4975: ,p_period_rec in FA_API_TYPES.period_rec_type

4971: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type
4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
4977: -- will return retirement_id of asset_retire_rec
4978: IS
4979:

Line 4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

4972: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
4973: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
4974: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
4975: ,p_period_rec in FA_API_TYPES.period_rec_type
4976: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
4977: -- will return retirement_id of asset_retire_rec
4978: IS
4979:
4980: -- Returns the reporting GL set_of_books_ids

Line 4997: l_trans_rec FA_API_TYPES.trans_rec_type;

4993: l_distribution_source_book varchar2(30);
4994: l_mc_source_flag varchar2(1);
4995:
4996: -- local asset info
4997: l_trans_rec FA_API_TYPES.trans_rec_type;
4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

4994: l_mc_source_flag varchar2(1);
4995:
4996: -- local asset info
4997: l_trans_rec FA_API_TYPES.trans_rec_type;
4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

4995:
4996: -- local asset info
4997: l_trans_rec FA_API_TYPES.trans_rec_type;
4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

4996: -- local asset info
4997: l_trans_rec FA_API_TYPES.trans_rec_type;
4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

4997: l_trans_rec FA_API_TYPES.trans_rec_type;
4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

4998: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;

Line 5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

4999: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;
5007:

Line 5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

5000: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;
5007:
5008: -- local individual variables

Line 5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;

5001: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;
5007:
5008: -- local individual variables
5009: l_latest_trans_date date;

Line 5006: l_period_rec FA_API_TYPES.period_rec_type;

5002: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5003: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5004: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5005: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5006: l_period_rec FA_API_TYPES.period_rec_type;
5007:
5008: -- local individual variables
5009: l_latest_trans_date date;
5010:

Line 5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

5270: END do_all_books_reinstatement;
5271:
5272:
5273: FUNCTION do_sub_reinstatement
5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

5271:
5272:
5273: FUNCTION do_sub_reinstatement
5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

5272:
5273: FUNCTION do_sub_reinstatement
5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

5273: FUNCTION do_sub_reinstatement
5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

5274: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

5275: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

5276: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type
5284: ,p_rate in number

Line 5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

5277: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type
5284: ,p_rate in number
5285: ,p_mrc_sob_type_code in VARCHAR2

Line 5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

5278: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type
5284: ,p_rate in number
5285: ,p_mrc_sob_type_code in VARCHAR2
5286: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 5283: ,p_period_rec in FA_API_TYPES.period_rec_type

5279: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5280: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5281: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type
5284: ,p_rate in number
5285: ,p_mrc_sob_type_code in VARCHAR2
5286: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5287: -- will return retirement_id of px_asset_retire_rec

Line 5286: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

5282: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5283: ,p_period_rec in FA_API_TYPES.period_rec_type
5284: ,p_rate in number
5285: ,p_mrc_sob_type_code in VARCHAR2
5286: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5287: -- will return retirement_id of px_asset_retire_rec
5288: IS
5289:
5290: -- local asset info

Line 5291: l_trans_rec FA_API_TYPES.trans_rec_type;

5287: -- will return retirement_id of px_asset_retire_rec
5288: IS
5289:
5290: -- local asset info
5291: l_trans_rec FA_API_TYPES.trans_rec_type;
5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 5292: lv_trans_rec FA_API_TYPES.trans_rec_type;

5288: IS
5289:
5290: -- local asset info
5291: l_trans_rec FA_API_TYPES.trans_rec_type;
5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5289:
5290: -- local asset info
5291: l_trans_rec FA_API_TYPES.trans_rec_type;
5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

5290: -- local asset info
5291: l_trans_rec FA_API_TYPES.trans_rec_type;
5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

5291: l_trans_rec FA_API_TYPES.trans_rec_type;
5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

5292: lv_trans_rec FA_API_TYPES.trans_rec_type;
5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

5293: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;

Line 5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

5294: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;
5302:

Line 5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

5295: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;
5302:
5303: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;

5296: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;
5302:
5303: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5304:

Line 5301: l_period_rec FA_API_TYPES.period_rec_type;

5297: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5298: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;
5302:
5303: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5304:
5305: l_rate number;

Line 5303: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

5299: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5300: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5301: l_period_rec FA_API_TYPES.period_rec_type;
5302:
5303: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5304:
5305: l_rate number;
5306:
5307: l_fraction_remaining number;

Line 5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

5510: END do_sub_reinstatement;
5511: ----------------------------------------------------------------
5512:
5513: FUNCTION do_sub_regular_reinstatement
5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

5511: ----------------------------------------------------------------
5512:
5513: FUNCTION do_sub_regular_reinstatement
5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

Line 5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

5512:
5513: FUNCTION do_sub_regular_reinstatement
5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

5513: FUNCTION do_sub_regular_reinstatement
5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

5514: (px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

5515: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

5516: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type
5524: ,p_mrc_sob_type_code in VARCHAR2

Line 5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

5517: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type
5524: ,p_mrc_sob_type_code in VARCHAR2
5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

5518: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type
5524: ,p_mrc_sob_type_code in VARCHAR2
5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5526: IS

Line 5523: ,p_period_rec in FA_API_TYPES.period_rec_type

5519: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
5520: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type
5524: ,p_mrc_sob_type_code in VARCHAR2
5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5526: IS
5527:

Line 5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

5521: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
5522: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
5523: ,p_period_rec in FA_API_TYPES.period_rec_type
5524: ,p_mrc_sob_type_code in VARCHAR2
5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5526: IS
5527:
5528: -- local asset info
5529: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 5529: l_trans_rec FA_API_TYPES.trans_rec_type;

5525: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
5526: IS
5527:
5528: -- local asset info
5529: l_trans_rec FA_API_TYPES.trans_rec_type;
5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5526: IS
5527:
5528: -- local asset info
5529: l_trans_rec FA_API_TYPES.trans_rec_type;
5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

5527:
5528: -- local asset info
5529: l_trans_rec FA_API_TYPES.trans_rec_type;
5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

5528: -- local asset info
5529: l_trans_rec FA_API_TYPES.trans_rec_type;
5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

5529: l_trans_rec FA_API_TYPES.trans_rec_type;
5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;

Line 5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

5530: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;
5538:

Line 5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

5531: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;
5538:
5539: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;

5532: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;
5538:
5539: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5540:

Line 5537: l_period_rec FA_API_TYPES.period_rec_type;

5533: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5534: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;
5538:
5539: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5540:
5541: l_rowid ROWID;

Line 5539: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

5535: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5536: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5537: l_period_rec FA_API_TYPES.period_rec_type;
5538:
5539: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
5540:
5541: l_rowid ROWID;
5542: l_Fraction_Remaining number;
5543: l_deprn_rounding_flag varchar2(30);

Line 5573: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;

5569:
5570: l_calling_fn varchar2(80) := 'FA_RETIREMENT_PUB.do_sub_regular_reinstatement';
5571:
5572: --Secondary Changes
5573: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
5574: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5575: l_secondary_sob_id number;
5576:
5577: BEGIN

Line 5574: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5570: l_calling_fn varchar2(80) := 'FA_RETIREMENT_PUB.do_sub_regular_reinstatement';
5571:
5572: --Secondary Changes
5573: l_secondary_trans_rec FA_API_TYPES.trans_rec_type;
5574: l_secondary_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5575: l_secondary_sob_id number;
5576:
5577: BEGIN
5578:

Line 5886: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type

5882: ,x_return_status out NOCOPY VARCHAR2
5883: ,x_msg_count out NOCOPY NUMBER
5884: ,x_msg_data out NOCOPY VARCHAR2
5885:
5886: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5887: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
5888: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
5889:
5890: IS

Line 5887: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type

5883: ,x_msg_count out NOCOPY NUMBER
5884: ,x_msg_data out NOCOPY VARCHAR2
5885:
5886: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5887: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
5888: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
5889:
5890: IS
5891:

Line 5888: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)

5884: ,x_msg_data out NOCOPY VARCHAR2
5885:
5886: ,px_trans_rec in out NOCOPY FA_API_TYPES.trans_rec_type
5887: ,px_asset_hdr_rec in out NOCOPY FA_API_TYPES.asset_hdr_rec_type
5888: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type)
5889:
5890: IS
5891:
5892: -- local asset info

Line 5893: l_trans_rec FA_API_TYPES.trans_rec_type;

5889:
5890: IS
5891:
5892: -- local asset info
5893: l_trans_rec FA_API_TYPES.trans_rec_type;
5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 5894: lv_trans_rec FA_API_TYPES.trans_rec_type;

5890: IS
5891:
5892: -- local asset info
5893: l_trans_rec FA_API_TYPES.trans_rec_type;
5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5891:
5892: -- local asset info
5893: l_trans_rec FA_API_TYPES.trans_rec_type;
5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

Line 5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

5892: -- local asset info
5893: l_trans_rec FA_API_TYPES.trans_rec_type;
5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

5893: l_trans_rec FA_API_TYPES.trans_rec_type;
5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

5894: lv_trans_rec FA_API_TYPES.trans_rec_type;
5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

5895: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

5896: lv_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

5897: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5905: l_period_rec FA_API_TYPES.period_rec_type;

Line 5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

5898: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5905: l_period_rec FA_API_TYPES.period_rec_type;
5906:

Line 5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

5899: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5905: l_period_rec FA_API_TYPES.period_rec_type;
5906:
5907: -- used to loop through tax books

Line 5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;

5900: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5905: l_period_rec FA_API_TYPES.period_rec_type;
5906:
5907: -- used to loop through tax books
5908: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;

Line 5905: l_period_rec FA_API_TYPES.period_rec_type;

5901: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
5902: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
5903: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
5904: l_inv_tbl FA_API_TYPES.inv_tbl_type;
5905: l_period_rec FA_API_TYPES.period_rec_type;
5906:
5907: -- used to loop through tax books
5908: l_tax_book_tbl FA_CACHE_PKG.fazctbk_tbl_type;
5909: l_tax_index number; -- index for tax loop

Line 6195: (p_trans_rec in FA_API_TYPES.trans_rec_type

6191: END undo_reinstatement;
6192: ----------------------------------------------------
6193:
6194: FUNCTION undo_all_books_reinstatement
6195: (p_trans_rec in FA_API_TYPES.trans_rec_type
6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

6192: ----------------------------------------------------
6193:
6194: FUNCTION undo_all_books_reinstatement
6195: (p_trans_rec in FA_API_TYPES.trans_rec_type
6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6200: IS

Line 6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

6193:
6194: FUNCTION undo_all_books_reinstatement
6195: (p_trans_rec in FA_API_TYPES.trans_rec_type
6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6200: IS
6201:

Line 6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362

6194: FUNCTION undo_all_books_reinstatement
6195: (p_trans_rec in FA_API_TYPES.trans_rec_type
6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6200: IS
6201:
6202: -- Returns the reporting GL set_of_books_ids

Line 6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

6195: (p_trans_rec in FA_API_TYPES.trans_rec_type
6196: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6197: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6198: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type -- bug 8643362
6199: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6200: IS
6201:
6202: -- Returns the reporting GL set_of_books_ids
6203: -- associated with the set_of_books_id of given primary book_type_code

Line 6219: l_trans_rec FA_API_TYPES.trans_rec_type;

6215: l_distribution_source_book varchar2(30);
6216: l_mc_source_flag varchar2(1);
6217:
6218: -- local asset info
6219: l_trans_rec FA_API_TYPES.trans_rec_type;
6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6222: l_period_rec FA_API_TYPES.period_rec_type;
6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242

Line 6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

6216: l_mc_source_flag varchar2(1);
6217:
6218: -- local asset info
6219: l_trans_rec FA_API_TYPES.trans_rec_type;
6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6222: l_period_rec FA_API_TYPES.period_rec_type;
6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
6224:

Line 6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

6217:
6218: -- local asset info
6219: l_trans_rec FA_API_TYPES.trans_rec_type;
6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6222: l_period_rec FA_API_TYPES.period_rec_type;
6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
6224:
6225: l_ins_status boolean := FALSE;

Line 6222: l_period_rec FA_API_TYPES.period_rec_type;

6218: -- local asset info
6219: l_trans_rec FA_API_TYPES.trans_rec_type;
6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6222: l_period_rec FA_API_TYPES.period_rec_type;
6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
6224:
6225: l_ins_status boolean := FALSE;
6226:

Line 6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242

6219: l_trans_rec FA_API_TYPES.trans_rec_type;
6220: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6221: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6222: l_period_rec FA_API_TYPES.period_rec_type;
6223: l_asset_type_rec FA_API_TYPES.asset_type_rec_type; -- bug 8630242
6224:
6225: l_ins_status boolean := FALSE;
6226:
6227: -- local conversion rate

Line 6407: (p_trans_rec in FA_API_TYPES.trans_rec_type

6403: END undo_all_books_reinstatement;
6404: ------------------------------------------------------------------------------
6405: -- p_trans_rec should have trx_id for the previous REINSTATEMENT transaction
6406: FUNCTION undo_sub_reinstatement
6407: (p_trans_rec in FA_API_TYPES.trans_rec_type
6408: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6409: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6410: ,p_mrc_sob_type_code in VARCHAR2
6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 6408: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

6404: ------------------------------------------------------------------------------
6405: -- p_trans_rec should have trx_id for the previous REINSTATEMENT transaction
6406: FUNCTION undo_sub_reinstatement
6407: (p_trans_rec in FA_API_TYPES.trans_rec_type
6408: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6409: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6410: ,p_mrc_sob_type_code in VARCHAR2
6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6412: IS

Line 6409: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type

6405: -- p_trans_rec should have trx_id for the previous REINSTATEMENT transaction
6406: FUNCTION undo_sub_reinstatement
6407: (p_trans_rec in FA_API_TYPES.trans_rec_type
6408: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6409: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6410: ,p_mrc_sob_type_code in VARCHAR2
6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6412: IS
6413: -- local asset info

Line 6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

6407: (p_trans_rec in FA_API_TYPES.trans_rec_type
6408: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6409: ,px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type
6410: ,p_mrc_sob_type_code in VARCHAR2
6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6412: IS
6413: -- local asset info
6414: l_trans_rec FA_API_TYPES.trans_rec_type;
6415: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 6414: l_trans_rec FA_API_TYPES.trans_rec_type;

6410: ,p_mrc_sob_type_code in VARCHAR2
6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6412: IS
6413: -- local asset info
6414: l_trans_rec FA_API_TYPES.trans_rec_type;
6415: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6416: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6417:
6418: /*

Line 6415: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

6411: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6412: IS
6413: -- local asset info
6414: l_trans_rec FA_API_TYPES.trans_rec_type;
6415: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6416: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6417:
6418: /*
6419: * Check to see previous retirement was source line retirement or not

Line 6416: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

6412: IS
6413: -- local asset info
6414: l_trans_rec FA_API_TYPES.trans_rec_type;
6415: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6416: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6417:
6418: /*
6419: * Check to see previous retirement was source line retirement or not
6420: */

Line 6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type

6629:
6630: -- This routine mainly validates input parameters and whether the trx is runnable
6631: FUNCTION do_validation
6632: (p_validation_type in varchar2
6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type
6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

Line 6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type

6630: -- This routine mainly validates input parameters and whether the trx is runnable
6631: FUNCTION do_validation
6632: (p_validation_type in varchar2
6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type
6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type

Line 6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type

6631: FUNCTION do_validation
6632: (p_validation_type in varchar2
6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type
6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

Line 6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type

6632: (p_validation_type in varchar2
6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type
6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

Line 6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type

6633: ,p_trans_rec in FA_API_TYPES.trans_rec_type
6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

Line 6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type

6634: ,p_asset_hdr_rec in FA_API_TYPES.asset_hdr_rec_type
6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type

Line 6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type

6635: ,p_asset_desc_rec in FA_API_TYPES.asset_desc_rec_type
6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type
6643: ,p_calling_fn in varchar2

Line 6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type

6636: ,p_asset_type_rec in FA_API_TYPES.asset_type_rec_type
6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type
6643: ,p_calling_fn in varchar2
6644: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

Line 6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type

6637: ,p_asset_fin_rec in FA_API_TYPES.asset_fin_rec_type
6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type
6643: ,p_calling_fn in varchar2
6644: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6645: IS

Line 6642: ,p_period_rec in FA_API_TYPES.period_rec_type

6638: ,p_asset_retire_rec in FA_API_TYPES.asset_retire_rec_type
6639: ,p_asset_dist_tbl in FA_API_TYPES.asset_dist_tbl_type
6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type
6643: ,p_calling_fn in varchar2
6644: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6645: IS
6646:

Line 6644: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN

6640: ,p_subcomp_tbl in FA_API_TYPES.subcomp_tbl_type
6641: ,p_inv_tbl in FA_API_TYPES.inv_tbl_type
6642: ,p_period_rec in FA_API_TYPES.period_rec_type
6643: ,p_calling_fn in varchar2
6644: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN
6645: IS
6646:
6647: -- local asset info
6648: l_validation_type varchar2(30);

Line 6649: l_trans_rec FA_API_TYPES.trans_rec_type;

6645: IS
6646:
6647: -- local asset info
6648: l_validation_type varchar2(30);
6649: l_trans_rec FA_API_TYPES.trans_rec_type;
6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

6646:
6647: -- local asset info
6648: l_validation_type varchar2(30);
6649: l_trans_rec FA_API_TYPES.trans_rec_type;
6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

6647: -- local asset info
6648: l_validation_type varchar2(30);
6649: l_trans_rec FA_API_TYPES.trans_rec_type;
6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

6648: l_validation_type varchar2(30);
6649: l_trans_rec FA_API_TYPES.trans_rec_type;
6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

6649: l_trans_rec FA_API_TYPES.trans_rec_type;
6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

6650: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;

Line 6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

6651: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;
6659:

Line 6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

6652: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;
6659:
6660: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

Line 6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;

6653: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;
6659:
6660: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6661:

Line 6658: l_period_rec FA_API_TYPES.period_rec_type;

6654: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6655: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;
6659:
6660: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6661:
6662: l_sum_units number := 0;

Line 6660: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

6656: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
6657: l_inv_tbl FA_API_TYPES.inv_tbl_type;
6658: l_period_rec FA_API_TYPES.period_rec_type;
6659:
6660: lv_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
6661:
6662: l_sum_units number := 0;
6663: l_override_flag varchar2(1);
6664:

Line 7531: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,

7527: | Invoice API instead of making direct DML call. |
7528: | |
7529: +====================================================================*/
7530: FUNCTION REINSTATE_SRC_LINE(
7531: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,

Line 7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,

7528: | |
7529: +====================================================================*/
7530: FUNCTION REINSTATE_SRC_LINE(
7531: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,
7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,

Line 7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,

7529: +====================================================================*/
7530: FUNCTION REINSTATE_SRC_LINE(
7531: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,
7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
7537: p_rowid IN ROWID,

Line 7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,

7530: FUNCTION REINSTATE_SRC_LINE(
7531: px_trans_rec IN OUT NOCOPY FA_API_TYPES.trans_rec_type,
7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,
7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
7537: p_rowid IN ROWID,
7538: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN Is

Line 7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,

7532: px_asset_hdr_rec IN OUT NOCOPY FA_API_TYPES.asset_hdr_rec_type,
7533: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,
7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
7537: p_rowid IN ROWID,
7538: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN Is
7539:
7540: l_calling_fn VARCHAR2(80) := 'fa_retirement_pub.reinstate_src_line';

Line 7538: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN Is

7534: p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
7535: p_invoice_transaction_id IN NUMBER,
7536: p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
7537: p_rowid IN ROWID,
7538: p_calling_fn IN VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN Is
7539:
7540: l_calling_fn VARCHAR2(80) := 'fa_retirement_pub.reinstate_src_line';
7541:
7542: CURSOR New_Asset_Invoices_C (c_asset_invoice_id NUMBER) is

Line 7561: l_trans_rec FA_API_TYPES.trans_rec_type;

7557:
7558: /*
7559: * For calling invoice api
7560: */
7561: l_trans_rec FA_API_TYPES.trans_rec_type;
7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

7558: /*
7559: * For calling invoice api
7560: */
7561: l_trans_rec FA_API_TYPES.trans_rec_type;
7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;

Line 7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

7559: * For calling invoice api
7560: */
7561: l_trans_rec FA_API_TYPES.trans_rec_type;
7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

7560: */
7561: l_trans_rec FA_API_TYPES.trans_rec_type;
7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

7561: l_trans_rec FA_API_TYPES.trans_rec_type;
7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;

7562: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

Line 7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;

7563: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
7571:

Line 7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

7564: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
7571:
7572: l_ind BINARY_INTEGER;

Line 7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

7565: l_new_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
7571:
7572: l_ind BINARY_INTEGER;
7573:

Line 7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

7566: l_new_asset_fin_mrc_tbl FA_API_TYPES.asset_fin_tbl_type;
7567: l_inv_tbl FA_API_TYPES.inv_tbl_type;
7568: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
7569: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
7570: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
7571:
7572: l_ind BINARY_INTEGER;
7573:
7574: l_temp_src_line_id NUMBER;