DBA Data[Home] [Help]

APPS.PN_VAR_ABATEMENTS_PKG dependencies on FND_PROFILE

Line 369: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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:

Line 370: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1)

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;

Line 534: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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 );

Line 536: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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

Line 537: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),

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(

Line 549: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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;

Line 550: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));

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:

Line 821: X_CREATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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 );

Line 823: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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

Line 824: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1),

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(

Line 836: X_LAST_UPDATED_BY => NVL(fnd_profile.value('USER_ID'),-1),

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;

Line 837: X_LAST_UPDATE_LOGIN => NVL(fnd_profile.value('USER_ID'),-1));

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: