eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_ASSET_VAL_PVT dependencies on FND_API

Line 385: p_asset_fin_rec.group_asset_id <> FND_API.G_MISS_NUM and

381:
382: end if; -- corporate
383:
384: if (p_asset_fin_rec.group_asset_id is not null and
385: p_asset_fin_rec.group_asset_id <> FND_API.G_MISS_NUM and
386: nvl(fa_cache_pkg.fazcbc_record.allow_interco_group_flag, 'N') <> 'Y') then
387: if not fa_interco_pvt.validate_grp_interco
388: (p_asset_hdr_rec => p_asset_hdr_rec,
389: p_trans_rec => p_trans_rec,

Line 400: nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

396: end if;
397:
398: /*Bug 8728813 - Member Assets can not have initial reserve - start*/
399: if (p_trans_rec.transaction_type_code = 'ADDITION' and
400: nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
401: nvl(p_asset_deprn_rec.deprn_reserve,0) <> 0 and
402: nvl(p_asset_deprn_rec.ytd_deprn,0) <> 0) then
403: fa_srvr_msg.add_message(
404: calling_fn => p_calling_fn,

Line 412: if nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

408: end if;
409: /*Bug 8728813 - Member Assets can not have initial reserve - end*/
410:
411: /*Bug 8828394 - Group Asset ID should be valid Group Asset ID - Begin*/
412: if nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
413: if not validate_group_asset_id(
414: p_asset_id => p_asset_fin_rec.group_asset_id,
415: p_log_level_rec => p_log_level_rec
416: ) then

Line 4044: if (p_bonus_rule is not null) and (p_bonus_rule <> FND_API.G_MISS_CHAR) then

4040: */
4041:
4042: /* Japan Tax Phase3 -- Bonus is allowed
4043: Commenting the validation
4044: if (p_bonus_rule is not null) and (p_bonus_rule <> FND_API.G_MISS_CHAR) then
4045: fa_srvr_msg.add_message(
4046: calling_fn => l_calling_fn,
4047: name => 'FA_BONUS_DUAL_RATE', p_log_level_rec => p_log_level_rec);
4048:

Line 4385: (nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then

4381:
4382: -- Bug 7491880 Validation for extended deprn on group/member
4383: if (p_asset_type_rec.asset_type = 'GROUP') OR
4384: (p_asset_fin_rec_old.group_asset_id is not null) OR
4385: (nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then
4386:
4387: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
4388: name => 'FA_EXT_DPRN_NOT_ALLOWED_ON_GRP',
4389: p_log_level_rec => p_log_level_rec);

Line 5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND

5507: p_log_level_rec IN fa_api_types.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN IS
5508:
5509: BEGIN
5510:
5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
5512: (NVL(p_asset_fin_rec_new.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
5513: IF NVL(p_asset_fin_rec_old.tracking_method, FND_API.G_MISS_CHAR) <>
5514: NVL(p_asset_fin_rec_new.tracking_method, FND_API.G_MISS_CHAR) AND
5515: (p_group_reclass_options_rec.group_reclass_type = 'CALC') THEN

Line 5512: (NVL(p_asset_fin_rec_new.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN

5508:
5509: BEGIN
5510:
5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
5512: (NVL(p_asset_fin_rec_new.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
5513: IF NVL(p_asset_fin_rec_old.tracking_method, FND_API.G_MISS_CHAR) <>
5514: NVL(p_asset_fin_rec_new.tracking_method, FND_API.G_MISS_CHAR) AND
5515: (p_group_reclass_options_rec.group_reclass_type = 'CALC') THEN
5516: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_ASSET_VAL_PVT.validate_grp_track_method',

Line 5513: IF NVL(p_asset_fin_rec_old.tracking_method, FND_API.G_MISS_CHAR) <>

5509: BEGIN
5510:
5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
5512: (NVL(p_asset_fin_rec_new.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
5513: IF NVL(p_asset_fin_rec_old.tracking_method, FND_API.G_MISS_CHAR) <>
5514: NVL(p_asset_fin_rec_new.tracking_method, FND_API.G_MISS_CHAR) AND
5515: (p_group_reclass_options_rec.group_reclass_type = 'CALC') THEN
5516: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_ASSET_VAL_PVT.validate_grp_track_method',
5517: NAME => 'FA_GRP_RCL_TRACK_MISMATCH',

Line 5514: NVL(p_asset_fin_rec_new.tracking_method, FND_API.G_MISS_CHAR) AND

5510:
5511: IF (NVL(p_asset_fin_rec_old.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) AND
5512: (NVL(p_asset_fin_rec_new.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) THEN
5513: IF NVL(p_asset_fin_rec_old.tracking_method, FND_API.G_MISS_CHAR) <>
5514: NVL(p_asset_fin_rec_new.tracking_method, FND_API.G_MISS_CHAR) AND
5515: (p_group_reclass_options_rec.group_reclass_type = 'CALC') THEN
5516: FA_SRVR_MSG.ADD_MESSAGE(CALLING_FN => 'FA_ASSET_VAL_PVT.validate_grp_track_method',
5517: NAME => 'FA_GRP_RCL_TRACK_MISMATCH',
5518: TOKEN1 => 'EXISTING_TRACK_METHOD',

Line 5635: IF (nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM and

5631:
5632: IF fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' THEN
5633: IF l_asset_type_rec.asset_type = 'CAPITALIZED' THEN
5634: -- During reclass into group, Group should have tracking method of ALLOCATE if asset is added with reserve.
5635: IF (nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM and
5636: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) THEN -- reclass case
5637: open c_asset_with_reserve;
5638: fetch c_asset_with_reserve into l_dummy_num_rsv;
5639: close c_asset_with_reserve;

Line 5636: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) THEN -- reclass case

5632: IF fa_cache_pkg.fazccmt_record.rate_source_rule = 'PRODUCTION' THEN
5633: IF l_asset_type_rec.asset_type = 'CAPITALIZED' THEN
5634: -- During reclass into group, Group should have tracking method of ALLOCATE if asset is added with reserve.
5635: IF (nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM and
5636: nvl(p_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM ) THEN -- reclass case
5637: open c_asset_with_reserve;
5638: fetch c_asset_with_reserve into l_dummy_num_rsv;
5639: close c_asset_with_reserve;
5640:

Line 5664: nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

5660: END IF; -- reclass case
5661:
5662: -- Asset cannot be reclassed out of group if it was added with reserve when depreciate_flag = YES
5663: /* IF (l_asset_fin_rec.depreciate_flag = 'YES' and
5664: nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
5665: p_asset_fin_rec_adj.group_asset_id = FND_API.G_MISS_NUM ) THEN -- reclass out case
5666:
5667: open c_asset_with_reserve;
5668: fetch c_asset_with_reserve into l_dummy_num_rsv;

Line 5665: p_asset_fin_rec_adj.group_asset_id = FND_API.G_MISS_NUM ) THEN -- reclass out case

5661:
5662: -- Asset cannot be reclassed out of group if it was added with reserve when depreciate_flag = YES
5663: /* IF (l_asset_fin_rec.depreciate_flag = 'YES' and
5664: nvl(l_asset_fin_rec.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
5665: p_asset_fin_rec_adj.group_asset_id = FND_API.G_MISS_NUM ) THEN -- reclass out case
5666:
5667: open c_asset_with_reserve;
5668: fetch c_asset_with_reserve into l_dummy_num_rsv;
5669: close c_asset_with_reserve;

Line 5684: /* IF nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN

5680: IF l_asset_fin_rec.depreciate_flag = 'NO' THEN
5681:
5682: -- No transaction allowed on members asset with depreciate_flag = 'NO' except,
5683: -- a) moving out of group b) Setting depreciate_flag = 'YES'
5684: /* IF nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5685:
5686: IF (nvl(p_asset_fin_rec_adj.group_asset_id,-99) <> FND_API.G_MISS_NUM AND Commented for ENH 12600386 */
5687: IF ( nvl(p_asset_fin_rec_adj.depreciate_flag,'NO') <> 'YES' ) THEN /* Added for ENH 12600386 */
5688: fa_srvr_msg.add_message(calling_fn => l_calling_fn,

Line 5686: IF (nvl(p_asset_fin_rec_adj.group_asset_id,-99) <> FND_API.G_MISS_NUM AND Commented for ENH 12600386 */

5682: -- No transaction allowed on members asset with depreciate_flag = 'NO' except,
5683: -- a) moving out of group b) Setting depreciate_flag = 'YES'
5684: /* IF nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
5685:
5686: IF (nvl(p_asset_fin_rec_adj.group_asset_id,-99) <> FND_API.G_MISS_NUM AND Commented for ENH 12600386 */
5687: IF ( nvl(p_asset_fin_rec_adj.depreciate_flag,'NO') <> 'YES' ) THEN /* Added for ENH 12600386 */
5688: fa_srvr_msg.add_message(calling_fn => l_calling_fn,
5689: name => 'FA_PROD_MEM_INVALID_TRANS',
5690: p_log_level_rec => p_log_level_rec);

Line 5709: END IF; -- nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN Commented for ENH 12600386 */

5705: p_log_level_rec => p_log_level_rec);
5706: return FALSE;
5707: END IF;
5708: END IF;
5709: END IF; -- nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN Commented for ENH 12600386 */
5710: ELSE
5711: -- Check if member's group has any other members with depreciate_flag = NO. If so, raise error.
5712: -- Allowed transactions for such cases is, setting depreciating flag = NO and group reclass
5713: -- (out or assign to other group)

Line 5716: nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

5712: -- Allowed transactions for such cases is, setting depreciating flag = NO and group reclass
5713: -- (out or assign to other group)
5714:
5715: IF ( nvl(p_asset_fin_rec_adj.depreciate_flag,'YES') = 'YES' and
5716: nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
5717: nvl(p_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec.group_asset_id) <>
5718: FND_API.G_MISS_NUM and
5719: nvl(p_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec.group_asset_id) =
5720: l_asset_fin_rec.group_asset_id) THEN

Line 5718: FND_API.G_MISS_NUM and

5714:
5715: IF ( nvl(p_asset_fin_rec_adj.depreciate_flag,'YES') = 'YES' and
5716: nvl(l_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
5717: nvl(p_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec.group_asset_id) <>
5718: FND_API.G_MISS_NUM and
5719: nvl(p_asset_fin_rec_adj.group_asset_id,l_asset_fin_rec.group_asset_id) =
5720: l_asset_fin_rec.group_asset_id) THEN
5721:
5722: h_asset_id := l_asset_fin_rec.group_asset_id;

Line 6447: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) then

6443: fa_debug_pkg.add(l_calling_fn, 'p_asset_deprn_rec.bonus_deprn_reserve', p_asset_deprn_rec.bonus_deprn_reserve, p_log_level_rec);
6444: END IF;
6445:
6446: -- No bonus rule for group asset
6447: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR ) then
6448: if (p_asset_type_rec.asset_type = 'GROUP' ) then
6449: fa_srvr_msg.add_message(
6450: calling_fn => p_calling_fn,
6451: name =>'FA_NO_BONUS_FOR_GROUP',

Line 6457: if ( (nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

6453: return false;
6454: end if;
6455:
6456: -- No bonus rule for member asset
6457: if ( (nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
6458: nvl(p_asset_fin_rec.member_rollup_flag,'Z') <> 'Y' )
6459: ) then
6460: fa_srvr_msg.add_message(
6461: calling_fn => p_calling_fn,

Line 6469: if (p_asset_deprn_rec.bonus_deprn_reserve <> FND_API.G_MISS_NUM AND

6465: end if;
6466: end if;
6467:
6468: -- No bonus_reserve when no bonus rule specified
6469: if (p_asset_deprn_rec.bonus_deprn_reserve <> FND_API.G_MISS_NUM AND
6470: nvl(p_asset_deprn_rec.bonus_deprn_reserve,0) <> 0
6471: ) then
6472: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR )then
6473: fa_srvr_msg.add_message(

Line 6472: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR )then

6468: -- No bonus_reserve when no bonus rule specified
6469: if (p_asset_deprn_rec.bonus_deprn_reserve <> FND_API.G_MISS_NUM AND
6470: nvl(p_asset_deprn_rec.bonus_deprn_reserve,0) <> 0
6471: ) then
6472: if (nvl(p_asset_fin_rec.bonus_rule,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR )then
6473: fa_srvr_msg.add_message(
6474: calling_fn => p_calling_fn,
6475: name =>'FA_BONUS_RULE_NO_RESV',
6476: p_log_level_rec => p_log_level_rec);

Line 6616: if nvl(p_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

6612: open corp_method_details;
6613: fetch corp_method_details into l_corp_method_code, l_corp_rate_source_rule, l_corp_deprn_basis_rule;
6614: close corp_method_details;
6615: end if;
6616: if nvl(p_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
6617: open group_method_details(p_asset_fin_rec_old.group_asset_id);
6618: fetch group_method_details into l_old_grp_method_code, l_old_grp_rate_source_rule, l_old_grp_deprn_basis_rule;
6619: close group_method_details;
6620: end if;

Line 6621: if nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then

6617: open group_method_details(p_asset_fin_rec_old.group_asset_id);
6618: fetch group_method_details into l_old_grp_method_code, l_old_grp_rate_source_rule, l_old_grp_deprn_basis_rule;
6619: close group_method_details;
6620: end if;
6621: if nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM then
6622: open group_method_details(p_asset_fin_rec.group_asset_id);
6623: fetch group_method_details into l_grp_method_code, l_grp_rate_source_rule, l_grp_deprn_basis_rule;
6624: close group_method_details;
6625: end if;

Line 6654: if ( (nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

6650:
6651: l_group_asset_id := nvl(p_asset_fin_rec.group_asset_id,p_asset_fin_rec_old.group_asset_id);
6652:
6653: -- No UOP for member asset
6654: if ( (nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
6655: nvl(p_asset_fin_rec.member_rollup_flag,'Z') <> 'Y' )
6656: ) then
6657: fa_srvr_msg.add_message(
6658: calling_fn => l_calling_fn,

Line 6666: if (nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> nvl(p_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM) and

6662: end if;
6663: end if;
6664:
6665: --Check for group assignment or change
6666: if (nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> nvl(p_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM) and
6667: nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM )
6668: then
6669: if ( l_grp_rate_source_rule = 'PRODUCTION' and l_grp_deprn_basis_rule = 'NBV'
6670: and

Line 6667: nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM )

6663: end if;
6664:
6665: --Check for group assignment or change
6666: if (nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> nvl(p_asset_fin_rec_old.group_asset_id,FND_API.G_MISS_NUM) and
6667: nvl(p_asset_fin_rec.group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM )
6668: then
6669: if ( l_grp_rate_source_rule = 'PRODUCTION' and l_grp_deprn_basis_rule = 'NBV'
6670: and
6671: (l_rate_source_rule <> 'PRODUCTION' OR l_deprn_basis_rule <> 'NBV') )then

Line 6865: if not (nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM) =

6861: px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
6862: p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN IS
6863: l_fin_info_changed BOOLEAN := TRUE;
6864: BEGIN
6865: if not (nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM) =
6866: nvl(p_asset_fin_rec_adj.cash_generating_unit_id,
6867: nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM))) then
6868: l_fin_info_changed := FALSE;
6869: elsif nvl(p_asset_fin_rec_adj.contract_change_flag,FALSE) then

Line 6867: nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM))) then

6863: l_fin_info_changed BOOLEAN := TRUE;
6864: BEGIN
6865: if not (nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM) =
6866: nvl(p_asset_fin_rec_adj.cash_generating_unit_id,
6867: nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM))) then
6868: l_fin_info_changed := FALSE;
6869: elsif nvl(p_asset_fin_rec_adj.contract_change_flag,FALSE) then
6870: l_fin_info_changed := FALSE;
6871: elsif nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR) <>

Line 6871: elsif nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR) <>

6867: nvl(p_asset_fin_rec_old.cash_generating_unit_id, FND_API.G_MISS_NUM))) then
6868: l_fin_info_changed := FALSE;
6869: elsif nvl(p_asset_fin_rec_adj.contract_change_flag,FALSE) then
6870: l_fin_info_changed := FALSE;
6871: elsif nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR) <>
6872: nvl(px_asset_fin_rec_new.disabled_flag,nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR)) then
6873: l_fin_info_changed := FALSE;
6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =
6875: nvl(p_asset_fin_rec_adj.global_attribute1,

Line 6872: nvl(px_asset_fin_rec_new.disabled_flag,nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR)) then

6868: l_fin_info_changed := FALSE;
6869: elsif nvl(p_asset_fin_rec_adj.contract_change_flag,FALSE) then
6870: l_fin_info_changed := FALSE;
6871: elsif nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR) <>
6872: nvl(px_asset_fin_rec_new.disabled_flag,nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR)) then
6873: l_fin_info_changed := FALSE;
6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =
6875: nvl(p_asset_fin_rec_adj.global_attribute1,
6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and

Line 6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =

6870: l_fin_info_changed := FALSE;
6871: elsif nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR) <>
6872: nvl(px_asset_fin_rec_new.disabled_flag,nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR)) then
6873: l_fin_info_changed := FALSE;
6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =
6875: nvl(p_asset_fin_rec_adj.global_attribute1,
6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and
6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =
6878: nvl(p_asset_fin_rec_adj.global_attribute2,

Line 6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and

6872: nvl(px_asset_fin_rec_new.disabled_flag,nvl(p_asset_fin_rec_old.disabled_flag, FND_API.G_MISS_CHAR)) then
6873: l_fin_info_changed := FALSE;
6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =
6875: nvl(p_asset_fin_rec_adj.global_attribute1,
6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and
6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =
6878: nvl(p_asset_fin_rec_adj.global_attribute2,
6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =

Line 6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =

6873: l_fin_info_changed := FALSE;
6874: elsif not( nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR) =
6875: nvl(p_asset_fin_rec_adj.global_attribute1,
6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and
6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =
6878: nvl(p_asset_fin_rec_adj.global_attribute2,
6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =
6881: nvl(p_asset_fin_rec_adj.global_attribute3,

Line 6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and

6875: nvl(p_asset_fin_rec_adj.global_attribute1,
6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and
6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =
6878: nvl(p_asset_fin_rec_adj.global_attribute2,
6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =
6881: nvl(p_asset_fin_rec_adj.global_attribute3,
6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =

Line 6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =

6876: nvl(p_asset_fin_rec_old.global_attribute1, FND_API.G_MISS_CHAR)) and
6877: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR) =
6878: nvl(p_asset_fin_rec_adj.global_attribute2,
6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =
6881: nvl(p_asset_fin_rec_adj.global_attribute3,
6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =
6884: nvl(p_asset_fin_rec_adj.global_attribute4,

Line 6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and

6878: nvl(p_asset_fin_rec_adj.global_attribute2,
6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =
6881: nvl(p_asset_fin_rec_adj.global_attribute3,
6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =
6884: nvl(p_asset_fin_rec_adj.global_attribute4,
6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =

Line 6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =

6879: nvl(p_asset_fin_rec_old.global_attribute2, FND_API.G_MISS_CHAR)) and
6880: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR) =
6881: nvl(p_asset_fin_rec_adj.global_attribute3,
6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =
6884: nvl(p_asset_fin_rec_adj.global_attribute4,
6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =
6887: nvl(p_asset_fin_rec_adj.global_attribute5,

Line 6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and

6881: nvl(p_asset_fin_rec_adj.global_attribute3,
6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =
6884: nvl(p_asset_fin_rec_adj.global_attribute4,
6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =
6887: nvl(p_asset_fin_rec_adj.global_attribute5,
6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =

Line 6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =

6882: nvl(p_asset_fin_rec_old.global_attribute3, FND_API.G_MISS_CHAR)) and
6883: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR) =
6884: nvl(p_asset_fin_rec_adj.global_attribute4,
6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =
6887: nvl(p_asset_fin_rec_adj.global_attribute5,
6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =
6890: nvl(p_asset_fin_rec_adj.global_attribute6,

Line 6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and

6884: nvl(p_asset_fin_rec_adj.global_attribute4,
6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =
6887: nvl(p_asset_fin_rec_adj.global_attribute5,
6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =
6890: nvl(p_asset_fin_rec_adj.global_attribute6,
6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =

Line 6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =

6885: nvl(p_asset_fin_rec_old.global_attribute4, FND_API.G_MISS_CHAR)) and
6886: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR) =
6887: nvl(p_asset_fin_rec_adj.global_attribute5,
6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =
6890: nvl(p_asset_fin_rec_adj.global_attribute6,
6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =
6893: nvl(p_asset_fin_rec_adj.global_attribute7,

Line 6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and

6887: nvl(p_asset_fin_rec_adj.global_attribute5,
6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =
6890: nvl(p_asset_fin_rec_adj.global_attribute6,
6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =
6893: nvl(p_asset_fin_rec_adj.global_attribute7,
6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =

Line 6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =

6888: nvl(p_asset_fin_rec_old.global_attribute5, FND_API.G_MISS_CHAR)) and
6889: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR) =
6890: nvl(p_asset_fin_rec_adj.global_attribute6,
6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =
6893: nvl(p_asset_fin_rec_adj.global_attribute7,
6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =
6896: nvl(p_asset_fin_rec_adj.global_attribute8,

Line 6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and

6890: nvl(p_asset_fin_rec_adj.global_attribute6,
6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =
6893: nvl(p_asset_fin_rec_adj.global_attribute7,
6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =
6896: nvl(p_asset_fin_rec_adj.global_attribute8,
6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =

Line 6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =

6891: nvl(p_asset_fin_rec_old.global_attribute6, FND_API.G_MISS_CHAR)) and
6892: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR) =
6893: nvl(p_asset_fin_rec_adj.global_attribute7,
6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =
6896: nvl(p_asset_fin_rec_adj.global_attribute8,
6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =
6899: nvl(p_asset_fin_rec_adj.global_attribute9,

Line 6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and

6893: nvl(p_asset_fin_rec_adj.global_attribute7,
6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =
6896: nvl(p_asset_fin_rec_adj.global_attribute8,
6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =
6899: nvl(p_asset_fin_rec_adj.global_attribute9,
6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =

Line 6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =

6894: nvl(p_asset_fin_rec_old.global_attribute7, FND_API.G_MISS_CHAR)) and
6895: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR) =
6896: nvl(p_asset_fin_rec_adj.global_attribute8,
6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =
6899: nvl(p_asset_fin_rec_adj.global_attribute9,
6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =
6902: nvl(p_asset_fin_rec_adj.global_attribute10,

Line 6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and

6896: nvl(p_asset_fin_rec_adj.global_attribute8,
6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =
6899: nvl(p_asset_fin_rec_adj.global_attribute9,
6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =
6902: nvl(p_asset_fin_rec_adj.global_attribute10,
6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =

Line 6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =

6897: nvl(p_asset_fin_rec_old.global_attribute8, FND_API.G_MISS_CHAR)) and
6898: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR) =
6899: nvl(p_asset_fin_rec_adj.global_attribute9,
6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =
6902: nvl(p_asset_fin_rec_adj.global_attribute10,
6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =
6905: nvl(p_asset_fin_rec_adj.global_attribute11,

Line 6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and

6899: nvl(p_asset_fin_rec_adj.global_attribute9,
6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =
6902: nvl(p_asset_fin_rec_adj.global_attribute10,
6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =
6905: nvl(p_asset_fin_rec_adj.global_attribute11,
6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =

Line 6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =

6900: nvl(p_asset_fin_rec_old.global_attribute9, FND_API.G_MISS_CHAR)) and
6901: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR) =
6902: nvl(p_asset_fin_rec_adj.global_attribute10,
6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =
6905: nvl(p_asset_fin_rec_adj.global_attribute11,
6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =
6908: nvl(p_asset_fin_rec_adj.global_attribute12,

Line 6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and

6902: nvl(p_asset_fin_rec_adj.global_attribute10,
6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =
6905: nvl(p_asset_fin_rec_adj.global_attribute11,
6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =
6908: nvl(p_asset_fin_rec_adj.global_attribute12,
6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =

Line 6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =

6903: nvl(p_asset_fin_rec_old.global_attribute10, FND_API.G_MISS_CHAR)) and
6904: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR) =
6905: nvl(p_asset_fin_rec_adj.global_attribute11,
6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =
6908: nvl(p_asset_fin_rec_adj.global_attribute12,
6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =
6911: nvl(p_asset_fin_rec_adj.global_attribute13,

Line 6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and

6905: nvl(p_asset_fin_rec_adj.global_attribute11,
6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =
6908: nvl(p_asset_fin_rec_adj.global_attribute12,
6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =
6911: nvl(p_asset_fin_rec_adj.global_attribute13,
6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =

Line 6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =

6906: nvl(p_asset_fin_rec_old.global_attribute11, FND_API.G_MISS_CHAR)) and
6907: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR) =
6908: nvl(p_asset_fin_rec_adj.global_attribute12,
6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =
6911: nvl(p_asset_fin_rec_adj.global_attribute13,
6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =
6914: nvl(p_asset_fin_rec_adj.global_attribute14,

Line 6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and

6908: nvl(p_asset_fin_rec_adj.global_attribute12,
6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =
6911: nvl(p_asset_fin_rec_adj.global_attribute13,
6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =
6914: nvl(p_asset_fin_rec_adj.global_attribute14,
6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =

Line 6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =

6909: nvl(p_asset_fin_rec_old.global_attribute12, FND_API.G_MISS_CHAR)) and
6910: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR) =
6911: nvl(p_asset_fin_rec_adj.global_attribute13,
6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =
6914: nvl(p_asset_fin_rec_adj.global_attribute14,
6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =
6917: nvl(p_asset_fin_rec_adj.global_attribute15,

Line 6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and

6911: nvl(p_asset_fin_rec_adj.global_attribute13,
6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =
6914: nvl(p_asset_fin_rec_adj.global_attribute14,
6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =
6917: nvl(p_asset_fin_rec_adj.global_attribute15,
6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =

Line 6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =

6912: nvl(p_asset_fin_rec_old.global_attribute13, FND_API.G_MISS_CHAR)) and
6913: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR) =
6914: nvl(p_asset_fin_rec_adj.global_attribute14,
6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =
6917: nvl(p_asset_fin_rec_adj.global_attribute15,
6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =
6920: nvl(p_asset_fin_rec_adj.global_attribute16,

Line 6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and

6914: nvl(p_asset_fin_rec_adj.global_attribute14,
6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =
6917: nvl(p_asset_fin_rec_adj.global_attribute15,
6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =
6920: nvl(p_asset_fin_rec_adj.global_attribute16,
6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =

Line 6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =

6915: nvl(p_asset_fin_rec_old.global_attribute14, FND_API.G_MISS_CHAR)) and
6916: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR) =
6917: nvl(p_asset_fin_rec_adj.global_attribute15,
6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =
6920: nvl(p_asset_fin_rec_adj.global_attribute16,
6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =
6923: nvl(p_asset_fin_rec_adj.global_attribute17,

Line 6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and

6917: nvl(p_asset_fin_rec_adj.global_attribute15,
6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =
6920: nvl(p_asset_fin_rec_adj.global_attribute16,
6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =
6923: nvl(p_asset_fin_rec_adj.global_attribute17,
6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =

Line 6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =

6918: nvl(p_asset_fin_rec_old.global_attribute15, FND_API.G_MISS_CHAR)) and
6919: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR) =
6920: nvl(p_asset_fin_rec_adj.global_attribute16,
6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =
6923: nvl(p_asset_fin_rec_adj.global_attribute17,
6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =
6926: nvl(p_asset_fin_rec_adj.global_attribute18,

Line 6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and

6920: nvl(p_asset_fin_rec_adj.global_attribute16,
6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =
6923: nvl(p_asset_fin_rec_adj.global_attribute17,
6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =
6926: nvl(p_asset_fin_rec_adj.global_attribute18,
6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =

Line 6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =

6921: nvl(p_asset_fin_rec_old.global_attribute16, FND_API.G_MISS_CHAR)) and
6922: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR) =
6923: nvl(p_asset_fin_rec_adj.global_attribute17,
6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =
6926: nvl(p_asset_fin_rec_adj.global_attribute18,
6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =
6929: nvl(p_asset_fin_rec_adj.global_attribute19,

Line 6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and

6923: nvl(p_asset_fin_rec_adj.global_attribute17,
6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =
6926: nvl(p_asset_fin_rec_adj.global_attribute18,
6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =
6929: nvl(p_asset_fin_rec_adj.global_attribute19,
6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =

Line 6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =

6924: nvl(p_asset_fin_rec_old.global_attribute17, FND_API.G_MISS_CHAR)) and
6925: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR) =
6926: nvl(p_asset_fin_rec_adj.global_attribute18,
6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =
6929: nvl(p_asset_fin_rec_adj.global_attribute19,
6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =
6932: nvl(p_asset_fin_rec_adj.global_attribute20,

Line 6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and

6926: nvl(p_asset_fin_rec_adj.global_attribute18,
6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =
6929: nvl(p_asset_fin_rec_adj.global_attribute19,
6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =
6932: nvl(p_asset_fin_rec_adj.global_attribute20,
6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and
6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =

Line 6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =

6927: nvl(p_asset_fin_rec_old.global_attribute18, FND_API.G_MISS_CHAR)) and
6928: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR) =
6929: nvl(p_asset_fin_rec_adj.global_attribute19,
6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =
6932: nvl(p_asset_fin_rec_adj.global_attribute20,
6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and
6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =
6935: nvl(p_asset_fin_rec_adj.global_attribute_category,

Line 6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and

6929: nvl(p_asset_fin_rec_adj.global_attribute19,
6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =
6932: nvl(p_asset_fin_rec_adj.global_attribute20,
6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and
6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =
6935: nvl(p_asset_fin_rec_adj.global_attribute_category,
6936: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR))) then
6937: l_fin_info_changed := FALSE;

Line 6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =

6930: nvl(p_asset_fin_rec_old.global_attribute19, FND_API.G_MISS_CHAR)) and
6931: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR) =
6932: nvl(p_asset_fin_rec_adj.global_attribute20,
6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and
6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =
6935: nvl(p_asset_fin_rec_adj.global_attribute_category,
6936: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR))) then
6937: l_fin_info_changed := FALSE;
6938: end if;

Line 6936: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR))) then

6932: nvl(p_asset_fin_rec_adj.global_attribute20,
6933: nvl(p_asset_fin_rec_old.global_attribute20, FND_API.G_MISS_CHAR)) and
6934: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR) =
6935: nvl(p_asset_fin_rec_adj.global_attribute_category,
6936: nvl(p_asset_fin_rec_old.global_attribute_category, FND_API.G_MISS_CHAR))) then
6937: l_fin_info_changed := FALSE;
6938: end if;
6939: if not (l_fin_info_changed) then
6940: px_asset_fin_rec_new.adjusted_cost := p_asset_fin_rec_old.adjusted_cost ;

Line 7114: if (nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then

7110: fetch c_method_details into l_old_method_det;
7111: close c_method_details;
7112: end if;
7113:
7114: if (nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) then
7115: open c_grp_details (l_group_asset_id);
7116: fetch c_grp_details into l_grp_fin_det;
7117: close c_grp_details;
7118:

Line 7155: if(nvl(l_group_asset_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM or

7151:
7152: /* Adjusted_cost related */
7153: if(nvl(l_adjusted_cost,0) <> 0) and (p_trans_rec.transaction_key = 'BA') then
7154:
7155: if(nvl(l_group_asset_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM or
7156: nvl(p_asset_fin_rec.tracking_method,'NONE') <> 'CALCULATE' or
7157: nvl(p_asset_fin_rec.member_rollup_flag,'N') <> 'Y' or
7158: nvl(p_asset_hdr_rec.period_of_addition,'N') <> 'Y' or
7159: nvl(l_method_det.rule_name,'ZZ') <> 'YEAR END BALANCE WITH POSITIVE REDUCTION AMOUNT' or

Line 7202: l_old_group_asset_id > 0 and nvl(l_group_asset_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) then

7198: end if;
7199: end if;
7200: /*Group change related : When making as standalone asset */
7201: if(p_trans_rec.transaction_type_code like '%ADJUSTMENT%' and
7202: l_old_group_asset_id > 0 and nvl(l_group_asset_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM) then
7203: open c_ret_count;
7204: fetch c_ret_count into l_dummy_num;
7205: close c_ret_count;
7206: if (l_dummy_num > 0) then

Line 7267: nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and

7263: /*10.1 specific : */
7264:
7265: -- Allow only one member in a group
7266: if(p_trans_rec.transaction_type_code like '%ADJUSTMENT%' and
7267: nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
7268: nvl(l_old_group_asset_id,FND_API.G_MISS_NUM) <> nvl(l_group_asset_id,FND_API.G_MISS_NUM) and
7269: l_method_det.deprn_basis_rule = 'NBV' and
7270: p_asset_type_rec.asset_type <> 'GROUP'
7271: ) then

Line 7268: nvl(l_old_group_asset_id,FND_API.G_MISS_NUM) <> nvl(l_group_asset_id,FND_API.G_MISS_NUM) and

7264:
7265: -- Allow only one member in a group
7266: if(p_trans_rec.transaction_type_code like '%ADJUSTMENT%' and
7267: nvl(l_group_asset_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM and
7268: nvl(l_old_group_asset_id,FND_API.G_MISS_NUM) <> nvl(l_group_asset_id,FND_API.G_MISS_NUM) and
7269: l_method_det.deprn_basis_rule = 'NBV' and
7270: p_asset_type_rec.asset_type <> 'GROUP'
7271: ) then
7272: open c_other_mem(l_group_asset_id);

Line 7284: and nvl(l_old_group_asset_id,FND_API.G_MISS_NUM) = nvl(l_group_asset_id,FND_API.G_MISS_NUM) and

7280: end if;
7281: end if;
7282: --No transactions if cost is zero, adjusted_cost non-zero
7283: if(l_method_det.deprn_basis_rule = 'NBV' and l_old_cost = 0 and l_adjusted_cost = 0 and p_asset_type_rec.asset_type <> 'GROUP'
7284: and nvl(l_old_group_asset_id,FND_API.G_MISS_NUM) = nvl(l_group_asset_id,FND_API.G_MISS_NUM) and
7285: p_trans_rec.transaction_type_code not like '%ADDITION%'
7286: ) then
7287: open c_get_adj_cost;
7288: fetch c_get_adj_cost into l_dummy_num;