365: X_INCLUDE_TERM => get_update_rec.INCLUDE_TERM ,
366: X_INCLUDE_INCREASES => get_update_rec.INCLUDE_INCREASES,
367: X_UPDATE_FLAG => NULL,
368: X_LAST_UPDATE_DATE => sysdate,
369: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
370: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1)
371: );
372: END LOOP;
373:
366: X_INCLUDE_INCREASES => get_update_rec.INCLUDE_INCREASES,
367: X_UPDATE_FLAG => NULL,
368: X_LAST_UPDATE_DATE => sysdate,
369: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
370: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1)
371: );
372: END LOOP;
373:
374: END RESET_UPDATE_FLAG;
530: X_INCLUDE_TERM => upd_rec.include_term,
531: X_INCLUDE_INCREASES => upd_rec.include_increases,
532: X_UPDATE_FLAG => NULL,
533: X_CREATION_DATE => sysdate,
534: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
535: X_LAST_UPDATE_DATE => sysdate,
536: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
537: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
538: X_ORG_ID => l_org_id );
532: X_UPDATE_FLAG => NULL,
533: X_CREATION_DATE => sysdate,
534: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
535: X_LAST_UPDATE_DATE => sysdate,
536: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
537: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
538: X_ORG_ID => l_org_id );
539:
540: ELSE
533: X_CREATION_DATE => sysdate,
534: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
535: X_LAST_UPDATE_DATE => sysdate,
536: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
537: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
538: X_ORG_ID => l_org_id );
539:
540: ELSE
541: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(
545: X_INCLUDE_TERM => upd_rec.include_term,
546: X_INCLUDE_INCREASES => upd_rec.include_increases,
547: X_UPDATE_FLAG => NULL,
548: X_LAST_UPDATE_DATE => sysdate,
549: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
550: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));
551: END IF;
552: END IF;
553: END LOOP;
546: X_INCLUDE_INCREASES => upd_rec.include_increases,
547: X_UPDATE_FLAG => NULL,
548: X_LAST_UPDATE_DATE => sysdate,
549: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
550: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));
551: END IF;
552: END IF;
553: END LOOP;
554:
817: X_INCLUDE_TERM => upd_rec.include_term,
818: X_INCLUDE_INCREASES => upd_rec.include_increases,
819: X_UPDATE_FLAG => NULL,
820: X_CREATION_DATE => sysdate,
821: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
822: X_LAST_UPDATE_DATE => sysdate,
823: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
824: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
825: X_ORG_ID => l_org_id );
819: X_UPDATE_FLAG => NULL,
820: X_CREATION_DATE => sysdate,
821: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
822: X_LAST_UPDATE_DATE => sysdate,
823: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
824: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
825: X_ORG_ID => l_org_id );
826:
827: ELSE
820: X_CREATION_DATE => sysdate,
821: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
822: X_LAST_UPDATE_DATE => sysdate,
823: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
824: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),
825: X_ORG_ID => l_org_id );
826:
827: ELSE
828: PN_VAR_ABATEMENTS_PKG.UPDATE_ROW(
832: X_INCLUDE_TERM => upd_rec.include_term,
833: X_INCLUDE_INCREASES => upd_rec.include_increases,
834: X_UPDATE_FLAG => NULL,
835: X_LAST_UPDATE_DATE => sysdate,
836: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
837: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));
838: END IF;
839: END IF;
840: END LOOP;
833: X_INCLUDE_INCREASES => upd_rec.include_increases,
834: X_UPDATE_FLAG => NULL,
835: X_LAST_UPDATE_DATE => sysdate,
836: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),
837: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));
838: END IF;
839: END IF;
840: END LOOP;
841: