DBA Data[Home] [Help]

APPS.AMS_DMLIFT_PUB dependencies on AMS_DM_LIFT

Line 566: SELECT ams_dm_lift_s.NEXTVAL

562:
563: l_dummy NUMBER;
564:
565: CURSOR c_lift_id IS
566: SELECT ams_dm_lift_s.NEXTVAL
567: FROM dual;
568:
569: CURSOR c_id_exists (p_lift_id IN NUMBER) IS
570: SELECT 1

Line 573: FROM ams_dm_lift

569: CURSOR c_id_exists (p_lift_id IN NUMBER) IS
570: SELECT 1
571: FROM dual
572: WHERE EXISTS (SELECT 1
573: FROM ams_dm_lift
574: WHERE lift_id = p_lift_id)
575: ;
576: BEGIN
577: -- Initialize return status

Line 628: ams_dm_lift_pkg.Insert_Row(

624: END LOOP;
625:
626: -- Call the table handler.
627: -- Note: margin and roi are not used.
628: ams_dm_lift_pkg.Insert_Row(
629: px_LIFT_ID => l_lift_id,
630: p_LAST_UPDATE_DATE => SYSDATE,
631: p_LAST_UPDATED_BY => FND_GLOBAL.user_id,
632: p_CREATION_DATE => SYSDATE,