DBA Data[Home] [Help]

APPS.FA_CREATE_GROUP_ASSET_PKG dependencies on FA_API_TYPES

Line 11: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type DEFAULT NULL)

7:
8: -- Private variable declarations
9: -- Function and procedure implementations
10: FUNCTION create_group_asset (px_group_asset_rec IN OUT NOCOPY group_asset_rec_type
11: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type DEFAULT NULL)
12: RETURN BOOLEAN IS
13: l_debug_str VARCHAR2 (1000);
14: l_status VARCHAR2 (5);
15: l_mesg_count NUMBER;

Line 77: l_trans_rec FA_API_TYPES.trans_rec_type;

73: l_group_akey_segment8 VARCHAR2 (30);
74: l_group_akey_segment9 VARCHAR2 (30);
75: l_group_akey_segment10 VARCHAR2 (30);
76:
77: l_trans_rec FA_API_TYPES.trans_rec_type;
78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

74: l_group_akey_segment9 VARCHAR2 (30);
75: l_group_akey_segment10 VARCHAR2 (30);
76:
77: l_trans_rec FA_API_TYPES.trans_rec_type;
78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

Line 79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

75: l_group_akey_segment10 VARCHAR2 (30);
76:
77: l_trans_rec FA_API_TYPES.trans_rec_type;
78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

Line 80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

76:
77: l_trans_rec FA_API_TYPES.trans_rec_type;
78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

Line 81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

77: l_trans_rec FA_API_TYPES.trans_rec_type;
78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

Line 82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;

78: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

Line 83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;

79: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

80: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;

81: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;
89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

Line 86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;

82: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;
89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
90: l_calling_fn VARCHAR2 (40) := 'create_group_asset';

Line 87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

83: l_asset_hierarchy_rec FA_API_TYPES.asset_hierarchy_rec_type;
84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;
89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
90: l_calling_fn VARCHAR2 (40) := 'create_group_asset';
91:

Line 88: l_inv_tbl FA_API_TYPES.inv_tbl_type;

84: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;
89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
90: l_calling_fn VARCHAR2 (40) := 'create_group_asset';
91:
92: l_asset_type VARCHAR2 (15);

Line 89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;

85: l_asset_deprn_rec FA_API_TYPES.asset_deprn_rec_type;
86: l_asset_dist_rec FA_API_TYPES.asset_dist_rec_type;
87: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
88: l_inv_tbl FA_API_TYPES.inv_tbl_type;
89: l_inv_rate_tbl FA_API_TYPES.inv_rate_tbl_type;
90: l_calling_fn VARCHAR2 (40) := 'create_group_asset';
91:
92: l_asset_type VARCHAR2 (15);
93: l_CALENDAR_PERIOD_OPEN_DATE DATE;

Line 95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

91:
92: l_asset_type VARCHAR2 (15);
93: l_CALENDAR_PERIOD_OPEN_DATE DATE;
94:
95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

Line 96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;

92: l_asset_type VARCHAR2 (15);
93: l_CALENDAR_PERIOD_OPEN_DATE DATE;
94:
95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

Line 97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;

93: l_CALENDAR_PERIOD_OPEN_DATE DATE;
94:
95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

Line 98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;

94:
95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;

Line 99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;

95: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;
103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

Line 100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;

96: l_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type;
97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;
103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
104: l_return_status VARCHAR2 (1);

Line 101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;

97: l_asset_fin_mrc_tbl_new FA_API_TYPES.asset_fin_tbl_type;
98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;
103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
104: l_return_status VARCHAR2 (1);
105:

Line 102: l_inv_rec FA_API_TYPES.inv_rec_type;

98: l_inv_trans_rec FA_API_TYPES.inv_trans_rec_type;
99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;
103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
104: l_return_status VARCHAR2 (1);
105:
106: CURSOR lookup_cur (c_lookup_type VARCHAR2) IS

Line 103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;

99: l_asset_deprn_rec_adj FA_API_TYPES.asset_deprn_rec_type;
100: l_asset_deprn_rec_new FA_API_TYPES.asset_deprn_rec_type;
101: l_asset_deprn_mrc_tbl_new FA_API_TYPES.asset_deprn_tbl_type;
102: l_inv_rec FA_API_TYPES.inv_rec_type;
103: l_group_reclass_options_rec FA_API_TYPES.group_reclass_options_rec_type;
104: l_return_status VARCHAR2 (1);
105:
106: CURSOR lookup_cur (c_lookup_type VARCHAR2) IS
107: SELECT lookup_code