2881: x_attribute14 => l_ue_rec.ATTRIBUTE14,
2882: x_attribute15 => l_ue_rec.ATTRIBUTE15,
2883: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
2884: x_last_update_date => TRUNC(sysdate),
2885: x_last_updated_by => fnd_global.user_id,
2886: x_last_update_login => fnd_global.login_id);
2887:
2888:
2889: -- Update/Delete the unit_deferrals record.
2882: x_attribute15 => l_ue_rec.ATTRIBUTE15,
2883: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
2884: x_last_update_date => TRUNC(sysdate),
2885: x_last_updated_by => fnd_global.user_id,
2886: x_last_update_login => fnd_global.login_id);
2887:
2888:
2889: -- Update/Delete the unit_deferrals record.
2890: OPEN ahl_unit_def_csr (p_unit_Effectivity_rec.unit_effectivity_id);
2921: AHL_UNIT_DEFERRALS_PKG.update_row(
2922: x_unit_deferral_id => l_unit_def_rec.unit_deferral_id,
2923: x_ata_sequence_id => l_unit_def_rec.ata_sequence_id,
2924: x_object_version_number => l_unit_def_rec.object_version_number + 1,
2925: x_last_updated_by => fnd_global.user_id,
2926: x_last_update_date => sysdate,
2927: x_last_update_login => fnd_global.login_id,
2928: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2929: x_unit_deferral_type => l_unit_def_rec.unit_deferral_type,
2923: x_ata_sequence_id => l_unit_def_rec.ata_sequence_id,
2924: x_object_version_number => l_unit_def_rec.object_version_number + 1,
2925: x_last_updated_by => fnd_global.user_id,
2926: x_last_update_date => sysdate,
2927: x_last_update_login => fnd_global.login_id,
2928: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2929: x_unit_deferral_type => l_unit_def_rec.unit_deferral_type,
2930: x_set_due_date => l_set_due_date,
2931: x_deferral_effective_on => l_unit_def_rec.deferral_effective_on,
2963: x_rowid => l_rowid,
2964: x_unit_deferral_id => l_unit_deferral_id,
2965: x_ata_sequence_id => null,
2966: x_object_version_number => 1,
2967: x_created_by => fnd_global.user_id,
2968: x_creation_date => sysdate,
2969: x_last_updated_by => fnd_global.user_id,
2970: x_last_update_date => sysdate,
2971: x_last_update_login => fnd_global.login_id,
2965: x_ata_sequence_id => null,
2966: x_object_version_number => 1,
2967: x_created_by => fnd_global.user_id,
2968: x_creation_date => sysdate,
2969: x_last_updated_by => fnd_global.user_id,
2970: x_last_update_date => sysdate,
2971: x_last_update_login => fnd_global.login_id,
2972: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2973: x_unit_deferral_type => 'INIT-DUE',
2967: x_created_by => fnd_global.user_id,
2968: x_creation_date => sysdate,
2969: x_last_updated_by => fnd_global.user_id,
2970: x_last_update_date => sysdate,
2971: x_last_update_login => fnd_global.login_id,
2972: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2973: x_unit_deferral_type => 'INIT-DUE',
2974: x_set_due_date => p_unit_Effectivity_rec.set_due_date,
2975: x_deferral_effective_on => null,
3205: x_attribute14 => l_ue_rec.ATTRIBUTE14,
3206: x_attribute15 => l_ue_rec.ATTRIBUTE15,
3207: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
3208: x_last_update_date => TRUNC(sysdate),
3209: x_last_updated_by => fnd_global.user_id,
3210: x_last_update_login => fnd_global.login_id);
3211:
3212: END Terminate_Descendent;
3213:
3206: x_attribute15 => l_ue_rec.ATTRIBUTE15,
3207: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
3208: x_last_update_date => TRUNC(sysdate),
3209: x_last_updated_by => fnd_global.user_id,
3210: x_last_update_login => fnd_global.login_id);
3211:
3212: END Terminate_Descendent;
3213:
3214: ------------------------------------
3391: P_ATTRIBUTE14 => p_x_unit_threshold_tbl(i).ATTRIBUTE14,
3392: P_ATTRIBUTE15 => p_x_unit_threshold_tbl(i).ATTRIBUTE15,
3393: P_OBJECT_VERSION_NUMBER => p_x_unit_threshold_tbl(i).OBJECT_VERSION_NUMBER,
3394: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3395: P_LAST_UPDATED_BY => fnd_global.user_id,
3396: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3397: ELSE
3398: FND_MESSAGE.Set_Name('AHL','AHL_UMP_THRSHLD_ID_INVALID');
3399: FND_MESSAGE.Set_Token('THRESHOLDID', p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
3392: P_ATTRIBUTE15 => p_x_unit_threshold_tbl(i).ATTRIBUTE15,
3393: P_OBJECT_VERSION_NUMBER => p_x_unit_threshold_tbl(i).OBJECT_VERSION_NUMBER,
3394: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3395: P_LAST_UPDATED_BY => fnd_global.user_id,
3396: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3397: ELSE
3398: FND_MESSAGE.Set_Name('AHL','AHL_UMP_THRSHLD_ID_INVALID');
3399: FND_MESSAGE.Set_Token('THRESHOLDID', p_x_unit_threshold_tbl(i).UNIT_THRESHOLD_ID);
3400: FND_MSG_PUB.ADD;
3422: x_rowid => l_rowid,
3423: x_unit_deferral_id => l_unit_deferral_id,
3424: x_ata_sequence_id => null,
3425: x_object_version_number => 1,
3426: x_created_by => fnd_global.user_id,
3427: x_creation_date => sysdate,
3428: x_last_updated_by => fnd_global.user_id,
3429: x_last_update_date => sysdate,
3430: x_last_update_login => fnd_global.login_id,
3424: x_ata_sequence_id => null,
3425: x_object_version_number => 1,
3426: x_created_by => fnd_global.user_id,
3427: x_creation_date => sysdate,
3428: x_last_updated_by => fnd_global.user_id,
3429: x_last_update_date => sysdate,
3430: x_last_update_login => fnd_global.login_id,
3431: x_unit_effectivity_id => p_x_unit_threshold_tbl(i).unit_effectivity_id,
3432: x_unit_deferral_type => 'INIT-DUE',
3426: x_created_by => fnd_global.user_id,
3427: x_creation_date => sysdate,
3428: x_last_updated_by => fnd_global.user_id,
3429: x_last_update_date => sysdate,
3430: x_last_update_login => fnd_global.login_id,
3431: x_unit_effectivity_id => p_x_unit_threshold_tbl(i).unit_effectivity_id,
3432: x_unit_deferral_type => 'INIT-DUE',
3433: x_set_due_date => p_unit_Effectivity_rec.set_due_date,
3434: x_deferral_effective_on => null,
3536: P_ATTRIBUTE14 => p_x_unit_threshold_tbl(i).ATTRIBUTE14,
3537: P_ATTRIBUTE15 => p_x_unit_threshold_tbl(i).ATTRIBUTE15,
3538: P_OBJECT_VERSION_NUMBER => p_x_unit_threshold_tbl(i).OBJECT_VERSION_NUMBER,
3539: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3540: P_LAST_UPDATED_BY => fnd_global.user_id,
3541: P_CREATION_DATE => TRUNC(sysdate),
3542: P_CREATED_BY => fnd_global.user_id,
3543: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3544: ELSE
3538: P_OBJECT_VERSION_NUMBER => p_x_unit_threshold_tbl(i).OBJECT_VERSION_NUMBER,
3539: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3540: P_LAST_UPDATED_BY => fnd_global.user_id,
3541: P_CREATION_DATE => TRUNC(sysdate),
3542: P_CREATED_BY => fnd_global.user_id,
3543: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3544: ELSE
3545: -- unrecognized operation flag
3546: FND_MESSAGE.Set_Name('AHL','AHL_UMP_OPERATION_INVALID');
3539: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3540: P_LAST_UPDATED_BY => fnd_global.user_id,
3541: P_CREATION_DATE => TRUNC(sysdate),
3542: P_CREATED_BY => fnd_global.user_id,
3543: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3544: ELSE
3545: -- unrecognized operation flag
3546: FND_MESSAGE.Set_Name('AHL','AHL_UMP_OPERATION_INVALID');
3547: FND_MESSAGE.Set_Token('OPERATION', p_x_unit_threshold_tbl(i).OPERATION_FLAG);
3725: P_ATTRIBUTE14 => p_x_unit_accomplish_tbl(i).ATTRIBUTE14,
3726: P_ATTRIBUTE15 => p_x_unit_accomplish_tbl(i).ATTRIBUTE15,
3727: P_OBJECT_VERSION_NUMBER => p_x_unit_accomplish_tbl(i).OBJECT_VERSION_NUMBER,
3728: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3729: P_LAST_UPDATED_BY => fnd_global.user_id,
3730: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3731: ELSE
3732: FND_MESSAGE.Set_Name('AHL','AHL_UMP_ACCMPLSH_ID_INVALID');
3733: FND_MESSAGE.Set_Token('ACCOMPLISHMENTID', p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3726: P_ATTRIBUTE15 => p_x_unit_accomplish_tbl(i).ATTRIBUTE15,
3727: P_OBJECT_VERSION_NUMBER => p_x_unit_accomplish_tbl(i).OBJECT_VERSION_NUMBER,
3728: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3729: P_LAST_UPDATED_BY => fnd_global.user_id,
3730: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3731: ELSE
3732: FND_MESSAGE.Set_Name('AHL','AHL_UMP_ACCMPLSH_ID_INVALID');
3733: FND_MESSAGE.Set_Token('ACCOMPLISHMENTID', p_x_unit_accomplish_tbl(i).UNIT_ACCOMPLISH_ID);
3734: FND_MSG_PUB.ADD;
3819: P_ATTRIBUTE14 => p_x_unit_accomplish_tbl(i).ATTRIBUTE14,
3820: P_ATTRIBUTE15 => p_x_unit_accomplish_tbl(i).ATTRIBUTE15,
3821: P_OBJECT_VERSION_NUMBER => p_x_unit_accomplish_tbl(i).OBJECT_VERSION_NUMBER,
3822: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3823: P_LAST_UPDATED_BY => fnd_global.user_id,
3824: P_CREATION_DATE => TRUNC(sysdate),
3825: P_CREATED_BY => fnd_global.user_id,
3826: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3827:
3821: P_OBJECT_VERSION_NUMBER => p_x_unit_accomplish_tbl(i).OBJECT_VERSION_NUMBER,
3822: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3823: P_LAST_UPDATED_BY => fnd_global.user_id,
3824: P_CREATION_DATE => TRUNC(sysdate),
3825: P_CREATED_BY => fnd_global.user_id,
3826: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3827:
3828: /* Commented out call for locking counter reading for bug# 6388834.
3829: * User can adjust counter readings/record for prior dated counter
3822: P_LAST_UPDATE_DATE => TRUNC(sysdate),
3823: P_LAST_UPDATED_BY => fnd_global.user_id,
3824: P_CREATION_DATE => TRUNC(sysdate),
3825: P_CREATED_BY => fnd_global.user_id,
3826: P_LAST_UPDATE_LOGIN => fnd_global.login_id);
3827:
3828: /* Commented out call for locking counter reading for bug# 6388834.
3829: * User can adjust counter readings/record for prior dated counter
3830: * readings after MR signoff.
4625: x_ATTRIBUTE14 => l_ue_rec.ATTRIBUTE14,
4626: x_ATTRIBUTE15 => l_ue_rec.ATTRIBUTE15,
4627: x_OBJECT_VERSION_NUMBER => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
4628: x_LAST_UPDATE_DATE => sysdate,
4629: X_LAST_UPDATED_BY => fnd_global.user_id,
4630: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4631:
4632: IF G_DEBUG='Y' THEN
4633: AHL_DEBUG_PUB.debug('After update record');
4626: x_ATTRIBUTE15 => l_ue_rec.ATTRIBUTE15,
4627: x_OBJECT_VERSION_NUMBER => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
4628: x_LAST_UPDATE_DATE => sysdate,
4629: X_LAST_UPDATED_BY => fnd_global.user_id,
4630: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4631:
4632: IF G_DEBUG='Y' THEN
4633: AHL_DEBUG_PUB.debug('After update record');
4634: END IF;
4700: x_ATTRIBUTE14 => l_ue_descendent_rec.ATTRIBUTE14,
4701: x_ATTRIBUTE15 => l_ue_descendent_rec.ATTRIBUTE15,
4702: x_OBJECT_VERSION_NUMBER => l_ue_descendent_rec.OBJECT_VERSION_NUMBER + 1,
4703: x_LAST_UPDATE_DATE => sysdate,
4704: x_LAST_UPDATED_BY => fnd_global.user_id,
4705: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4706:
4707:
4708: END LOOP;
4701: x_ATTRIBUTE15 => l_ue_descendent_rec.ATTRIBUTE15,
4702: x_OBJECT_VERSION_NUMBER => l_ue_descendent_rec.OBJECT_VERSION_NUMBER + 1,
4703: x_LAST_UPDATE_DATE => sysdate,
4704: x_LAST_UPDATED_BY => fnd_global.user_id,
4705: X_LAST_UPDATE_LOGIN => fnd_global.login_id);
4706:
4707:
4708: END LOOP;
4709: CLOSE l_ue_descendent_csr;
4776: x_ATTRIBUTE14 => l_ue_rec.ATTRIBUTE14,
4777: x_ATTRIBUTE15 => l_ue_rec.ATTRIBUTE15,
4778: x_OBJECT_VERSION_NUMBER => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
4779: x_LAST_UPDATE_DATE => sysdate, --l_ue_rec.LAST_UPDATE_DATE,
4780: x_LAST_UPDATED_BY => fnd_global.user_id, --l_ue_rec.LAST_UPDATED_BY,
4781: x_LAST_UPDATE_LOGIN => fnd_global.login_id); -- l_ue_rec.LAST_UPDATE_LOGIN );
4782:
4783:
4784: IF G_DEBUG='Y' THEN
4777: x_ATTRIBUTE15 => l_ue_rec.ATTRIBUTE15,
4778: x_OBJECT_VERSION_NUMBER => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
4779: x_LAST_UPDATE_DATE => sysdate, --l_ue_rec.LAST_UPDATE_DATE,
4780: x_LAST_UPDATED_BY => fnd_global.user_id, --l_ue_rec.LAST_UPDATED_BY,
4781: x_LAST_UPDATE_LOGIN => fnd_global.login_id); -- l_ue_rec.LAST_UPDATE_LOGIN );
4782:
4783:
4784: IF G_DEBUG='Y' THEN
4785: AHL_DEBUG_PUB.debug('After update record');
4851: x_ATTRIBUTE14 => l_ue_descendent_rec.ATTRIBUTE14,
4852: x_ATTRIBUTE15 => l_ue_descendent_rec.ATTRIBUTE15,
4853: x_OBJECT_VERSION_NUMBER => l_ue_descendent_rec.OBJECT_VERSION_NUMBER + 1,
4854: x_LAST_UPDATE_DATE => sysdate, --l_ue_descendent_rec.LAST_UPDATE_DATE,
4855: x_LAST_UPDATED_BY => fnd_global.user_id, --l_ue_descendent_rec.LAST_UPDATED_BY ,
4856: x_LAST_UPDATE_LOGIN => fnd_global.login_id); --l_ue_descendent_rec.LAST_UPDATE_LOGIN );
4857: END LOOP;
4858: CLOSE l_ue_descendent_csr;
4859:
4852: x_ATTRIBUTE15 => l_ue_descendent_rec.ATTRIBUTE15,
4853: x_OBJECT_VERSION_NUMBER => l_ue_descendent_rec.OBJECT_VERSION_NUMBER + 1,
4854: x_LAST_UPDATE_DATE => sysdate, --l_ue_descendent_rec.LAST_UPDATE_DATE,
4855: x_LAST_UPDATED_BY => fnd_global.user_id, --l_ue_descendent_rec.LAST_UPDATED_BY ,
4856: x_LAST_UPDATE_LOGIN => fnd_global.login_id); --l_ue_descendent_rec.LAST_UPDATE_LOGIN );
4857: END LOOP;
4858: CLOSE l_ue_descendent_csr;
4859:
4860: ELSE
5045: X_ATTRIBUTE14 => cp_ue_rec.ATTRIBUTE14,
5046: X_ATTRIBUTE15 => cp_ue_rec.ATTRIBUTE15,
5047: X_OBJECT_VERSION_NUMBER => 1, /* object version */
5048: X_CREATION_DATE => sysdate,
5049: X_CREATED_BY => fnd_global.user_id,
5050: X_LAST_UPDATE_DATE => sysdate,
5051: X_LAST_UPDATED_BY => fnd_global.user_id,
5052: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
5053: IF(l_copy_ud_record)THEN
5047: X_OBJECT_VERSION_NUMBER => 1, /* object version */
5048: X_CREATION_DATE => sysdate,
5049: X_CREATED_BY => fnd_global.user_id,
5050: X_LAST_UPDATE_DATE => sysdate,
5051: X_LAST_UPDATED_BY => fnd_global.user_id,
5052: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
5053: IF(l_copy_ud_record)THEN
5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
5055: last_update_date = sysdate,
5048: X_CREATION_DATE => sysdate,
5049: X_CREATED_BY => fnd_global.user_id,
5050: X_LAST_UPDATE_DATE => sysdate,
5051: X_LAST_UPDATED_BY => fnd_global.user_id,
5052: X_LAST_UPDATE_LOGIN => fnd_global.login_id );
5053: IF(l_copy_ud_record)THEN
5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
5055: last_update_date = sysdate,
5056: object_version_number = object_version_number + 1,
5053: IF(l_copy_ud_record)THEN
5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
5055: last_update_date = sysdate,
5056: object_version_number = object_version_number + 1,
5057: LAST_UPDATED_BY = fnd_global.user_id,
5058: LAST_UPDATE_LOGIN = fnd_global.login_id
5059: WHERE unit_deferral_id = l_unit_deferral_id;
5060: END IF;
5061: END IF;
5054: Update AHL_UNIT_DEFERRALS_B SET UNIT_EFFECTIVITY_ID = l_unit_effectivity_id,
5055: last_update_date = sysdate,
5056: object_version_number = object_version_number + 1,
5057: LAST_UPDATED_BY = fnd_global.user_id,
5058: LAST_UPDATE_LOGIN = fnd_global.login_id
5059: WHERE unit_deferral_id = l_unit_deferral_id;
5060: END IF;
5061: END IF;
5062: END LOOP;
5696: x_attribute14 => l_ue_rec.ATTRIBUTE14,
5697: x_attribute15 => l_ue_rec.ATTRIBUTE15,
5698: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
5699: x_last_update_date => TRUNC(sysdate),
5700: x_last_updated_by => fnd_global.user_id,
5701: x_last_update_login => fnd_global.login_id);
5702:
5703:
5704: END MR_Terminate;
5697: x_attribute15 => l_ue_rec.ATTRIBUTE15,
5698: x_object_version_number => l_ue_rec.OBJECT_VERSION_NUMBER + 1,
5699: x_last_update_date => TRUNC(sysdate),
5700: x_last_updated_by => fnd_global.user_id,
5701: x_last_update_login => fnd_global.login_id);
5702:
5703:
5704: END MR_Terminate;
5705: