APPS.AMS_TCOP_PREVIEW SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 97

   SELECT ams_tcop_prvw_requests_s.nextval
   FROM DUAL;

Line: 119

   INSERT INTO
   AMS_TCOP_PRVW_REQUESTS
   (
   REQUEST_ID,
   GENERATION_DATE,
   STATUS,
   LIST_HEADER_ID,
   TOTAL_PREVIEW_SIZE,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_LOGIN,
   OBJECT_VERSION_NUMBER,
   PROJECTED_FATIGUE_PERIOD
   )
   VALUES
   (
   G_PRVW_REQUEST_ID,
   sysdate,
   'NEW',
   p_list_header_id,
   p_total_preview_size,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.USER_ID,
   FND_GLOBAL.USER_ID,
   1,
   G_GLOBAL_NO_OF_PERIOD
   );

Line: 175

 G_PRVW_DATE_LIST.DELETE;

Line: 337

PROCEDURE DELETE_FROM_LIST(p_delete_from_list IN OUT NOCOPY jtf_number_table,
                           p_delete_list      IN  jtf_number_table
                           )
IS

l_temp_list jtf_number_table := jtf_number_table();

Line: 347

   IF (p_delete_from_list.count > 0 and p_delete_list.count > 0) THEN
      FOR i in p_delete_list.first .. p_delete_list.last
      LOOP
         IF (p_delete_from_list.count > 0 ) THEN
         FOR j in p_delete_from_list.first .. p_delete_from_list.last
         LOOP
            IF (p_delete_from_list.exists(j)) THEN
               IF ((p_delete_list(i) = p_delete_from_list(j))
                 ) THEN
                  p_delete_from_list.delete(j);

Line: 365

   IF (p_delete_from_list.count > 0)
   THEN
	FOR j in p_delete_from_list.first .. p_delete_from_list.last
	LOOP
	    BEGIN
		l_temp_num := p_delete_from_list(j);

Line: 381

   p_delete_from_list := l_temp_list;

Line: 383

END DELETE_FROM_LIST;

Line: 404

   SELECT CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
   FROM   AMS_CAMPAIGN_SCHEDULES_B CSCH,
          AMS_ACT_LISTS ACT_LIST,
          AMS_LIST_HEADERS_ALL LIST_HEADER
   WHERE  CSCH.START_DATE_TIME BETWEEN
                                  p_preview_start_date AND p_preview_end_date
   AND    CSCH.STATUS_CODE in ('AVAILABLE','ACTIVE')
   AND    CSCH.SCHEDULE_ID <> G_SCHEDULE_ID
   AND    ACT_LIST.LIST_USED_BY = 'CSCH'
   AND    ACT_LIST.LIST_USED_BY_ID = CSCH.SCHEDULE_ID
   AND    ACT_LIST.LIST_HEADER_ID = LIST_HEADER.LIST_HEADER_ID
   AND    ACT_LIST.LIST_ACT_TYPE = 'TARGET'
   AND    LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
   AND    EXISTS
          (SELECT LIST_ENTRY1.PARTY_ID
           FROM   AMS_LIST_ENTRIES LIST_ENTRY1
                  ,AMS_LIST_ENTRIES LIST_ENTRY2
           WHERE  LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
           AND    LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
           AND    LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id
         )
    ORDER BY CSCH.START_DATE_TIME
   ;

Line: 432

   SELECT /*+ leading(ACT_LIST) */ CSCH.SCHEDULE_ID,CSCH.ACTIVITY_ID,CSCH.START_DATE_TIME
   FROM   AMS_CAMPAIGN_SCHEDULES_B CSCH,
          AMS_ACT_LISTS ACT_LIST,
          AMS_LIST_HEADERS_ALL LIST_HEADER
   WHERE  TRUNC(CSCH.START_DATE_TIME) BETWEEN
                                  p_preview_start_date AND p_preview_end_date
   AND    CSCH.STATUS_CODE in ('AVAILABLE','ACTIVE')
   AND    CSCH.SCHEDULE_ID <> G_SCHEDULE_ID
   AND    ACT_LIST.LIST_USED_BY = 'CSCH'
   AND    ACT_LIST.LIST_USED_BY_ID = CSCH.SCHEDULE_ID
   AND    ACT_LIST.LIST_HEADER_ID = LIST_HEADER.LIST_HEADER_ID
   AND    ACT_LIST.LIST_ACT_TYPE = 'TARGET'
   AND    LIST_HEADER.APPLY_TRAFFIC_COP = 'Y'
   AND    EXISTS
          (SELECT LIST_ENTRY1.PARTY_ID
           FROM   AMS_LIST_ENTRIES LIST_ENTRY1
                  ,AMS_LIST_ENTRIES LIST_ENTRY2
           WHERE  LIST_HEADER.LIST_HEADER_ID = LIST_ENTRY1.LIST_HEADER_ID
           AND    LIST_ENTRY1.PARTY_ID = LIST_ENTRY2.PARTY_ID
           AND    LIST_ENTRY2.LIST_HEADER_ID = p_list_header_id
         )
    ORDER BY CSCH.START_DATE_TIME
   ;

Line: 460

   SELECT LIST_ENTRY1.PARTY_ID
   FROM   AMS_LIST_ENTRIES LIST_ENTRY1
         ,AMS_LIST_ENTRIES LIST_ENTRY2
         ,AMS_CAMPAIGN_SCHEDULES_B CSCH
         ,AMS_ACT_LISTS ACT_LIST
         ,AMS_LIST_HEADERS_ALL LIST_HEADER
   WHERE  LIST_ENTRY1.LIST_HEADER_ID = p_list_header_id
   AND    LIST_ENTRY2.PARTY_ID = LIST_ENTRY1.PARTY_ID
   AND    LIST_ENTRY2.LIST_HEADER_ID = LIST_HEADER.LIST_HEADER_ID
   AND    ACT_LIST.LIST_USED_BY = 'CSCH'
   AND    ACT_LIST.LIST_USED_BY_ID = CSCH.SCHEDULE_ID
   AND    CSCH.SCHEDULE_ID = p_SCHEDULE_ID
   AND    ACT_LIST.LIST_ACT_TYPE='TARGET'
   AND    ACT_LIST.LIST_HEADER_ID = LIST_HEADER.LIST_HEADER_ID;

Line: 477

   SELECT rule.rule_id rule_id
          ,rule.rule_type rule_type
          ,period.no_of_days no_of_days
          ,rule.max_contact_allowed max_contact_allowed
   FROM   ams_tcop_fr_rules_setup rule,
          ams_tcop_fr_periods_b period
   WHERE  rule.ENABLED_FLAG = 'Y'
   AND    (rule.CHANNEL_ID is null
          OR (rule.CHANNEL_ID = p_activity_id) )
   AND    rule.RULE_TYPE in ('GLOBAL' , 'CHANNEL_BASED')
   AND    rule.PERIOD_ID = period.PERIOD_ID
   ORDER BY (rule.MAX_CONTACT_ALLOWED * period.NO_OF_DAYS);

Line: 495

   SELECT /*+ leading(party_list) +*/
          CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
   FROM   AMS_TCOP_CONTACTS CONTACT,
          (SELECT COLUMN_VALUE PARTY_ID
          FROM    TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
          ) party_list
   WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
   AND   CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
                              AND TRUNC(p_preview_date)
   GROUP BY CONTACT.PARTY_ID;

Line: 512

   SELECT /*+ leading(party_list) +*/
          CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
   FROM   AMS_TCOP_PRVW_CONTACTS CONTACT,
          (SELECT COLUMN_VALUE PARTY_ID
          FROM    TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
          ) party_list
   WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
   AND   CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
                              AND TRUNC(p_preview_date)
   GROUP BY CONTACT.PARTY_ID;

Line: 529

   SELECT /*+ leading(party_list) +*/
          CONTACT.PARTY_ID,
          COUNT(CONTACT.PARTY_ID)
   FROM   AMS_TCOP_CONTACTS CONTACT,
          (SELECT COLUMN_VALUE PARTY_ID
          FROM    TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
          ) party_list
   WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
   AND   CONTACT.MEDIA_ID = p_activity_id
   AND   CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
                              AND TRUNC(p_preview_date)
   GROUP BY CONTACT.PARTY_ID;

Line: 548

   SELECT /*+ leading(party_list) +*/
          CONTACT.PARTY_ID, COUNT(CONTACT.PARTY_ID)
   FROM   AMS_TCOP_PRVW_CONTACTS CONTACT,
          AMS_CAMPAIGN_SCHEDULES_B CSCH,
          (SELECT COLUMN_VALUE PARTY_ID
          FROM    TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
          ) party_list
   WHERE CONTACT.PARTY_ID = PARTY_LIST.PARTY_ID
   AND   CSCH.SCHEDULE_ID = CONTACT.SCHEDULE_ID
   AND   CSCH.ACTIVITY_ID = p_activity_id
   AND   CONTACT_DATE BETWEEN TRUNC(p_preview_date - p_no_of_days)
                              AND TRUNC(p_preview_date)
   GROUP BY CONTACT.PARTY_ID;

Line: 566

   SELECT party_list.party_id
   FROM
   (SELECT column_value party_id
    FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
   ) party_list
   WHERE party_list.party_id=p_party_id;

Line: 575

   SELECT AMS_TCOP_PRVW_CONTACTS_S.NEXTVAL
   FROM DUAL;

Line: 710

                        DELETE_FROM_LIST(l_contact_party_list,
                                         l_fatigue_party_list);

Line: 716

                     l_fatigue_party_list.delete;

Line: 834

                        DELETE_FROM_LIST(l_contact_party_list,
                                         l_fatigue_party_list
                                        );

Line: 838

                     l_fatigue_party_list.delete;

Line: 842

                  l_temp_contact_party_list.delete;

Line: 843

                  l_temp_contact_count_list.delete;

Line: 844

                  l_global_contact_party_list.delete;

Line: 845

                  l_global_contact_count_list.delete;

Line: 897

                        DELETE_FROM_LIST(l_contact_party_list,
                                         l_fatigue_party_list);

Line: 901

                        l_fatigue_party_list.delete;

Line: 1022

                     DELETE_FROM_LIST(l_contact_party_list,
                                      l_fatigue_party_list
                                      );

Line: 1026

                     l_fatigue_party_list.delete;

Line: 1051

            INSERT INTO
            AMS_TCOP_PRVW_CONTACTS
            (
              CONTACT_ID,
              SCHEDULE_ID,
              PARTY_ID,
              PREVIEW_ID,
              CONTACT_DATE,
              CREATION_DATE,
              CREATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_LOGIN
            )
            VALUES
            (
              l_contact_id_list(i),
              l_schedule_id,
              l_contact_party_list(i),
              G_PRVW_REQUEST_ID,
              l_contact_date,
              sysdate,
              FND_GLOBAL.USER_ID,
              sysdate,
              FND_GLOBAL.USER_ID,
              FND_GLOBAL.USER_ID

            );

Line: 1111

   SELECT PARTY_LIST.PARTY_ID
   FROM
   (SELECT column_value PARTY_ID
   FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE)) ) PARTY_LIST
   WHERE EXISTS
         (SELECT PARTY_ID
          FROM AMS_TCOP_CONTACTS
          WHERE PARTY_ID = PARTY_LIST.PARTY_ID
          AND   CONTACT_DATE BETWEEN p_start_date and p_end_date
         );

Line: 1125

   SELECT PARTY_LIST.PARTY_ID
   FROM
   (SELECT column_value party_id
   FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))) PARTY_LIST
   WHERE EXISTS
         (SELECT PARTY_ID
          FROM AMS_TCOP_CONTACTS
          WHERE PARTY_ID = PARTY_LIST.PARTY_ID
          AND   MEDIA_ID = G_ACTIVITY_ID
          AND   CONTACT_DATE BETWEEN p_start_date and p_end_date
         );

Line: 1139

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
   FROM AMS_TCOP_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   GROUP BY CONTACT.PARTY_ID;

Line: 1151

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
   FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND   PREVIEW_ID = G_PRVW_REQUEST_ID
   GROUP BY CONTACT.PARTY_ID;

Line: 1166

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,COUNT(CONTACT.PARTY_ID)
   FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
        AMS_CAMPAIGN_SCHEDULES_B CSCH,
        (SELECT column_value party_id
         FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND   PREVIEW_ID = G_PRVW_REQUEST_ID
   AND   CSCH.SCHEDULE_ID = CONTACT.SCHEDULE_ID
   AND   CSCH.ACTIVITY_ID = G_ACTIVITY_ID
   GROUP BY CONTACT.PARTY_ID;

Line: 1185

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;

Line: 1197

   SELECT /*+ leading(party_list) +*/
         CONTACT.PARTY_ID,
         COUNT(CONTACT.PARTY_ID)
   FROM AMS_TCOP_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(G_PARTY_LIST as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND   CONTACT.MEDIA_ID = G_Activity_Id
   GROUP BY CONTACT.PARTY_ID;

Line: 1214

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.MEDIA_ID = G_ACTIVITY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;

Line: 1229

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
        (SELECT column_value party_id
         FROM   TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;

Line: 1243

   SELECT /*+ leading(party_list) +*/
   CONTACT.PARTY_ID,CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
        AMS_CAMPAIGN_SCHEDULES_B CSCH,
        (SELECT column_value party_id
         FROM   TABLE(CAST(p_fatigue_party_list as JTF_NUMBER_TABLE))
        ) party_list
   WHERE CONTACT.PARTY_ID = party_list.PARTY_ID
   AND   CONTACT.SCHEDULE_ID = CSCH.SCHEDULE_ID
   AND   CSCH.ACTIVITY_ID = G_ACTIVITY_ID
   AND   CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date;

Line: 1259

   SELECT party_list.party_id
   FROM
   (SELECT column_value party_id
    FROM TABLE(CAST(p_contact_party_list as JTF_NUMBER_TABLE))
   ) party_list
   WHERE party_list.party_id=p_party_id;

Line: 1271

   SELECT SCHEDULE_ID
   FROM AMS_TCOP_CONTACTS
   WHERE CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND   PARTY_ID = p_party_id;

Line: 1281

   SELECT CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_CONTACTS CONTACT
   WHERE CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND   CONTACT.MEDIA_ID = G_ACTIVITY_ID
   AND   CONTACT.PARTY_ID = p_party_id;

Line: 1293

   SELECT SCHEDULE_ID
   FROM AMS_TCOP_PRVW_CONTACTS
   WHERE CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND party_id = p_party_id
   AND PREVIEW_ID = G_PRVW_REQUEST_ID
   AND rownum = p_row_num
   ORDER BY CONTACT_DATE;

Line: 1307

   SELECT CONTACT.SCHEDULE_ID
   FROM AMS_TCOP_PRVW_CONTACTS CONTACT,
        AMS_CAMPAIGN_SCHEDULES_B CSCH
   WHERE CONTACT.CONTACT_DATE BETWEEN p_start_date and p_end_date
   AND CSCH.SCHEDULE_ID = CONTACT.SCHEDULE_ID
   AND CSCH.ACTIVITY_ID = G_ACTIVITY_ID
   AND CONTACT.party_id = p_party_id
   AND PREVIEW_ID = G_PRVW_REQUEST_ID
   AND rownum = p_row_num
   ORDER BY CONTACT.CONTACT_DATE;

Line: 1321

   SELECT AMS_TCOP_PRVW_FATIGUE_S.NEXTVAL
   FROM DUAL;

Line: 1326

   SELECT ams_tcop_prvw_ftg_dtls_s.NEXTVAL
   FROM DUAL;

Line: 1331

   SELECT ams_tcop_prvw_ftg_by_s.nextval
   FROM DUAL;

Line: 1449

                        l_global_party_list.delete(i);

Line: 1450

                        l_global_contact_count_list.delete(i);

Line: 1478

                  DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 1481

                  l_temp_fatigue_party_list.delete;

Line: 1482

                  l_temp_fatigue_by_party_list.delete;

Line: 1483

                  l_temp_ftg_by_schedule_list.delete;

Line: 1655

               DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 1658

               l_temp_fatigue_party_list.delete;

Line: 1659

               l_temp_fatigue_by_party_list.delete;

Line: 1660

               l_temp_ftg_by_schedule_list.delete;

Line: 1698

                  DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 1701

                  l_temp_fatigue_party_list.delete;

Line: 1702

                  l_temp_fatigue_by_party_list.delete;

Line: 1703

                  l_temp_ftg_by_schedule_list.delete;

Line: 1704

                  l_temp_fatigue_by_party_list.delete;

Line: 1705

                  l_temp_ftg_by_schedule_list.delete;

Line: 1783

                  DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 1788

               l_temp_fatigue_party_list.delete;

Line: 1789

               l_temp_fatigue_by_party_list.delete;

Line: 1790

               l_temp_ftg_by_schedule_list.delete;

Line: 1974

               DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 1977

               l_temp_fatigue_party_list.delete;

Line: 1978

               l_temp_fatigue_by_party_list.delete;

Line: 1979

               l_temp_ftg_by_schedule_list.delete;

Line: 2016

                  DELETE_FROM_LIST(G_PARTY_LIST,l_temp_fatigue_party_list);

Line: 2019

                  l_temp_fatigue_party_list.delete;

Line: 2020

                  l_temp_fatigue_by_party_list.delete;

Line: 2021

                  l_temp_ftg_by_schedule_list.delete;

Line: 2049

   INSERT INTO AMS_TCOP_PRVW_FATIGUE
   (
   PREVIEW_ID,
   REQUEST_ID,
   PREVIEW_DATE,
   FATIGUE_COUNT,
   CREATION_DATE,
   CREATED_BY,
   LAST_UPDATE_DATE,
   LAST_UPDATED_BY,
   LAST_UPDATE_LOGIN
   )
   VALUES
   (
   l_preview_id,
   G_PRVW_REQUEST_ID,
   p_preview_date,
   l_fatigue_count,
   sysdate,
   FND_GLOBAL.USER_ID,
   sysdate,
   FND_GLOBAL.USER_ID,
   FND_GLOBAL.USER_ID
   );

Line: 2121

      INSERT INTO AMS_TCOP_PRVW_FTG_DTLS
      (
        FATIGUE_DETAIL_ID,
        PREVIEW_ID,
        PARTY_ID,
        CREATION_DATE,
        CREATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_LOGIN
      )
      VALUES
      (
         l_fatigue_detail_list(i),
         l_preview_id,
         G_FATIGUE_PARTY_LIST(i),
         sysdate,
         FND_GLOBAL.USER_ID,
         sysdate,
         FND_GLOBAL.USER_ID,
         FND_GLOBAL.USER_ID
      );

Line: 2151

   INSERT INTO AMS_TCOP_PRVW_FTG_BY
   (
     FATIGUE_BY_ID,
     FATIGUE_DETAIL_ID,
     SCHEDULE_ID,
     CREATION_DATE,
     CREATED_BY,
     LAST_UPDATE_DATE,
     LAST_UPDATED_BY,
     LAST_UPDATE_LOGIN

   )
   VALUES
   (
      l_fatigue_by_id_list(i),
      l_fatigue_detail_id_list(i),
      G_FATIGUE_BY_SCHEDULE_LIST(i),
      sysdate,
      FND_GLOBAL.USER_ID,
      sysdate,
      FND_GLOBAL.USER_ID,
      FND_GLOBAL.USER_ID
   );

Line: 2178

   G_PARTY_LIST.DELETE;

Line: 2179

   G_FATIGUE_PARTY_LIST.DELETE;

Line: 2180

   G_FATIGUE_BY_PARTY_LIST.DELETE;

Line: 2181

   G_FATIGUE_BY_SCHEDULE_LIST.DELETE;

Line: 2199

   SELECT CSCH.SCHEDULE_ID,CSCH.START_DATE_TIME,CSCH.ACTIVITY_ID,CAMP.ACTUAL_EXEC_END_DATE
   FROM   AMS_CAMPAIGN_SCHEDULES_B CSCH,
          AMS_ACT_LISTS ACT_LIST,ams_campaigns_vl CAMP
   WHERE  ACT_LIST.LIST_HEADER_ID = p_list_header_id
   AND    CSCH.SCHEDULE_ID = ACT_LIST.LIST_USED_BY_ID
   AND    ACT_LIST.LIST_USED_BY = 'CSCH'
   AND    ACT_LIST.LIST_ACT_TYPE='TARGET'
   AND CSCH.CAMPAIGN_ID=CAMP.CAMPAIGN_ID;

Line: 2211

   SELECT PARTY_ID
   FROM AMS_LIST_ENTRIES
   WHERE LIST_HEADER_ID = p_list_header_id
   AND   ENABLED_FLAG='Y';

Line: 2219

   SELECT RULE.RULE_TYPE RULE_TYPE,
          RULE.MAX_CONTACT_ALLOWED MAX_CONTACT_ALLOWED,
          PERIOD.NO_OF_DAYS NO_OF_DAYS
   FROM   AMS_TCOP_FR_PERIODS_B PERIOD,
          AMS_TCOP_FR_RULES_SETUP RULE
   WHERE  RULE.PERIOD_ID = PERIOD.PERIOD_ID
   AND (RULE.CHANNEL_ID IS NULL OR RULE.CHANNEL_ID = p_activity_id);

Line: 2363

   UPDATE AMS_TCOP_PRVW_REQUESTS
   SET STATUS='COMPLETE',
	   LAST_UPDATE_DATE = sysdate,
	   LAST_UPDATED_BY = FND_GLOBAL.USER_ID
   WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line: 2369

   DELETE FROM AMS_TCOP_PRVW_CONTACTS
   WHERE PREVIEW_ID = G_PRVW_REQUEST_ID;

Line: 2372

   DELETE FROM AMS_TCOP_PRVW_FATIGUE
   WHERE
   REQUEST_ID IN
   (
	   SELECT REQUEST_ID FROM AMS_TCOP_PRVW_REQUESTS
	   WHERE LIST_HEADER_ID = p_list_header_id
	   AND REQUEST_ID <> G_PRVW_REQUEST_ID
   );

Line: 2382

   DELETE FROM AMS_TCOP_PRVW_REQUESTS
   WHERE LIST_HEADER_ID = p_list_header_id
   AND REQUEST_ID <> G_PRVW_REQUEST_ID;

Line: 2413

   UPDATE AMS_TCOP_PRVW_REQUESTS
   SET STATUS='ACTIVE',
   LAST_UPDATE_DATE = sysdate,
   LAST_UPDATED_BY = FND_GLOBAL.USER_ID
   WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line: 2433

		UPDATE AMS_TCOP_PRVW_REQUESTS
		SET STATUS='ERROR',
		LAST_UPDATE_DATE = sysdate,
		LAST_UPDATED_BY = FND_GLOBAL.USER_ID
		WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line: 2460

    SELECT COUNT(PARTY_ID)
    FROM AMS_LIST_ENTRIES
    WHERE LIST_HEADER_ID = p_list_header_id
    AND   ENABLED_FLAG='Y';

Line: 2487

   UPDATE AMS_TCOP_PRVW_REQUESTS
   SET STATUS='ACTIVE',
   LAST_UPDATE_DATE = sysdate,
   LAST_UPDATED_BY = FND_GLOBAL.USER_ID
   WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line: 2504

		UPDATE AMS_TCOP_PRVW_REQUESTS
		SET STATUS='ERROR',
		LAST_UPDATE_DATE = sysdate,
		LAST_UPDATED_BY = FND_GLOBAL.USER_ID
		WHERE REQUEST_ID=G_PRVW_REQUEST_ID;

Line: 2532

    SELECT REQUEST_ID, STATUS
    FROM AMS_TCOP_PRVW_REQUESTS
    WHERE LIST_HEADER_ID = p_list_header_id
    and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);

Line: 2539

    SELECT COUNT(PARTY_ID)
    FROM AMS_LIST_ENTRIES
    WHERE LIST_HEADER_ID = p_list_header_id
    AND   ENABLED_FLAG='Y';

Line: 2602

			select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;

Line: 2610

			l_parameter_list.DELETE;

Line: 2642

    SELECT REQUEST_ID, STATUS
    FROM AMS_TCOP_PRVW_REQUESTS
    WHERE LIST_HEADER_ID = p_list_header_id
    and REQUEST_ID = (select max(REQUEST_ID) from AMS_TCOP_PRVW_REQUESTS where LIST_HEADER_ID = p_list_header_id);

Line: 2649

    SELECT COUNT(PARTY_ID)
    FROM AMS_LIST_ENTRIES
    WHERE LIST_HEADER_ID = p_list_header_id
    AND   ENABLED_FLAG='Y';

Line: 2719

			select to_char(sysdate, 'YYYYMMDDHH24MISS') into l_event_key from dual;

Line: 2727

			l_parameter_list.DELETE;