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.

[Home] [Help]

APPS.GCS_INTERCO_PROCESSING_PKG dependencies on GCS_INTERCO_HDR_GT

Line 53: -- populate GCS_INTERCO_HDR_GT

49: -- 2) Get the consolidation entity information like currency,
50: -- matching rule.
51: -- 3) Get all the subsidiaries for the given consolidation entity.
52: -- 4) Based on the elimination mode
53: -- populate GCS_INTERCO_HDR_GT
54: -- with corresponding information.
55: -- 5) Copy all the Intercompany transactions into the
56: -- GCS_ENTRY_LINES by calling Insr_Interco_Lines routine.
57: -- 6) After successful suspense plug-in insert the header

Line 342: from GCS_INTERCO_HDR_GT;

338:
339: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340:
341: SELECT count(*) into g_no_rows
342: from GCS_INTERCO_HDR_GT;
343: FND_LOG.String (fnd_log.level_procedure,
344: g_pkg_name || '.' || l_api_name,
345: 'Number of rows in GCS_INTERCO_HDR_GT: '||g_no_rows);
346:

Line 345: 'Number of rows in GCS_INTERCO_HDR_GT: '||g_no_rows);

341: SELECT count(*) into g_no_rows
342: from GCS_INTERCO_HDR_GT;
343: FND_LOG.String (fnd_log.level_procedure,
344: g_pkg_name || '.' || l_api_name,
345: 'Number of rows in GCS_INTERCO_HDR_GT: '||g_no_rows);
346:
347: g_no_rows :=0;
348:
349: SELECT count(*) into g_no_rows

Line 709: WHERE ENTRY_ID IN ( SELECT ENTRY_ID FROM GCS_INTERCO_HDR_GT)

705: AND fcch4.parent_id <> fcch4.child_id
706: AND fcch3.parent_id = fcch4.parent_id))
707: AND fcca.attribute_id = :attribute_id
708: AND fcca.version_id = :version_id)
709: WHERE ENTRY_ID IN ( SELECT ENTRY_ID FROM GCS_INTERCO_HDR_GT)
710: AND description = ''SUSPENSE_LINE''';
711:
712: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
713:

Line 1081: -- GCS_INTERCO_HDR_GT.

1077: -- insr_interco_hdrs
1078: -- Purpose
1079: -- This routine is responsible for inserting distinct pairs of entities
1080: -- for each intercompany rule into the global temporary table
1081: -- GCS_INTERCO_HDR_GT.
1082:
1083:
1084: FUNCTION INSR_INTERCO_HDRS (p_hierarchy_id IN NUMBER,
1085: p_cal_period_id IN NUMBER,

Line 1127: || 'into GCS_INTERCO_HDR_GT in full '

1123: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1124: fnd_log.STRING (fnd_log.level_procedure,
1125: g_pkg_name || '.' || l_api_name,
1126: 'Insert distinct pairs of entities for each rule '
1127: || 'into GCS_INTERCO_HDR_GT in full '
1128: || 'consolidation run mode and elim-mode=''IE'''
1129: || '- Intercompany rule on Receivables side'
1130: );
1131: END IF;

Line 1139: INSERT INTO GCS_INTERCO_HDR_GT

1135: -- Added DECODE(fc.currency_code,'STAT',10000,
1136: -- gib.sus_financial_elem_id) "SUS_FINANCIAL_ELEM_ID"
1137: -- to the following statement.
1138:
1139: INSERT INTO GCS_INTERCO_HDR_GT
1140: (entry_id, source_entity_id, target_entity_id, rule_id,
1141: threshold_currency,threshold_amount,sus_financial_elem_id,
1142: sus_product_id,sus_natural_account_id,
1143: sus_channel_id,sus_line_item_id,sus_project_id,sus_customer_id,

Line 1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1244:
1245: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1246: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1247: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1248: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1249:
1250:
1251:
1252: FND_LOG.String (fnd_log.level_procedure,

Line 1261: || 'into GCS_INTERCO_HDR_GT in full '

1257: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1258: fnd_log.STRING (fnd_log.level_procedure,
1259: g_pkg_name || '.' || l_api_name,
1260: 'Insert distinct pairs of entities for each rule '
1261: || 'into GCS_INTERCO_HDR_GT in full '
1262: || 'consolidation run mode and elim-mode=''IE'''
1263: || '- Intercompany rule Payables side'
1264: );
1265: END IF;

Line 1272: INSERT INTO GCS_INTERCO_HDR_GT

1268: -- Added DECODE(fc.currency_code,'STAT',10000,
1269: -- gib.sus_financial_elem_id) "SUS_FINANCIAL_ELEM_ID"
1270: -- to the following statement.
1271:
1272: INSERT INTO GCS_INTERCO_HDR_GT
1273: (entry_id, source_entity_id, target_entity_id, rule_id,
1274: threshold_currency,threshold_amount,sus_financial_elem_id,
1275: sus_product_id,sus_natural_account_id,
1276: sus_channel_id,sus_line_item_id,sus_project_id,sus_customer_id,

Line 1338: FROM GCS_INTERCO_HDR_GT gihg1,

1334: AND gim.rule_id = gib.rule_id
1335: AND gib.enabled_flag = 'Y'
1336: AND NOT EXISTS
1337: (SELECT 'Y'
1338: FROM GCS_INTERCO_HDR_GT gihg1,
1339: GCS_INTERCO_MEMBERS gim1
1340: WHERE gihg1.target_entity_id =
1341: DECODE(gim1.line_item_id,
1342: gim.line_item_id,

Line 1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1379:
1380: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1381: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1382: FND_MESSAGE.Set_Token('NUM',TO_CHAR(NVL(SQL%ROWCOUNT,0)));
1383: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1384:
1385:
1386:
1387: FND_LOG.String (fnd_log.level_procedure,

Line 1401: DELETE FROM GCS_INTERCO_HDR_GT gihg

1397: || ' eliminated, for e.g. at a mid level parent'
1398: );
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'

Line 1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1414:
1415: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1416: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
1417: FND_MESSAGE.Set_Token('NUM',TO_CHAR(l_no_rows));
1418: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1419:
1420:
1421: FND_LOG.String (fnd_log.level_procedure,
1422: g_pkg_name || '.' || l_api_name,

Line 1435: || 'into GCS_INTERCO_HDR_GT in full '

1431: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1432: fnd_log.STRING (fnd_log.level_procedure,
1433: g_pkg_name || '.' || l_api_name,
1434: 'Insert distinct pairs of entities for each rule '
1435: || 'into GCS_INTERCO_HDR_GT in full '
1436: || 'consolidation run mode and elim-mode=''IA'''
1437: );
1438: END IF;
1439:

Line 1440: INSERT INTO GCS_INTERCO_HDR_GT

1436: || 'consolidation run mode and elim-mode=''IA'''
1437: );
1438: END IF;
1439:
1440: INSERT INTO GCS_INTERCO_HDR_GT
1441: (entry_id, source_entity_id, target_entity_id, rule_id,
1442: threshold_currency,threshold_amount,sus_financial_elem_id,
1443: sus_product_id,sus_natural_account_id,
1444: sus_channel_id,sus_line_item_id,sus_project_id,sus_customer_id,

Line 1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');

1504:
1505: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1506: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1507: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1508: FND_MESSAGE.Set_Token('TABLE','GCS_INTERCO_HDR_GT');
1509:
1510:
1511: FND_LOG.String (fnd_log.level_procedure,
1512: g_pkg_name || '.' || l_api_name,

Line 1554: FROM GCS_INTERCO_HDR_GT gehg

1550: DECODE(g_elim_code, 'IE', 'INTERCOMPANY', 'IA', 'INTRACOMPANY'),
1551: SYSDATE, g_fnd_user_id,
1552: SYSDATE, g_fnd_user_id,
1553: g_fnd_login_id
1554: FROM GCS_INTERCO_HDR_GT gehg
1555: WHERE gehg.currency_code <> 'STAT';
1556:
1557:
1558: g_no_rows := NVL(SQL%ROWCOUNT,0);

Line 1607: FROM GCS_INTERCO_HDR_GT gehg

1603: 'NOT_STARTED','N','NOT_APPLICABLE'),NULL),
1604: SYSDATE, g_fnd_user_id,
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 =

Line 1659: ||' into the GCS_INTERCO_HDR_GT' );

1655:
1656: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1657: g_pkg_name || '.' || l_api_name,
1658: 'Error in inserting intercompany headers'
1659: ||' into the GCS_INTERCO_HDR_GT' );
1660:
1661: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
1662: g_pkg_name || '.' || l_api_name,
1663: SUBSTR(SQLERRM, 1, 255));

Line 1779: FROM GCS_INTERCO_HDR_GT gihg, GCS_ENTRY_LINES gel,

1775: CURSOR threshold_conv_rate IS
1776: SELECT gihg.entry_id, gihg.threshold_currency,
1777: nvl(minimum_accountable_unit, power(10, -precision)) mau,
1778: NVL(precision,2) pres
1779: FROM GCS_INTERCO_HDR_GT gihg, GCS_ENTRY_LINES gel,
1780: fnd_currencies fnc
1781: WHERE gihg.entry_id = gel.entry_id
1782: AND gihg.currency_code <> 'STAT'
1783: AND gihg.threshold_currency <> p_currency_code

Line 1843: || ' in GCS_INTERCO_HDR_GT'

1839: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1840: fnd_log.STRING (fnd_log.level_procedure,
1841: g_pkg_name || '.' || l_api_name,
1842: 'Intercompany- Inside Loop'
1843: || ' in GCS_INTERCO_HDR_GT'
1844: );
1845: END IF;
1846:
1847: BEGIN

Line 1920: FROM GCS_INTERCO_HDR_GT gehg,

1916: NVL(entries.pres,2))* entries.mau, 'N', 'Y'),
1917: MAX(SYSDATE), MAX(g_fnd_user_id),
1918: MAX(SYSDATE), MAX(g_fnd_user_id),
1919: MAX(g_fnd_login_id), 'N'
1920: FROM GCS_INTERCO_HDR_GT gehg,
1921: GCS_INTERCO_RULES_TL girt,
1922: GCS_ENTRY_LINES giet
1923: WHERE gehg.entry_id = entries.entry_id
1924: AND gehg.rule_id = girt.rule_id

Line 1989: FROM GCS_INTERCO_HDR_GT gehg,

1985: 'X',
1986: SYSDATE, g_fnd_user_id,
1987: SYSDATE, g_fnd_user_id,
1988: g_fnd_login_id, 'N'
1989: FROM GCS_INTERCO_HDR_GT gehg,
1990: GCS_INTERCO_RULES_TL girt
1991: WHERE gehg.entry_id = entries.entry_id
1992: AND gehg.rule_id = girt.rule_id
1993: AND girt.language = USERENV('LANG');

Line 2063: FROM GCS_INTERCO_HDR_GT gehg,

2059: 'X',
2060: SYSDATE, g_fnd_user_id,
2061: SYSDATE, g_fnd_user_id,
2062: g_fnd_login_id, 'N'
2063: FROM GCS_INTERCO_HDR_GT gehg,
2064: GCS_INTERCO_RULES_TL girt
2065: WHERE gehg.entry_id = entries.entry_id
2066: AND gehg.rule_id = girt.rule_id
2067: AND girt.language = USERENV('LANG');

Line 2138: FROM GCS_INTERCO_HDR_GT gehg,

2134: MAX(gehg.threshold_amount), 'N', 'Y'),
2135: MAX(SYSDATE), MAX(g_fnd_user_id),
2136: MAX(SYSDATE), MAX(g_fnd_user_id),
2137: MAX(g_fnd_login_id), 'N'
2138: FROM GCS_INTERCO_HDR_GT gehg,
2139: GCS_INTERCO_RULES_TL girt,
2140: GCS_ENTRY_LINES giet
2141: WHERE (gehg.currency_code = P_currency_code
2142: AND gehg.threshold_currency = P_currency_code)

Line 2204: FROM GCS_INTERCO_HDR_GT gehg,

2200: 'N',
2201: SYSDATE, g_fnd_user_id,
2202: SYSDATE, g_fnd_user_id,
2203: g_fnd_login_id, 'N'
2204: FROM GCS_INTERCO_HDR_GT gehg,
2205: GCS_ENTRY_LINES gel,
2206: GCS_INTERCO_RULES_TL girt
2207: WHERE gehg.entry_id = gel.entry_id
2208: AND gehg.currency_code = 'STAT'

Line 2243: (SELECT gihg.entry_id from gcs_interco_hdr_gt gihg

2239: END IF;
2240:
2241: DELETE FROM gcs_entry_headers
2242: WHERE entry_id IN
2243: (SELECT gihg.entry_id from gcs_interco_hdr_gt gihg
2244: WHERE NOT EXISTS
2245: (SELECT entry_id from gcs_entry_lines geh
2246: WHERE geh.entry_id = gihg.entry_id));
2247:

Line 2280: (SELECT gihg.entry_id from gcs_interco_hdr_gt gihg

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
2283: (SELECT entry_id from gcs_entry_headers geh
2284: WHERE geh.entry_id = gihg.entry_id));

Line 2327: FROM GCS_INTERCO_HDR_GT gehg,

2323: ' N','NO_ERROR', 'COMPLETED') bp_req_err_code,
2324: gehg.source_entity_id src_entity_id,
2325: gehg.target_entity_id target_entity_id,
2326: gehg.entry_id entry_id
2327: FROM GCS_INTERCO_HDR_GT gehg,
2328: GCS_ENTRY_HEADERS geh
2329: WHERE gehg.entry_id = geh.entry_id
2330: AND gehg.currency_code = 'STAT') stat_result
2331: ON (stat_result.src_entity_id = gcer.child_entity_id

Line 2407: FROM GCS_INTERCO_HDR_GT gehg,

2403: ' N','NO_ERROR', 'COMPLETED'),
2404: gcer.bp_request_error_code),
2405: SYSDATE,
2406: g_fnd_user_id
2407: FROM GCS_INTERCO_HDR_GT gehg,
2408: GCS_ENTRY_HEADERS geh
2409: WHERE gehg.entry_id = geh.entry_id
2410: AND gehg.entry_id = gcer.entry_id)
2411: WHERE gcer.entry_id IN (SELECT entry_id from gcs_interco_hdr_gt

Line 2411: WHERE gcer.entry_id IN (SELECT entry_id from gcs_interco_hdr_gt

2407: FROM GCS_INTERCO_HDR_GT gehg,
2408: GCS_ENTRY_HEADERS geh
2409: WHERE gehg.entry_id = geh.entry_id
2410: AND gehg.entry_id = gcer.entry_id)
2411: WHERE gcer.entry_id IN (SELECT entry_id from gcs_interco_hdr_gt
2412: WHERE currency_code <> 'STAT');
2413:
2414:
2415: g_no_rows := NVL(SQL%ROWCOUNT,0);

Line 2440: AND entry_id IN (SELECT entry_id from gcs_interco_hdr_gt));

2436: SELECT 1 INTO l_warning
2437: FROM DUAL
2438: WHERE EXISTS (SELECT 1 FROM GCS_ENTRY_HEADERS
2439: WHERE suspense_exceeded_flag = 'Y'
2440: AND entry_id IN (SELECT entry_id from gcs_interco_hdr_gt));
2441:
2442: IF (l_warning =1) THEN
2443: g_sus_exceed_no_rate := TRUE;
2444: END IF;