APPS.IEU_SH_PVT dependencies on IEU_SH_ACTIVITIES

Line 385: SELECT END_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES

381: if ( l_last_activity_id IS NOT NULL )
382: THEN
383: IF ( P_BEGIN_TIME_FLAG = 1 )
384: THEN
385: SELECT END_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES
386: WHERE ACTIVITY_ID = l_last_activity_id;
387: ELSIF ( P_BEGIN_TIME_FLAG = 2 )
388: THEN
389: SELECT BEGIN_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES

Line 389: SELECT BEGIN_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES

385: SELECT END_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES
386: WHERE ACTIVITY_ID = l_last_activity_id;
387: ELSIF ( P_BEGIN_TIME_FLAG = 2 )
388: THEN
389: SELECT BEGIN_DATE_TIME INTO l_begin_date_time FROM IEU_SH_ACTIVITIES
390: WHERE ACTIVITY_ID = l_last_activity_id;
391: END IF;
392: END IF;
393:

Line 396: INSERT INTO IEU_SH_ACTIVITIES (

392: END IF;
393:
394: -- end changes for correcting reports
395:
396: INSERT INTO IEU_SH_ACTIVITIES (
397: ACTIVITY_ID,
398: SESSION_ID,
399: ACTIVITY_TYPE_ID,
400: ACTIVITY_TYPE_CODE,

Line 423: IEU_SH_ACTIVITIES_S1.NEXTVAL,

419: CATEGORY_TYPE,
420: CATEGORY_VALUE
421: ) values
422: (
423: IEU_SH_ACTIVITIES_S1.NEXTVAL,
424: P_SESSION_ID,
425: L_ACTIVITY_TYPE_ID,
426: P_ACTIVITY_TYPE_CODE,
427: P_MEDIA_TYPE_ID,

Line 609: update IEU_SH_ACTIVITIES set

605: END IF;
606:
607: IF (P_INTERMEDIATE_STATE_CODE = 'ACTIVE') THEN
608:
609: update IEU_SH_ACTIVITIES set
610: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
611: DELIVER_DATE_TIME = SYSDATE,
612: STATE_CODE = P_INTERMEDIATE_STATE_CODE
613: WHERE ACTIVITY_ID = P_ACTIVITY_ID;

Line 624: UPDATE IEU_SH_ACTIVITIES SET

620:
621: IF (P_MEDIA_ID IS NOT NULL)
622: THEN
623:
624: UPDATE IEU_SH_ACTIVITIES SET
625: MEDIA_ID = P_MEDIA_ID,
626: LAST_UPDATE_DATE = SYSDATE
627: WHERE ACTIVITY_ID = P_ACTIVITY_ID;
628:

Line 634: UPDATE IEU_SH_ACTIVITIES SET

630:
631: IF (P_MEDIA_TYPE_ID IS NOT NULL)
632: THEN
633:
634: UPDATE IEU_SH_ACTIVITIES SET
635: MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,
636: LAST_UPDATE_DATE = SYSDATE
637: WHERE ACTIVITY_ID = P_ACTIVITY_ID;
638:

Line 644: UPDATE IEU_SH_ACTIVITIES SET

640:
641: IF (P_MEDIA_TYPE_ID IS NOT NULL)
642: THEN
643:
644: UPDATE IEU_SH_ACTIVITIES SET
645: REASON_CODE = P_REASON_CODE,
646: LAST_UPDATE_DATE = SYSDATE
647: WHERE ACTIVITY_ID = P_ACTIVITY_ID;
648:

Line 773: SELECT END_DATE_TIME INTO l_end_date_time FROM IEU_SH_ACTIVITIES WHERE

769: SELECT SYSDATE INTO l_end_date_time FROM DUAL;
770:
771: IF ( P_LAST_ACTIVITY_ID IS NOT NULL )
772: THEN
773: SELECT END_DATE_TIME INTO l_end_date_time FROM IEU_SH_ACTIVITIES WHERE
774: ACTIVITY_ID = P_LAST_ACTIVITY_ID;
775: END IF;
776:
777: -- end changes for correcting reports

Line 779: update IEU_SH_ACTIVITIES set

775: END IF;
776:
777: -- end changes for correcting reports
778:
779: update IEU_SH_ACTIVITIES set
780: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
781: END_DATE_TIME = l_end_date_time,
782: MEDIA_ID = P_MEDIA_ID,
783: MEDIA_TYPE_ID = P_MEDIA_TYPE_ID,