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.6 2006/01/09 05:30:10 snarayan noship $ */
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 INDEX BY PLS_INTEGER;
17: l_mass_add_tbl mass_add_tbl;

Line 385: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;

381: errbuf OUT NOCOPY VARCHAR2,
382: retcode OUT NOCOPY NUMBER,
383: p_book_type_code IN varchar2) is
384:
385: l_mass_add_rec FA_MASSADD_PREPARE_PKG.mass_add_rec;
386:
387: l_procedure_name varchar2(4000);
388: l_label varchar2(4000);
389: l_request_id NUMBER;

Line 402: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;

398: TYPE num_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
399: TYPE date_tbl IS TABLE OF DATE INDEX BY BINARY_INTEGER;
400: TYPE v100_tbl IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
401:
402: l_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl;
403: --l_mass_add_dist_tbl mass_add_dist_tbl;
404:
405: status varchar2(15);
406: l_dist_MASSADD_DIST_ID num_tbl;

Line 783: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_MASSADD_PREPARE_PKG.prepare_mass_additions',

779: exception
780: WHEN others THEN
781: retcode := 2;
782: rollback;
783: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_MASSADD_PREPARE_PKG.prepare_mass_additions',
784: p_log_level_rec => g_log_level_rec);
785:
786: end;
787: /*===============================End Of FUNCTION/PROCEDURE===============================*/

Line 788: end FA_MASSADD_PREPARE_PKG;

784: p_log_level_rec => g_log_level_rec);
785:
786: end;
787: /*===============================End Of FUNCTION/PROCEDURE===============================*/
788: end FA_MASSADD_PREPARE_PKG;