1: PACKAGE BODY cse_fac_inservice_pkg AS
2: /* $Header: CSEFPISB.pls 120.31 2011/12/29 09:11:41 jrkumar ship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('CSE_DEBUG_OPTION'),'N');
5: g_request_id NUMBER := NVL(FND_GLOBAL.conc_request_id,-1);
6:
7: PROCEDURE debug(
8: p_message IN varchar2)
649: FROM fa_locations
650: WHERE upper(segment1||segment2||segment3||segment4||segment5||segment6||segment7) =
651: upper(l_asset_location);
652:
653: --l_book_type_code := fnd_profile.value('cse_fa_book_type_code');
654:
655: l_asset_attrib_rec.instance_id := p_instance_id; -- Bug 6492235, added for multiple FA book support
656:
657: l_book_type_code := cse_asset_util_pkg.book_type(
914: l_fa_group_by varchar2(30);
915: l_serial_number varchar2(200);
916:
917: l_dpis date;
918: l_book_type_code varchar2(30) := fnd_profile.value('CSE_FA_BOOK_TYPE_CODE');
919:
920: l_processed_flag varchar2(1) := 'N';
921: l_process_flag boolean := FALSE;
922: l_project_id NUMBER; -- Added for Bug 9326077