eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_SUM_BKLG dependencies on DUAL

Line 439: FROM dual

435: , nvl(-p_ex_strt_bklg,0) + p_strt_bklg DORMANT_BACKLOG_START
436: , nvl(-p_ex_lost_bklg,0) + p_lost_bklg LOST_BACKLOG
437: , nvl(-p_ex_actv_bklg,0) + p_actv_bklg ACTIVE_BACKLOG
438: , nvl(-p_ex_risky_rev,0) + p_risky_rev REVENUE_AT_RISK
439: FROM dual
440: ;
441: End Insert_Backlog_Updates_pvt;
442:
443:

Line 767: l_bkt_dual NUMBER :=0;

763: l_last_activity_date NUMBER;
764: l_last_date NUMBER;
765: l_prev_date NUMBER;
766: l_first_currency NUMBER;
767: l_bkt_dual NUMBER :=0;
768: l_called_before VARCHAR2(1) :='N';
769: l_curr_date NUMBER;
770: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;
771: l_record_type VARCHAR2(1);

Line 880: From Dual

876: , to_number(null) as DORMANT_BACKLOG_START
877: , to_number(null) as LOST_BACKLOG
878: , to_number(null) as ACTIVE_BACKLOG
879: , to_number(null) as REVENUE_AT_RISK
880: From Dual
881: union all
882: Select
883: -l_worker_id as worker_id
884: , to_number(l_project_id) as project_id

Line 899: From Dual

895: , to_number(null) as DORMANT_BACKLOG_START
896: , to_number(null) as LOST_BACKLOG
897: , to_number(null) as ACTIVE_BACKLOG
898: , to_number(null) as REVENUE_AT_RISK
899: From Dual
900: Where l_g2_currency_flag = 'Y'
901: union all
902: Select
903: -l_worker_id as worker_id

Line 985: l_bkt_dual := 0;

981: l_first_currency := 0;
982:
983: For rec_bklg in csr_bklg LOOP
984:
985: l_bkt_dual := 0;
986:
987: IF rec_bklg.time_id = -1 THEN
988:
989: l_itd_rev := rec_bklg.revenue;

Line 1004: l_bkt_dual := 1;

1000: l_curr_status := 'UNKNOWN';
1001:
1002: l_first_currency := rec_bklg.curr_record_type_id;
1003: g_last_activity_date := l_scope_min_date;
1004: l_bkt_dual := 1;
1005: l_called_before := 'N';
1006:
1007: ELSIF (rec_bklg.time_id = to_number(to_char(l_max_date-1,'j'))) THEN
1008: -- check dormancy for the last record

Line 1013: l_bkt_dual := 0;

1009:
1010: l_curr_rev := 0;
1011: l_curr_fnd := 0;
1012:
1013: l_bkt_dual := 0;
1014:
1015: ELSE
1016: l_bkt_dual := 0;
1017:

Line 1016: l_bkt_dual := 0;

1012:
1013: l_bkt_dual := 0;
1014:
1015: ELSE
1016: l_bkt_dual := 0;
1017:
1018: If (bitand(l_first_currency,
1019: rec_bklg.curr_record_type_id) = 0) Then
1020: -- corner case of no ITD record

Line 1033: l_bkt_dual := 1;

1029:
1030: l_curr_status := 'UNKNOWN';
1031: l_first_currency := rec_bklg.curr_record_type_id;
1032: g_last_activity_date := rec_bklg.time_id;
1033: l_bkt_dual := 1;
1034: l_called_before := 'N';
1035:
1036: End If;
1037:

Line 1049: WHILE l_bkt_dual < 3 Loop

1045: -- The second time for a virtual date if required
1046: -- The third time for the normal date
1047:
1048:
1049: WHILE l_bkt_dual < 3 Loop
1050:
1051: l_ex_drmt_bklg := rec_bklg.DORMANT_BACKLOG_INACTIV;
1052: l_ex_strt_bklg := rec_bklg.DORMANT_BACKLOG_START;
1053: l_ex_lost_bklg := rec_bklg.LOST_BACKLOG;

Line 1058: IF ( l_bkt_dual < 1

1054: l_ex_actv_bklg := rec_bklg.ACTIVE_BACKLOG;
1055: l_ex_risky_rev := rec_bklg.REVENUE_AT_RISK;
1056:
1057:
1058: IF ( l_bkt_dual < 1
1059: and g_last_activity_date < l_close_julian_date
1060: and l_close_julian_date <= rec_bklg.time_id
1061: and (rec_bklg.time_id <> to_number(to_char(l_max_date-1,'j'))
1062: or

Line 1072: l_bkt_dual := 1;

1068: l_curr_date := l_close_julian_date ;
1069: l_curr_rev := rec_bklg.revenue;
1070: l_curr_fnd := rec_bklg.funding;
1071:
1072: l_bkt_dual := 1;
1073:
1074: ELSIF ( l_bkt_dual < 2
1075: and (g_last_activity_date + l_dbklg_days + 1) <= rec_bklg.time_id
1076: and (g_last_activity_date + l_dbklg_days + 1) < l_close_julian_date

Line 1074: ELSIF ( l_bkt_dual < 2

1070: l_curr_fnd := rec_bklg.funding;
1071:
1072: l_bkt_dual := 1;
1073:
1074: ELSIF ( l_bkt_dual < 2
1075: and (g_last_activity_date + l_dbklg_days + 1) <= rec_bklg.time_id
1076: and (g_last_activity_date + l_dbklg_days + 1) < l_close_julian_date
1077: and l_called_before = 'N' ) THEN -- the virtual case
1078:

Line 1090: l_bkt_dual :=2;

1086: l_ex_actv_bklg := 0;
1087: l_ex_risky_rev := 0;
1088:
1089: IF (rec_bklg.time_id <> to_number(to_char(l_max_date-1,'j'))) THEN
1090: l_bkt_dual :=2;
1091: ELSE -- the last record is virtual
1092: -- thus the normal case should not be called
1093: l_bkt_dual :=99;
1094: END IF;

Line 1093: l_bkt_dual :=99;

1089: IF (rec_bklg.time_id <> to_number(to_char(l_max_date-1,'j'))) THEN
1090: l_bkt_dual :=2;
1091: ELSE -- the last record is virtual
1092: -- thus the normal case should not be called
1093: l_bkt_dual :=99;
1094: END IF;
1095:
1096: l_called_before := 'Y';
1097:

Line 1110: l_bkt_dual := 3;

1106: l_curr_rev := rec_bklg.revenue;
1107: l_curr_fnd := rec_bklg.funding;
1108: END IF;
1109:
1110: l_bkt_dual := 3;
1111: END IF;
1112:
1113: IF (l_curr_date < to_number(to_char(l_max_date-1,'j'))) THEN
1114: Backlog_Bucketing_pvt

Line 1148: End Loop; -- for l_bkt_dual

1144: , p_ex_risky_rev => l_ex_risky_rev
1145: );
1146: END IF; -- (l_curr_date < to_number(to_char(l_max_date-1,'j')))
1147:
1148: End Loop; -- for l_bkt_dual
1149:
1150: if l_curr_rev <> 0 then
1151: g_last_activity_date := l_curr_date;
1152: l_called_before := 'N';

Line 1187: l_dual_limit NUMBER := 0;

1183: l_max_date DATE := PJI_RM_SUM_MAIN.g_max_date;
1184: --temptemp needs to be PJI_PJI_LAST_EXTR_DATE
1185: last_extr_date DATE := to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD');
1186: l_commit_counter NUMBER := 0;
1187: l_dual_limit NUMBER := 0;
1188: l_dual NUMBER := 0;
1189: l_min_nocal_date DATE;
1190: l_min_cal_date DATE;
1191: l_prev_project NUMBER;

Line 1188: l_dual NUMBER := 0;

1184: --temptemp needs to be PJI_PJI_LAST_EXTR_DATE
1185: last_extr_date DATE := to_date(PJI_UTILS.GET_PARAMETER('LAST_FM_EXTR_DATE'),'YYYY/MM/DD');
1186: l_commit_counter NUMBER := 0;
1187: l_dual_limit NUMBER := 0;
1188: l_dual NUMBER := 0;
1189: l_min_nocal_date DATE;
1190: l_min_cal_date DATE;
1191: l_prev_project NUMBER;
1192: l_rowcount number := 0;

Line 1247: l_dual_limit := 2;

1243: -- Next we determine how many times the main procedure needs to be called
1244: -- for a given project
1245:
1246: IF l_pa_calendar_flag = 'Y' THEN
1247: l_dual_limit := 2;
1248: ELSE
1249: l_dual_limit := 1;
1250: END IF;
1251:

Line 1249: l_dual_limit := 1;

1245:
1246: IF l_pa_calendar_flag = 'Y' THEN
1247: l_dual_limit := 2;
1248: ELSE
1249: l_dual_limit := 1;
1250: END IF;
1251:
1252:
1253: l_prev_project := -99;

Line 1330: l_dual := 0;

1326: And PARALLEL_BACKLOG_WORKER_ID = p_worker_id
1327: ;
1328:
1329: IF (l_prev_project <> l_curr_project_id) THEN
1330: l_dual := 0;
1331: END IF;
1332:
1333: WHILE l_dual < l_dual_limit Loop
1334:

Line 1333: WHILE l_dual < l_dual_limit Loop

1329: IF (l_prev_project <> l_curr_project_id) THEN
1330: l_dual := 0;
1331: END IF;
1332:
1333: WHILE l_dual < l_dual_limit Loop
1334:
1335:
1336: SELECT /*+ ORDERED */
1337: map.project_id

Line 1384: IF (l_dual = 0) Then

1380: -- that is when the pa_calendar_id is null
1381: -- The second time we call for the period type of PA
1382: -- that is when the pa_calendar_id is NOT null
1383:
1384: IF (l_dual = 0) Then
1385: l_min_julian_date := to_number(to_char(l_min_nocal_date,'j'));
1386: l_calendar_id := null;
1387: ELSIF (l_dual = 1) Then
1388: l_min_julian_date := to_number(to_char(l_min_cal_date,'j'));

Line 1387: ELSIF (l_dual = 1) Then

1383:
1384: IF (l_dual = 0) Then
1385: l_min_julian_date := to_number(to_char(l_min_nocal_date,'j'));
1386: l_calendar_id := null;
1387: ELSIF (l_dual = 1) Then
1388: l_min_julian_date := to_number(to_char(l_min_cal_date,'j'));
1389: END IF;
1390:
1391: Calculate_Drmt_Bklg(

Line 1404: l_dual := l_dual + 1;

1400: , p_min_julian_date => l_min_julian_date
1401: , p_close_julian_date => l_close_julian_date
1402: );
1403:
1404: l_dual := l_dual + 1;
1405:
1406: end loop; -- WHILE l_dual < 3
1407:
1408: l_prev_project := l_curr_project_id;

Line 1406: end loop; -- WHILE l_dual < 3

1402: );
1403:
1404: l_dual := l_dual + 1;
1405:
1406: end loop; -- WHILE l_dual < 3
1407:
1408: l_prev_project := l_curr_project_id;
1409:
1410: Update pji_pji_proj_batch_map