DBA Data[Home] [Help]

APPS.FA_AFE_TRANSACTIONS_PKG dependencies on FA_API_TYPES

Line 18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

14: FUNCTION get_new_ccid(p_book_type_code varchar2,
15: p_old_expense_ccid number,
16: p_overlay_seg_val number,
17: x_new_expense_ccid out NOCOPY number,
18: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
19: return boolean IS
20:
21: h_mesg_name VARCHAR2(30);
22: h_new_deprn_exp_acct VARCHAR2(26);

Line 167: function process_capitalize(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,

163:
164: END get_new_ccid;
165:
166: -- Purpose : To capitalize the assets
167: function process_capitalize(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
168: p_asset_id number,
169: p_new_asset_key_ccid number,
170: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
171: return boolean is

Line 170: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

166: -- Purpose : To capitalize the assets
167: function process_capitalize(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
168: p_asset_id number,
169: p_new_asset_key_ccid number,
170: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
171: return boolean is
172: Result boolean;
173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 173: l_trans_rec FA_API_TYPES.trans_rec_type;

169: p_new_asset_key_ccid number,
170: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
171: return boolean is
172: Result boolean;
173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

170: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
171: return boolean is
172: Result boolean;
173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
178:

Line 175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

171: return boolean is
172: Result boolean;
173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
178:
179: l_CALENDAR_PERIOD_OPEN_DATE date;

Line 176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

172: Result boolean;
173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
178:
179: l_CALENDAR_PERIOD_OPEN_DATE date;
180: l_return_status VARCHAR2(1);

Line 177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

173: l_trans_rec FA_API_TYPES.trans_rec_type;
174: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
175: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
176: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
177: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
178:
179: l_CALENDAR_PERIOD_OPEN_DATE date;
180: l_return_status VARCHAR2(1);
181: l_mesg_count number := 0;

Line 189: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

185: cost_center_seg varchar(50);
186: cost_center_seg_index number;
187: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
188: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
189: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
190: l_gl_ccid_enabled_flag varchar2(1);
191: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
192: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
193: l_segment varchar30_tbl;

Line 191: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;

187: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
188: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
189: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
190: l_gl_ccid_enabled_flag varchar2(1);
191: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
192: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
193: l_segment varchar30_tbl;
194: l_err_stage varchar2(250);
195: l_calling_fn varchar2(40) := 'FA_AFE_TRANSACTIONS_PKG.process_capitalize';

Line 456: function process_dry_hole(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,

452: when others then
453: return false;
454: end process_capitalize;
455:
456: function process_dry_hole(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
457: p_asset_id number,
458: p_new_asset_key_ccid number,
459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
460: return boolean is

Line 459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

455:
456: function process_dry_hole(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
457: p_asset_id number,
458: p_new_asset_key_ccid number,
459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
460: return boolean is
461: Result boolean;
462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

Line 462: l_trans_rec FA_API_TYPES.trans_rec_type;

458: p_new_asset_key_ccid number,
459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
460: return boolean is
461: Result boolean;
462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

Line 463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

459: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
460: return boolean is
461: Result boolean;
462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
467:

Line 464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;

460: return boolean is
461: Result boolean;
462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
467:
468: l_CALENDAR_PERIOD_OPEN_DATE date;

Line 465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;

461: Result boolean;
462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
467:
468: l_CALENDAR_PERIOD_OPEN_DATE date;
469: l_return_status VARCHAR2(1);

Line 466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;

462: l_trans_rec FA_API_TYPES.trans_rec_type;
463: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
464: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
465: l_asset_desc_rec FA_API_TYPES.asset_desc_rec_type;
466: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
467:
468: l_CALENDAR_PERIOD_OPEN_DATE date;
469: l_return_status VARCHAR2(1);
470: l_mesg_count number := 0;

Line 478: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;

474: cost_center_seg varchar(50);
475: cost_center_seg_index number;
476: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
477: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
478: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
479: l_gl_ccid_enabled_flag varchar2(1);
480: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
481: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
482: l_segment varchar30_tbl;

Line 480: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;

476: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;
477: l_ACCOUNTING_FLEX_STRUCTURE fa_book_controls.accounting_flex_structure%type;
478: l_asset_dist_tbl fa_api_types.asset_dist_tbl_type;
479: l_gl_ccid_enabled_flag varchar2(1);
480: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
481: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
482: l_segment varchar30_tbl;
483: l_err_stage varchar2(250);
484: l_calling_fn varchar2(40) := 'FA_AFE_TRANSACTIONS_PKG.process_dry_hole';

Line 743: function process_expense(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,

739: when others then
740: return false;
741: end process_dry_hole;
742:
743: function process_expense(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
744: p_asset_id number,
745: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
746: return boolean is
747: Result boolean;

Line 745: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)

741: end process_dry_hole;
742:
743: function process_expense(p_trans_int_rec FA_API_TYPES.trans_interface_rec_type,
744: p_asset_id number,
745: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
746: return boolean is
747: Result boolean;
748: l_book_type_code varchar2(30);
749: l_trans_rec FA_API_TYPES.trans_rec_type;

Line 749: l_trans_rec FA_API_TYPES.trans_rec_type;

745: p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
746: return boolean is
747: Result boolean;
748: l_book_type_code varchar2(30);
749: l_trans_rec FA_API_TYPES.trans_rec_type;
750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;

746: return boolean is
747: Result boolean;
748: l_book_type_code varchar2(30);
749: l_trans_rec FA_API_TYPES.trans_rec_type;
750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

Line 751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;

747: Result boolean;
748: l_book_type_code varchar2(30);
749: l_trans_rec FA_API_TYPES.trans_rec_type;
750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
755: l_inv_tbl FA_API_TYPES.inv_tbl_type;

Line 752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;

748: l_book_type_code varchar2(30);
749: l_trans_rec FA_API_TYPES.trans_rec_type;
750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
755: l_inv_tbl FA_API_TYPES.inv_tbl_type;
756:

Line 753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

749: l_trans_rec FA_API_TYPES.trans_rec_type;
750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
755: l_inv_tbl FA_API_TYPES.inv_tbl_type;
756:
757: l_api_version number := 1;

Line 754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;

750: l_dist_trans_rec FA_API_TYPES.trans_rec_type;
751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
755: l_inv_tbl FA_API_TYPES.inv_tbl_type;
756:
757: l_api_version number := 1;
758: l_init_msg_list varchar2(1) := FND_API.G_FALSE;

Line 755: l_inv_tbl FA_API_TYPES.inv_tbl_type;

751: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
752: l_asset_retire_rec FA_API_TYPES.asset_retire_rec_type;
753: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;
754: l_subcomp_tbl FA_API_TYPES.subcomp_tbl_type;
755: l_inv_tbl FA_API_TYPES.inv_tbl_type;
756:
757: l_api_version number := 1;
758: l_init_msg_list varchar2(1) := FND_API.G_FALSE;
759: l_commit varchar2(1) := FND_API.G_FALSE;

Line 767: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;

763: l_mesg_count number := 0;
764: l_mesg_len number;
765: l_mesg varchar2(4000);
766:
767: l_log_level_rec FA_API_TYPES.log_level_rec_type := p_log_level_rec;
768:
769: l_err_stage varchar2(250);
770: l_calling_fn varchar2(40) := 'FA_AFE_TRANSACTIONS_PKG.process_expense';
771: begin