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.29.12010000.2 2008/10/21 08:49:57 pvataj ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:

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

600:
601: BEGIN -- Check_Split_Distribution
602:
603: if (g_log_level_rec.statement_level) then
604: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
605: 'Starting',
606: ''
607: ,p_log_level_rec => p_log_level_rec);
608: end if;

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

616: l_units_assigned;
617: While c_cc%FOUND loop
618:
619: if (g_log_level_rec.statement_level) then
620: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
621: 'Starting while loop turn:',
622: i
623: ,p_log_level_rec => p_log_level_rec);
624: end if;

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

630: l_asset_dist_tbl(i).assigned_to := l_assigned_to;
631:
632:
633: if (g_log_level_rec.statement_level) then
634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
635: 'asset_id',
636: x_asset_id
637: ,p_log_level_rec => p_log_level_rec);
638: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

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

634: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
635: 'asset_id',
636: x_asset_id
637: ,p_log_level_rec => p_log_level_rec);
638: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
639: 'ccid',
640: l_code_combination_id
641: ,p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

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

638: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
639: 'ccid',
640: l_code_combination_id
641: ,p_log_level_rec => p_log_level_rec);
642: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
643: 'location_id',
644: l_location_id
645: ,p_log_level_rec => p_log_level_rec);
646: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',

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

642: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
643: 'location_id',
644: l_location_id
645: ,p_log_level_rec => p_log_level_rec);
646: fa_debug_pkg.add('FA_MASS_RET_PKG.check_split...',
647: 'assigned_to',
648: l_assigned_to
649: ,p_log_level_rec => p_log_level_rec);
650: end if;

Line 984: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl

980: ----------------------------------------------------------------------------
981:
982: PROCEDURE Message_tbl(p_Asset_Number IN VARCHAR2,
983: p_num_msg IN OUT NOCOPY NUMBER,
984: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl
985: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
986:
987: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
988: msg_tbl FA_MASS_RET_PKG.out_tbl;

Line 987: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;

983: p_num_msg IN OUT NOCOPY NUMBER,
984: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl
985: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
986:
987: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
988: msg_tbl FA_MASS_RET_PKG.out_tbl;
989: l_check varchar2(30);
990:
991: BEGIN

Line 988: msg_tbl FA_MASS_RET_PKG.out_tbl;

984: p_msg_tbl IN OUT NOCOPY FA_MASS_RET_PKG.out_tbl
985: ,p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
986:
987: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
988: msg_tbl FA_MASS_RET_PKG.out_tbl;
989: l_check varchar2(30);
990:
991: BEGIN
992:

Line 1086: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;

1082:
1083: msg_tbl out_tbl;
1084: */
1085:
1086: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
1087: msg_tbl FA_MASS_RET_PKG.out_tbl;
1088:
1089: -- declare 2nd round of allocation
1090:

Line 1087: msg_tbl FA_MASS_RET_PKG.out_tbl;

1083: msg_tbl out_tbl;
1084: */
1085:
1086: l_unit_msg_rec FA_MASS_RET_PKG.out_rec;
1087: msg_tbl FA_MASS_RET_PKG.out_tbl;
1088:
1089: -- declare 2nd round of allocation
1090:
1091: l_asset_dist_tbl FA_API_TYPES.asset_dist_tbl_type;

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

1327: l_check varchar2(30);
1328: l_prev_asset_id number;
1329: l_slask number;
1330: error varchar2(100);
1331: l_calling_fn varchar2(40) := 'FA_MASS_RET_PKG.allocate_units';
1332:
1333: Begin
1334:
1335:

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

3069: l_Loc_Split VARCHAR2(1);
3070: l_Null_Segment_Flag VARCHAR2(1);
3071: l_Reason_Code VARCHAR2(30);
3072:
3073: l_calling_fn varchar2(35) := 'FA_MASS_RET_PKG.allocate_assets';
3074: l_msg_count number;
3075: l_msg_data varchar2(512);
3076:
3077: l_failure_count NUMBER := 0;

Line 4424: END FA_MASS_RET_PKG;

4420: retcode := 2;
4421:
4422: END Create_Mass_Retirements;
4423:
4424: END FA_MASS_RET_PKG;