APPS.AMS_TCOP_PREVIEW dependencies on AMS_TCOP_PRVW_FTG_BY

Line 1331: SELECT ams_tcop_prvw_ftg_by_s.nextval

1327: FROM DUAL;
1328:
1329: CURSOR C_GET_NEXT_FTG_BY
1330: IS
1331: SELECT ams_tcop_prvw_ftg_by_s.nextval
1332: FROM DUAL;
1333:
1334: l_party_id NUMBER;
1335: l_global_fatigue_start_date Date;

Line 2104: -- Set the correct data for AMS_TCOP_PRVW_FTG_BY

2100: l_fatigue_detail_list.extend;
2101: l_fatigue_detail_list(i) := l_fatigue_dtl_id;
2102:
2103: IF (G_FATIGUE_BY_PARTY_LIST.count > 0 ) THEN
2104: -- Set the correct data for AMS_TCOP_PRVW_FTG_BY
2105: FOR j IN G_FATIGUE_BY_PARTY_LIST.FIRST .. G_FATIGUE_BY_PARTY_LIST.LAST
2106: LOOP
2107: IF (G_FATIGUE_BY_PARTY_LIST(j) = G_FATIGUE_PARTY_LIST(i)) THEN
2108: -- set the sequence Id

Line 2149: -- Create entries in AMS_TCOP_PRVW_FTG_BY

2145: IF (G_FATIGUE_BY_SCHEDULE_LIST.count > 0 ) THEN
2146: --dbms_output.put_line('Accessing 1 '||to_char(l_fatigue_by_id_list(363)));
2147: --dbms_output.put_line('Accessing 2 '||to_char(l_fatigue_detail_id_list(363)));
2148: --dbms_output.put_line('Accessing 3 '||to_char(g_fatigue_by_schedule_list(363)));
2149: -- Create entries in AMS_TCOP_PRVW_FTG_BY
2150: FORALL i in G_FATIGUE_BY_SCHEDULE_LIST.FIRST .. G_FATIGUE_BY_SCHEDULE_LIST.LAST
2151: INSERT INTO AMS_TCOP_PRVW_FTG_BY
2152: (
2153: FATIGUE_BY_ID,

Line 2151: INSERT INTO AMS_TCOP_PRVW_FTG_BY

2147: --dbms_output.put_line('Accessing 2 '||to_char(l_fatigue_detail_id_list(363)));
2148: --dbms_output.put_line('Accessing 3 '||to_char(g_fatigue_by_schedule_list(363)));
2149: -- Create entries in AMS_TCOP_PRVW_FTG_BY
2150: FORALL i in G_FATIGUE_BY_SCHEDULE_LIST.FIRST .. G_FATIGUE_BY_SCHEDULE_LIST.LAST
2151: INSERT INTO AMS_TCOP_PRVW_FTG_BY
2152: (
2153: FATIGUE_BY_ID,
2154: FATIGUE_DETAIL_ID,
2155: SCHEDULE_ID,