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_INTERCO_PROCESSING_PKG dependencies on GCS_CONS_ENG_RUN_DTLS

Line 1236: FROM GCS_CONS_ENG_RUN_DTLS gcer

1232: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1233: gib.sus_user_dim10_id, fc.currency_code) git
1234: WHERE NOT EXISTS
1235: (SELECT 'X'
1236: FROM GCS_CONS_ENG_RUN_DTLS gcer
1237: WHERE gcer.child_entity_id = git.src_id
1238: AND gcer.contra_child_entity_id = git.tar_id
1239: AND gcer.run_name = g_consolidation_run_name);
1240:

Line 1371: FROM GCS_CONS_ENG_RUN_DTLS gcer

1367: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1368: gib.sus_user_dim10_id, fc.currency_code) git
1369: WHERE NOT EXISTS
1370: (SELECT 'X'
1371: FROM GCS_CONS_ENG_RUN_DTLS gcer
1372: WHERE gcer.child_entity_id = git.src_id
1373: AND gcer.contra_child_entity_id = git.tar_id
1374: AND gcer.run_name = g_consolidation_run_name);
1375:

Line 1403: (SELECT 'X' FROM GCS_CONS_ENG_RUN_DTLS gcer

1399: END IF;
1400:
1401: DELETE FROM GCS_INTERCO_HDR_GT gihg
1402: WHERE EXISTS
1403: (SELECT 'X' FROM GCS_CONS_ENG_RUN_DTLS gcer
1404: WHERE gcer.run_name = g_consolidation_run_name
1405: AND gcer.category_code = 'INTERCOMPANY'
1406: AND gcer.child_entity_id = gihg.target_entity_id
1407: AND gcer.contra_child_entity_id =

Line 1532: || 'into GCS_CONS_ENG_RUN_DTLS '

1528: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1529: fnd_log.STRING (fnd_log.level_procedure,
1530: g_pkg_name || '.' || l_api_name,
1531: 'Insert avialable information '
1532: || 'into GCS_CONS_ENG_RUN_DTLS '
1533: || ' if there is an error the information will be'
1534: || ' saved upto this point.'
1535: );
1536: END IF;

Line 1538: INSERT INTO gcs_cons_eng_run_dtls

1534: || ' saved upto this point.'
1535: );
1536: END IF;
1537:
1538: INSERT INTO gcs_cons_eng_run_dtls
1539: (run_detail_id, run_name, Consolidation_entity_id
1540: , child_entity_id, contra_child_entity_id, entry_id, rule_id,
1541: request_error_code, bp_request_error_code, category_code,
1542: creation_date, created_by, last_update_date,

Line 1544: SELECT gcs_cons_eng_run_dtls_s.nextval,

1540: , child_entity_id, contra_child_entity_id, entry_id, rule_id,
1541: request_error_code, bp_request_error_code, category_code,
1542: creation_date, created_by, last_update_date,
1543: last_updated_by, last_update_login)
1544: SELECT gcs_cons_eng_run_dtls_s.nextval,
1545: g_consolidation_run_name,
1546: DECODE(g_elim_code, 'IE',p_entity_id,'IA', g_cons_entity_id),
1547: gehg.source_entity_id, gehg.target_entity_id,
1548: gehg.entry_id, gehg.rule_id,

Line 1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1559:
1560: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1562: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1563: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1564:
1565: FND_LOG.String (fnd_log.level_procedure,
1566: g_pkg_name || '.' || l_api_name,
1567: 'SHRD0117: '||FND_MESSAGE.get);

Line 1578: || 'into GCS_CONS_ENG_RUN_DTLS '

1574: fnd_log.STRING (fnd_log.level_procedure,
1575: g_pkg_name || '.' || l_api_name,
1576: 'STAT rows- with serate rule'
1577: ||' Insert avialable information '
1578: || 'into GCS_CONS_ENG_RUN_DTLS '
1579: || ' if there is an error the information will be'
1580: || ' saved upto this point.'
1581: );
1582: END IF;

Line 1584: INSERT INTO gcs_cons_eng_run_dtls

1580: || ' saved upto this point.'
1581: );
1582: END IF;
1583:
1584: INSERT INTO gcs_cons_eng_run_dtls
1585: (run_detail_id, run_name, Consolidation_entity_id
1586: , child_entity_id, contra_child_entity_id, entry_id, rule_id,
1587: request_error_code, bp_request_error_code, category_code,
1588: xlate_request_error_code, bp_xlate_request_error_code,

Line 1591: SELECT gcs_cons_eng_run_dtls_s.nextval,

1587: request_error_code, bp_request_error_code, category_code,
1588: xlate_request_error_code, bp_xlate_request_error_code,
1589: creation_date, created_by, last_update_date,
1590: last_updated_by, last_update_login)
1591: SELECT gcs_cons_eng_run_dtls_s.nextval,
1592: g_consolidation_run_name,
1593: DECODE(g_elim_code, 'IE',p_entity_id,'IA', g_cons_entity_id),
1594: gehg.source_entity_id, gehg.target_entity_id,
1595: gehg.entry_id, gehg.rule_id,

Line 1609: AND NOT EXISTS ( SELECT 1 FROM gcs_cons_eng_run_dtls gcr1

1605: SYSDATE, g_fnd_user_id,
1606: g_fnd_login_id
1607: FROM GCS_INTERCO_HDR_GT gehg
1608: WHERE gehg.currency_code = 'STAT'
1609: AND NOT EXISTS ( SELECT 1 FROM gcs_cons_eng_run_dtls gcr1
1610: WHERE gehg.source_entity_id = gcr1.child_entity_id
1611: AND gehg.target_entity_id =
1612: gcr1.contra_child_entity_id
1613: AND gehg.rule_id = gcr1.rule_id);

Line 1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1617:
1618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1619: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1620: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1621: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1622:
1623: FND_LOG.String (fnd_log.level_procedure,
1624: g_pkg_name || '.' || l_api_name,
1625: 'SHRD0117: '||FND_MESSAGE.get);

Line 1696: INSERT INTO gcs_cons_eng_run_dtls

1692: || TO_CHAR (SYSDATE, 'DD-MON-YYYY HH:MI:SS')
1693: );
1694: END IF;
1695:
1696: INSERT INTO gcs_cons_eng_run_dtls
1697: (run_detail_id, run_name, Consolidation_entity_id
1698: , child_entity_id, contra_child_entity_id, entry_id, rule_id,
1699: request_error_code, bp_request_error_code, category_code,
1700: creation_date, created_by, last_update_date,

Line 1702: SELECT gcs_cons_eng_run_dtls_s.nextval,

1698: , child_entity_id, contra_child_entity_id, entry_id, rule_id,
1699: request_error_code, bp_request_error_code, category_code,
1700: creation_date, created_by, last_update_date,
1701: last_updated_by, last_update_login)
1702: SELECT gcs_cons_eng_run_dtls_s.nextval,
1703: g_consolidation_run_name,
1704: DECODE(g_elim_code, 'IE',p_entity_id,'IA', g_cons_entity_id),
1705: NULL, NULL,
1706: NULL, NULL,

Line 1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

1716:
1717: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1718: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1719: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1720: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
1721:
1722: FND_LOG.String (fnd_log.level_procedure,
1723: g_pkg_name || '.' || l_api_name,
1724: 'SHRD0117: '||FND_MESSAGE.get);

Line 2265: -- Process Run details in gcs_cons_eng_run_dtls for the entered headers.

2261: END IF;
2262:
2263:
2264:
2265: -- Process Run details in gcs_cons_eng_run_dtls for the entered headers.
2266:
2267: g_no_rows := 0;
2268:
2269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2273: || ' from gcs_cons_eng_run_dtls'

2269: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2270: fnd_log.STRING (fnd_log.level_procedure,
2271: g_pkg_name || '.' || l_api_name,
2272: 'Intercompany- Deleting run details'
2273: || ' from gcs_cons_eng_run_dtls'
2274: || ' which are not ended up into entry headers table'
2275: );
2276: END IF;
2277:

Line 2278: DELETE FROM gcs_cons_eng_run_dtls

2274: || ' which are not ended up into entry headers table'
2275: );
2276: END IF;
2277:
2278: DELETE FROM gcs_cons_eng_run_dtls
2279: WHERE entry_id IN
2280: (SELECT gihg.entry_id from gcs_interco_hdr_gt gihg
2281: WHERE gihg.currency_code <> 'STAT'
2282: AND NOT EXISTS

Line 2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2288:
2289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2290: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2291: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2292: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2293:
2294:
2295: FND_LOG.String (fnd_log.level_procedure,
2296: g_pkg_name || '.' || l_api_name,

Line 2308: || ' for STAT rows in gcs_cons_eng_run_dtls'

2304: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2305: fnd_log.STRING (fnd_log.level_procedure,
2306: g_pkg_name || '.' || l_api_name,
2307: 'Intercompany- Merge run details'
2308: || ' for STAT rows in gcs_cons_eng_run_dtls'
2309: );
2310: END IF;
2311:
2312:

Line 2313: MERGE INTO gcs_cons_eng_run_dtls gcer

2309: );
2310: END IF;
2311:
2312:
2313: MERGE INTO gcs_cons_eng_run_dtls gcer
2314: USING (SELECT
2315: DECODE(g_elim_code, 'IE',g_entity_id,'IA', g_cons_entity_id)
2316: cons_entity_id,
2317: gehg.rule_id rule_id,

Line 2351: VALUES(gcs_cons_eng_run_dtls_s.nextval,

2347: gcer.stat_entry_id, gcer.rule_id, gcer.request_error_code,
2348: gcer.bp_request_error_code, gcer.category_code,
2349: gcer.creation_date, gcer.created_by, gcer.last_update_date,
2350: gcer.last_updated_by, gcer.last_update_login)
2351: VALUES(gcs_cons_eng_run_dtls_s.nextval,
2352: g_consolidation_run_name,
2353: stat_result.cons_entity_id, stat_result.src_entity_id,
2354: stat_result.target_entity_id, stat_result.entry_id,
2355: stat_result.rule_id, stat_result.req_err_code,

Line 2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2363:
2364: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2365: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2366: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2367: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2368:
2369:
2370: FND_LOG.String (fnd_log.level_procedure,
2371: g_pkg_name || '.' || l_api_name,

Line 2384: || ' for non STAT rows in gcs_cons_eng_run_dtls'

2380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2381: fnd_log.STRING (fnd_log.level_procedure,
2382: g_pkg_name || '.' || l_api_name,
2383: 'Intercompany- Updating run details'
2384: || ' for non STAT rows in gcs_cons_eng_run_dtls'
2385: );
2386: END IF;
2387:
2388:

Line 2390: UPDATE gcs_cons_eng_run_dtls gcer

2386: END IF;
2387:
2388:
2389:
2390: UPDATE gcs_cons_eng_run_dtls gcer
2391: SET (request_error_code,
2392: bp_request_error_code, last_update_date,
2393: last_updated_by) =
2394: (SELECT

Line 2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');

2416:
2417: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2418: FND_MESSAGE.Set_Name('SQLGL','SHRD0118');
2419: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2420: FND_MESSAGE.Set_Token('TABLE','GCS_CONS_ENG_RUN_DTLS');
2421:
2422:
2423: FND_LOG.String (fnd_log.level_procedure,
2424: g_pkg_name || '.' || l_api_name,