DBA Data[Home] [Help]

APPS.FA_MASSADD_PREP_ENERGY_PKG dependencies on FA_MASSADD_PREPARE_PKG

Line 11: function create_new_asset(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

7:
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);

Line 102: function cost_adjustment(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

98: return false;
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);

Line 176: function check_addition_or_adj(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

172: ROLLBACK;
173: return false;
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;

Line 204: function prepare_asset_key(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

200: x_status := 'FAILED';
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;

Line 510: function prepare_category(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

506: when others then
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;

Line 514: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;

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);
516: l_calling_fn varchar2(40) := 'prepare_category';
517: TYPE varchar30_tbl IS TABLE OF varchar2(30) INDEX BY BINARY_INTEGER;
518: TYPE num_tbl IS TABLE OF number INDEX BY BINARY_INTEGER;

Line 846: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;

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;
849: Result boolean;
850: l_status number;

Line 853: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;

849: Result boolean;
850: l_status number;
851: l_debug_str varchar2(1000);
852:
853: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;
854:
855: --l_mass_add_dist_tbl mass_add_dist_tbl;
856: l_calling_fn varchar2(40) := 'prepare_aset_key_category';
857: --Cursor to get all mass_addition lines

Line 1083: FA_MASSADD_PREPARE_PKG.update_mass_additions(l_mass_add_rec_tbl,

1079: '',
1080: p_log_level_rec => p_log_level_rec);
1081: end if;
1082: if not
1083: FA_MASSADD_PREPARE_PKG.update_mass_additions(l_mass_add_rec_tbl,
1084: p_log_level_rec => p_log_level_rec) then
1085: l_debug_str := 'update_mass_additions returned failure';
1086: end if;
1087: commit;

Line 1167: function prepare_expense_ccid(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

1163:
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;

Line 1303: function prepare_location_id(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

1299:
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;

Line 1510: function prepare_group_asset_id(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

1506: px_mass_add_rec.LOCATION_ID := l_location_id;
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;

Line 1544: function prepare_attributes(px_mass_add_rec IN out NOCOPY FA_MASSADD_PREPARE_PKG.mass_add_rec,

1540: px_mass_add_rec.group_asset_id := l_group_asset_rec.group_asset_id;
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);