DBA Data[Home] [Help]

APPS.FA_MASS_RET_PKG dependencies on FA_MASS_RET_PKG

Line 1: PACKAGE BODY FA_MASS_RET_PKG as

1: PACKAGE BODY FA_MASS_RET_PKG as
2: /* $Header: faxmreb.pls 120.35 2010/06/03 09:07:32 spooyath ship $ */
3:
4: g_release number := fa_cache_pkg.fazarel_release;
5:

Line 600: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

596:
597: BEGIN -- Check_Split_Distribution
598:
599: if (g_log_level_rec.statement_level) then
600: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
601: 'Starting',
602: '', p_log_level_rec => g_log_level_rec);
603: end if;
604:

Line 615: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

611: l_units_assigned;
612: While c_cc%FOUND loop
613:
614: if (g_log_level_rec.statement_level) then
615: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
616: 'Starting while loop turn:',
617: i, p_log_level_rec => g_log_level_rec);
618: end if;
619:

Line 628: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

624: l_asset_dist_tbl(i).assigned_to := l_assigned_to;
625:
626:
627: if (g_log_level_rec.statement_level) then
628: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
629: 'asset_id',
630: x_asset_id, p_log_level_rec => g_log_level_rec);
631: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
632: 'ccid',

Line 631: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

627: if (g_log_level_rec.statement_level) then
628: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
629: 'asset_id',
630: x_asset_id, p_log_level_rec => g_log_level_rec);
631: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
632: 'ccid',
633: l_code_combination_id, p_log_level_rec => g_log_level_rec);
634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
635: 'location_id',

Line 634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

630: x_asset_id, p_log_level_rec => g_log_level_rec);
631: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
632: 'ccid',
633: l_code_combination_id, p_log_level_rec => g_log_level_rec);
634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
635: 'location_id',
636: l_location_id, p_log_level_rec => g_log_level_rec);
637: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
638: 'assigned_to',

Line 637: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

633: l_code_combination_id, p_log_level_rec => g_log_level_rec);
634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
635: 'location_id',
636: l_location_id, p_log_level_rec => g_log_level_rec);
637: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
638: 'assigned_to',
639: l_assigned_to, p_log_level_rec => g_log_level_rec);
640: end if;
641:

Line 958: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl) IS

954: ----------------------------------------------------------------------------
955:
956: PROCEDURE Message_tbl(p_Asset_Number IN VARCHAR2,
957: p_num_msg IN OUT NOCOPY NUMBER,
958: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl) IS
959:
960: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
961: msg_tbl FA_MASS_RET_PKG.out_tbl;
962: l_check varchar2(30);

Line 960: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;

956: PROCEDURE Message_tbl(p_Asset_Number IN VARCHAR2,
957: p_num_msg IN OUT NOCOPY NUMBER,
958: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl) IS
959:
960: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
961: msg_tbl FA_MASS_RET_PKG.out_tbl;
962: l_check varchar2(30);
963:
964: BEGIN

Line 961: msg_tbl FA_MASS_RET_PKG.out_tbl;

957: p_num_msg IN OUT NOCOPY NUMBER,
958: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl) IS
959:
960: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
961: msg_tbl FA_MASS_RET_PKG.out_tbl;
962: l_check varchar2(30);
963:
964: BEGIN
965:

Line 1057: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;

1053:
1054: msg_tbl out_tbl;
1055: */
1056:
1057: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
1058: msg_tbl FA_MASS_RET_PKG.out_tbl;
1059:
1060: -- declare 2nd round of allocation
1061:

Line 1058: msg_tbl FA_MASS_RET_PKG.out_tbl;

1054: msg_tbl out_tbl;
1055: */
1056:
1057: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
1058: msg_tbl FA_MASS_RET_PKG.out_tbl;
1059:
1060: -- declare 2nd round of allocation
1061:
1062: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

Line 1302: l_calling_fn varchar2(40) := 'FA_MASS_RET_PKG.allocate_units';

1298: l_check varchar2(30);
1299: l_prev_asset_id number;
1300: l_slask number;
1301: error varchar2(100);
1302: l_calling_fn varchar2(40) := 'FA_MASS_RET_PKG.allocate_units';
1303:
1304: Begin
1305:
1306:

Line 2903: l_calling_fn varchar2(35) := 'FA_MASS_RET_PKG.allocate_assets';

2899: l_Loc_Split VARCHAR2(1);
2900: l_Null_Segment_Flag VARCHAR2(1);
2901: l_Reason_Code VARCHAR2(30);
2902:
2903: l_calling_fn varchar2(35) := 'FA_MASS_RET_PKG.allocate_assets';
2904: l_msg_count number;
2905: l_msg_data varchar2(512);
2906:
2907: l_failure_count NUMBER := 0;

Line 4301: END FA_MASS_RET_PKG;

4297: retcode := 2;
4298:
4299: END Create_Mass_Retirements;
4300:
4301: END FA_MASS_RET_PKG;