DBA Data[Home] [Help]

APPS.FA_MASSADD_PREPARE_PKG dependencies on FA_MASSADD_PREPARE_PKG

Line 1: package body FA_MASSADD_PREPARE_PKG as

1: package body FA_MASSADD_PREPARE_PKG as
2: /* $Header: FAMAPREPB.pls 120.7.12020000.2 2012/07/23 08:34:03 rmandali ship $ */
3:
4: -- Private type declarations
5:

Line 13: FUNCTION update_mass_additions (p_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl

9: g_log_level_rec fa_api_types.log_level_rec_type;
10: -- Function and procedure implementations
11:
12: /*===============================End Of FUNCTION/PROCEDURE===============================*/
13: FUNCTION update_mass_additions (p_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type DEFAULT NULL)
15: RETURN BOOLEAN IS
16: TYPE mass_add_tbl IS TABLE OF fa_mass_additions%ROWTYPE
17: INDEX BY PLS_INTEGER;

Line 235: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;

231: /*main procedure for concurrent program*/
232: PROCEDURE prepare_mass_additions (errbuf OUT NOCOPY VARCHAR2,
233: retcode OUT NOCOPY NUMBER,
234: p_book_type_code IN VARCHAR2 ) IS
235: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;
236:
237: l_procedure_name VARCHAR2 (4000);
238: l_label VARCHAR2 (4000);
239: l_request_id NUMBER;

Line 259: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;

255:
256: TYPE v100_tbl IS TABLE OF VARCHAR2 (100)
257: INDEX BY BINARY_INTEGER;
258:
259: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;
260: --l_mass_add_dist_tbl mass_add_dist_tbl;
261:
262: status VARCHAR2 (15);
263: l_dist_MASSADD_DIST_ID num_tbl;

Line 621: FA_SRVR_MSG.ADD_MESSAGE ( CALLING_FN => 'FA_MASSADD_PREPARE_PKG.prepare_mass_additions', p_log_level_rec => g_log_level_rec);

617: EXCEPTION
618: WHEN OTHERS THEN
619: retcode := 2;
620: ROLLBACK;
621: FA_SRVR_MSG.ADD_MESSAGE ( CALLING_FN => 'FA_MASSADD_PREPARE_PKG.prepare_mass_additions', p_log_level_rec => g_log_level_rec);
622: END;
623: /*===============================End Of FUNCTION/PROCEDURE===============================*/
624: END FA_MASSADD_PREPARE_PKG;

Line 624: END FA_MASSADD_PREPARE_PKG;

620: ROLLBACK;
621: FA_SRVR_MSG.ADD_MESSAGE ( CALLING_FN => 'FA_MASSADD_PREPARE_PKG.prepare_mass_additions', p_log_level_rec => g_log_level_rec);
622: END;
623: /*===============================End Of FUNCTION/PROCEDURE===============================*/
624: END FA_MASSADD_PREPARE_PKG;