DBA Data[Home] [Help]

APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_API_TYPES

Line 12: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

8: -- Private variable declarations
9: -- Function and procedure implementations
10:
11: function create_new_asset(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
12: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
13: return boolean is
14: l_total_cost number;
15: l_debug_str varchar2(1000);
16: l_calling_fn varchar2(40) := 'create_new_asset';

Line 103: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

99: END;
100:
101: /*===============================End Of FUNCTION/PROCEDURE===============================*/
102: function cost_adjustment(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
103: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
104: return boolean is
105: l_total_cost number;
106: l_debug_str varchar2(1000);
107: l_calling_fn varchar2(40) := 'cost_asjustment';

Line 178: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

174: END;
175: /*===============================End Of FUNCTION/PROCEDURE===============================*/
176: function check_addition_or_adj(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
177: x_status OUT NOCOPY varchar2,
178: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
179: return boolean is
180: l_asset_id number := 0;
181: begin
182: select ad.asset_id

Line 205: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

201: return false;
202: end;
203: /*===============================End Of FUNCTION/PROCEDURE===============================*/
204: function prepare_asset_key(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
205: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
206: return boolean is
207:
208: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
209: l_akey_segment varchar30_tbl;

Line 511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

507: return false;
508: end;
509: /*===============================End Of FUNCTION/PROCEDURE===============================*/
510: function prepare_category(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
512: return boolean is
513: l_gl_ccid_rec GL_CODE_COMBINATIONS%ROWTYPE;
514: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;
515: l_err_mesg varchar2(500);

Line 844: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

840: -- Created : 5/16/2005 2:30:36 PM
841: -- Purpose : To Prepare asset key and category id for common customers
842:
843: function prep_asset_key_category(p_book_type_code varchar2,
844: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
845: return boolean is
846: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;
847: l_batch_size number := 500;
848: l_count number;

Line 1098: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1094: return false;
1095: end prep_asset_key_category;
1096: /**********************Funtion to merge the mass addition lines****************************/
1097: function merge_lines(p_book_type_code varchar2,
1098: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1099: return boolean is
1100:
1101: cursor parent_mass_add(l_book_type_code varchar2) is
1102: SELECT Mass_Addition_ID,

Line 1168: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1164: end merge_lines;
1165:
1166: /*********************Prepare Expense Account******************************************/
1167: function prepare_expense_ccid(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
1168: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1169: return boolean is
1170: l_exp_acct_col_name fnd_id_flex_segments.application_column_name%TYPE;
1171: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
1172: l_segment varchar30_tbl;

Line 1304: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1300: end;
1301:
1302: /********************************Prepare Location*******************/
1303: function prepare_location_id(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
1304: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1305: return boolean is
1306: l_location_col_name fnd_id_flex_segments.application_column_name%TYPE;
1307: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
1308: TYPE num_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;

Line 1511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1507: return false;
1508: end;
1509: /*===============================End Of FUNCTION/PROCEDURE===============================*/
1510: function prepare_group_asset_id(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
1511: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1512: return boolean is
1513: l_debug_str varchar2(1000);
1514: l_status number;
1515: l_group_asset_rec FA_CREATE_GROUP_ASSET_PKG.group_asset_rec_type;

Line 1545: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

1541: return true;
1542: end;
1543: /*===============================End Of FUNCTION/PROCEDURE===============================*/
1544: function prepare_attributes(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,
1545: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1546: return boolean is
1547: l_status varchar2(10);
1548: l_debug_str varchar2(1000);
1549: old_expense_ccid number := -1;