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.CE_FORECAST_UTILS dependencies on CE_FORECAST_COLUMNS

Line 70: FROM ce_forecast_columns

66: FROM ce_fc_aging_buckets_v
67: WHERE developer_column_num > 0
68: ORDER BY developer_column_num;
69: cursor cCol(phid NUMBER) is SELECT forecast_column_id
70: FROM ce_forecast_columns
71: WHERE forecast_header_id = phid
72: AND developer_column_num > 0
73: ORDER BY developer_column_num;
74:

Line 236: FROM ce_forecast_columns

232: l_count NUMBER;
233: BEGIN
234: SELECT forecast_column_id
235: INTO l_forecast_column_id
236: FROM ce_forecast_columns
237: WHERE forecast_header_id = X_forecast_header_id
238: AND developer_column_num = 1;
239:
240: FOR p_fc IN C_fc LOOP

Line 464: FROM ce_forecast_columns

460: attribute12,
461: attribute13,
462: attribute14,
463: attribute15
464: FROM ce_forecast_columns
465: WHERE forecast_header_id = X_forecast_header_id;
466:
467: CURSOR C_fperiod IS SELECT forecast_period_id,
468: forecast_header_id,

Line 770: select ce_forecast_columns_s.nextval

766: end if;
767: END LOOP;
768:
769: FOR p_fcol in C_fcol LOOP
770: select ce_forecast_columns_s.nextval
771: into l_forecast_column_id
772: from dual;
773:
774: INSERT INTO ce_forecast_columns(

Line 774: INSERT INTO ce_forecast_columns(

770: select ce_forecast_columns_s.nextval
771: into l_forecast_column_id
772: from dual;
773:
774: INSERT INTO ce_forecast_columns(
775: forecast_column_id,
776: forecast_header_id,
777: column_number,
778: days_from,

Line 884: | Populates ce_forecast_columns based on the aging-bucket |

880: | PUBLIC PROCEDURE |
881: | populate_temp_buckets |
882: | |
883: | DESCRIPTION |
884: | Populates ce_forecast_columns based on the aging-bucket |
885: | information in ce_forecast_periods |
886: | CALLED BY |
887: | populate_aging_buckets |
888: | REQUIRES |

Line 932: DELETE FROM ce_forecast_columns

928:
929: BEGIN
930:
931: /* BEGIN
932: DELETE FROM ce_forecast_columns
933: WHERE forecast_header_id = p_forecast_header_id
934: AND developer_column_num > 0;
935: IF SQL%FOUND THEN
936: COMMIT;

Line 967: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)

963: l_column_num := l_column_num + 1;
964: l_days_to := l_days_from;
965:
966: IF l_column_num <= 80 THEN
967: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
968: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
969: ELSE
970: --More than 80 columns
971: EXIT;

Line 968: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

964: l_days_to := l_days_from;
965:
966: IF l_column_num <= 80 THEN
967: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
968: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
969: ELSE
970: --More than 80 columns
971: EXIT;
972: END IF;

Line 985: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)

981: l_column_num := l_column_num + 1;
982: l_days_to := l_days_from + 6;
983:
984: IF l_column_num <= 80 THEN
985: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
986: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
987: ELSE
988: --More than 80 columns
989: EXIT;

Line 986: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

982: l_days_to := l_days_from + 6;
983:
984: IF l_column_num <= 80 THEN
985: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
986: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
987: ELSE
988: --More than 80 columns
989: EXIT;
990: END IF;

Line 1003: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)

999: l_column_num := l_column_num + 1;
1000: l_days_to := l_days_from + TRUNC(LAST_DAY(l_current_date)) - l_current_date;
1001:
1002: IF l_column_num <= 80 THEN
1003: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1004: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
1005: ELSE
1006: --More than 80 columns
1007: EXIT;

Line 1004: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);

1000: l_days_to := l_days_from + TRUNC(LAST_DAY(l_current_date)) - l_current_date;
1001:
1002: IF l_column_num <= 80 THEN
1003: INSERT INTO ce_forecast_columns(forecast_column_id, forecast_header_id, column_number, days_from, days_to, developer_column_num, created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1004: VALUES (ce_forecast_columns_s.nextval, p_rec.forecast_header_id, l_column_num, l_days_from, l_days_to, l_column_num, p_rec.created_by, p_rec.creation_date, p_rec.last_updated_by, p_rec.last_update_date, p_rec.last_update_login);
1005: ELSE
1006: --More than 80 columns
1007: EXIT;
1008: END IF;

Line 1370: from ce_forecast_columns

1366: PROCEDURE populate_dev_columns ( p_forecast_header_id NUMBER) IS
1367:
1368: cursor col_cur (hid number) is
1369: select rowid, forecast_column_id, forecast_header_id, column_number
1370: from ce_forecast_columns
1371: where forecast_header_id = hid
1372: order by column_number
1373: for update nowait;
1374:

Line 1407: update ce_forecast_columns

1403: l_dev_num(i) := ct;
1404: end loop;
1405:
1406: forall i in l_cid.first..l_cid.last
1407: update ce_forecast_columns
1408: set developer_column_num = l_dev_num(i)
1409: where forecast_column_id = l_cid(i);
1410:
1411: end if;