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.GCS_DP_DYNAMIC_PKG dependencies on GCS_ENTRY_HEADERS

Line 713: SELECT gcs_entry_headers_s.NEXTVAL

709: IF l_periods_list.FIRST IS NULL THEN
710: RAISE no_data_error;
711: END IF;
712:
713: SELECT gcs_entry_headers_s.NEXTVAL
714: INTO l_entry_id
715: FROM DUAL;
716: SELECT gcs_entry_headers_s.NEXTVAL
717: INTO l_stat_entry_id

Line 716: SELECT gcs_entry_headers_s.NEXTVAL

712:
713: SELECT gcs_entry_headers_s.NEXTVAL
714: INTO l_entry_id
715: FROM DUAL;
716: SELECT gcs_entry_headers_s.NEXTVAL
717: INTO l_stat_entry_id
718: FROM DUAL;
719:
720: -------------------------------------------

Line 981: SELECT gcs_entry_headers_s.NEXTVAL

977: p_process_code => 'SINGLE_RUN_FOR_PERIOD',
978: p_category_code => 'DATAPREPARATION'
979: );
980: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
981: SELECT gcs_entry_headers_s.NEXTVAL
982: INTO l_proportional_entry_id
983: FROM DUAL;
984:
985: gcs_entry_pkg.create_entry_header

Line 1027: SELECT gcs_entry_headers_s.NEXTVAL

1023: p_category_code => 'DATAPREPARATION'
1024: );
1025:
1026: IF p_owner_percentage IS NOT NULL AND p_owner_percentage <> 1 THEN
1027: SELECT gcs_entry_headers_s.NEXTVAL
1028: INTO l_stat_proportional_entry_id
1029: FROM DUAL;
1030:
1031: gcs_entry_pkg.create_entry_header

Line 1305: FROM gcs_entry_headers

1301: );
1302: --bug fix 3797312
1303: SELECT DECODE(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', 'COMPLETED')
1304: INTO retcode
1305: FROM gcs_entry_headers
1306: WHERE entry_id = l_entry_id;
1307: END IF;
1308:
1309: -- bug fix 3800183

Line 1368: FROM gcs_entry_headers

1364: p_threshold_currency_code => l_threshold_currency
1365: );
1366: SELECT decode(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', 'COMPLETED')
1367: INTO retcode
1368: FROM gcs_entry_headers
1369: WHERE entry_id = l_proportional_entry_id;
1370: ELSE
1371: retcode := gcs_utility_pkg.g_ret_sts_success;
1372: END IF;

Line 1443: DELETE FROM gcs_entry_headers

1439: retcode := gcs_utility_pkg.g_ret_sts_error;
1440: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_SUSPENSE_ERR');
1441: errbuf := fnd_message.get;
1442:
1443: DELETE FROM gcs_entry_headers
1444: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
1445: l_proportional_entry_id, l_stat_proportional_entry_id);
1446: DELETE FROM gcs_entry_lines
1447: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 1466: DELETE FROM gcs_entry_headers

1462: retcode := gcs_utility_pkg.g_ret_sts_error;
1463: FND_MESSAGE.set_name('GCS', 'GCS_DP_NO_RE_ERR');
1464: errbuf := fnd_message.get;
1465:
1466: DELETE FROM gcs_entry_headers
1467: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
1468: l_proportional_entry_id, l_stat_proportional_entry_id);
1469: DELETE FROM gcs_entry_lines
1470: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 1513: DELETE FROM gcs_entry_headers

1509: WHEN others THEN
1510: retcode := gcs_utility_pkg.g_ret_sts_error;
1511: errbuf := SQLERRM;
1512:
1513: DELETE FROM gcs_entry_headers
1514: WHERE entry_id IN (l_entry_id, l_stat_entry_id,
1515: l_proportional_entry_id, l_stat_proportional_entry_id);
1516: DELETE FROM gcs_entry_lines
1517: WHERE entry_id IN (l_entry_id, l_stat_entry_id,

Line 1586: SELECT gcs_entry_headers_s.NEXTVAL

1582: IF (retcode <> gcs_utility_pkg.g_ret_sts_success)
1583: THEN
1584: RAISE init_mapping_error;
1585: END IF;
1586: SELECT gcs_entry_headers_s.NEXTVAL
1587: INTO x_entry_id
1588: FROM DUAL;
1589: SELECT gcs_entry_headers_s.NEXTVAL
1590: INTO x_stat_entry_id

Line 1589: SELECT gcs_entry_headers_s.NEXTVAL

1585: END IF;
1586: SELECT gcs_entry_headers_s.NEXTVAL
1587: INTO x_entry_id
1588: FROM DUAL;
1589: SELECT gcs_entry_headers_s.NEXTVAL
1590: INTO x_stat_entry_id
1591: FROM DUAL;
1592: IF (l_mapping_required = 'N') THEN
1593: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement

Line 1796: SELECT gcs_entry_headers_s.NEXTVAL

1792: null;
1793: END;
1794: IF l_has_stat_row_flag = 'Y' THEN
1795: if p_owner_percentage <> 1 THEN
1796: SELECT gcs_entry_headers_s.NEXTVAL
1797: INTO x_stat_prop_entry_id
1798: FROM DUAL;
1799: END IF;
1800: ELSE

Line 1805: SELECT gcs_entry_headers_s.NEXTVAL

1801: x_stat_entry_id := NULL;
1802: END IF;
1803: IF l_has_row_flag = 'Y' THEN
1804: if p_owner_percentage <> 1 THEN
1805: SELECT gcs_entry_headers_s.NEXTVAL
1806: INTO x_prop_entry_id
1807: FROM DUAL;
1808: END IF;
1809: ELSE

Line 1923: FROM gcs_entry_headers

1919: p_threshold_currency_code => l_threshold_currency
1920: );
1921: SELECT DECODE(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)
1922: INTO retcode
1923: FROM gcs_entry_headers
1924: WHERE entry_id = x_entry_id;
1925: END IF;
1926: IF (x_prop_entry_id IS NOT NULL or x_stat_prop_entry_id IS NOT NULL)
1927: THEN

Line 1971: FROM gcs_entry_headers

1967: );
1968:
1969: SELECT decode(SUSPENSE_EXCEEDED_FLAG, 'Y', 'WARNING', gcs_utility_pkg.g_ret_sts_success)
1970: INTO retcode
1971: FROM gcs_entry_headers
1972: WHERE entry_id = x_prop_entry_id;
1973: ELSE
1974: retcode := gcs_utility_pkg.g_ret_sts_success;
1975: END IF;