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_ENTRY_HEADERS

Line 58: -- entries into the GCS_ENTRY_HEADERS table by calling

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
58: -- entries into the GCS_ENTRY_HEADERS table by calling
59: -- the Insert Elimination Header procedure.
60: -- 7) All the above processing has to be completed in one
61: -- commit cycle. So here we may COMMIT.
62:

Line 544: -- Insert elimination headers into GCS_ENTRY_HEADERS.

540: || ' routine to insert suspense elimination'
541: || ' lines.');
542: END IF;
543:
544: -- Insert elimination headers into GCS_ENTRY_HEADERS.
545:
546: IF( (INSR_ELIMINATION_HDRS(p_hierarchy_id => l_hierarchy_id,
547: p_cal_period_id => l_cal_period_id,
548: p_entity_id => l_entity_id,

Line 1150: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_id,

1146: sus_user_dim7_id, sus_user_dim8_id, sus_user_dim9_id,
1147: sus_user_dim10_id, creation_date, created_by,
1148: last_update_date, last_updated_by, last_update_login,
1149: currency_code)
1150: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_id,
1151: git.tar_id, git.rule_id,
1152: git.threshold_currency,
1153: git.threshold_amount, git.sus_financial_elem_id,
1154: git.sus_product_id,git.sus_natural_account_id,

Line 1283: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_id,

1279: sus_user_dim7_id, sus_user_dim8_id, sus_user_dim9_id,
1280: sus_user_dim10_id, creation_date, created_by,
1281: last_update_date, last_updated_by, last_update_login,
1282: currency_code)
1283: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_id,
1284: git.tar_id, git.rule_id,
1285: git.threshold_currency,
1286: git.threshold_amount, git.sus_financial_elem_id,
1287: git.sus_product_id,git.sus_natural_account_id,

Line 1451: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_entity_id,

1447: sus_user_dim7_id, sus_user_dim8_id, sus_user_dim9_id,
1448: sus_user_dim10_id, creation_date, created_by,
1449: last_update_date, last_updated_by, last_update_login,
1450: currency_code)
1451: SELECT GCS_ENTRY_HEADERS_S.NEXTVAL, git.src_entity_id,
1452: git.target_entity_id, git.rule_id,
1453: git.threshold_currency,
1454: git.threshold_amount, git.sus_financial_elem_id,
1455: git.sus_product_id,git.sus_natural_account_id,

Line 1742: -- Inserts elimination entry headers into GCS_ENTRY_HEADERS.

1738: --
1739: -- Function
1740: -- insr_elimination_hdrs
1741: -- Purpose
1742: -- Inserts elimination entry headers into GCS_ENTRY_HEADERS.
1743: --
1744:
1745: -- Process steps are as follows:
1746: -- If the threshold currency of a intercompany rule is diffrent from

Line 1750: -- Then insert elimination entries headers into GCS_ENTRY_HEADERS.

1746: -- If the threshold currency of a intercompany rule is diffrent from
1747: -- consolidation entity currency, then get the conversion rate for the
1748: -- target currency.
1749:
1750: -- Then insert elimination entries headers into GCS_ENTRY_HEADERS.
1751:
1752: -- Then raise a warning if suspense exceeded for a pair of entities.
1753:
1754:

Line 1871: -- insert 'X' into suspense exceeded flag of gcs_entry_headers

1867:
1868: -- Suspense exceeded flag population.
1869: -- If the absolute net suspense exceeds threshold amount, then
1870: -- insert 'Y' otherwise 'N'. If there is no conversion rate, then
1871: -- insert 'X' into suspense exceeded flag of gcs_entry_headers
1872: -- For stat currency this flag is always 'N'
1873:
1874: -- Now Insert elimination entry headers into GCS_ENTRY_HEADERS.
1875:

Line 1874: -- Now Insert elimination entry headers into GCS_ENTRY_HEADERS.

1870: -- insert 'Y' otherwise 'N'. If there is no conversion rate, then
1871: -- insert 'X' into suspense exceeded flag of gcs_entry_headers
1872: -- For stat currency this flag is always 'N'
1873:
1874: -- Now Insert elimination entry headers into GCS_ENTRY_HEADERS.
1875:
1876: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1877: fnd_log.STRING (fnd_log.level_procedure,
1878: g_pkg_name || '.' || l_api_name,

Line 1881: ||' headers into GCS_ENTRY_HEADERS '

1877: fnd_log.STRING (fnd_log.level_procedure,
1878: g_pkg_name || '.' || l_api_name,
1879: 'Intercompany- Inserting consolidation currency '
1880: ||' entity entry '
1881: ||' headers into GCS_ENTRY_HEADERS '
1882: ||'- where legitimate conversion rate is available.'
1883: );
1884: END IF;
1885:

Line 1888: INSERT INTO gcs_entry_headers

1884: END IF;
1885:
1886: g_no_rows := 0;
1887:
1888: INSERT INTO gcs_entry_headers
1889: (entry_id, entry_name, hierarchy_id, disabled_flag,
1890: entity_id, currency_code, balance_type_code,
1891: start_cal_period_id, end_cal_period_id,
1892: description, entry_type_code,

Line 1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

1932:
1933: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1934: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
1935: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
1936: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
1937:
1938:
1939: FND_LOG.String (fnd_log.level_procedure,
1940: g_pkg_name || '.' || l_api_name,

Line 1949: -- Insert elimination entry headers into GCS_ENTRY_HEADERS.

1945: ELSIF (x_corp_rate = 1) THEN
1946: -- If the conversion rate is not available then there is no need to
1947: -- convert the threshold amount.
1948:
1949: -- Insert elimination entry headers into GCS_ENTRY_HEADERS.
1950:
1951: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1952: fnd_log.STRING (fnd_log.level_procedure,
1953: g_pkg_name || '.' || l_api_name,

Line 1956: ||' headers into GCS_ENTRY_HEADERS '

1952: fnd_log.STRING (fnd_log.level_procedure,
1953: g_pkg_name || '.' || l_api_name,
1954: 'Intercompany- Inserting consolidation currency '
1955: ||' entity entry '
1956: ||' headers into GCS_ENTRY_HEADERS '
1957: ||'- where conversion rate is 1, that means valid '
1958: ||' conversion rate is not available.'
1959: );
1960: END IF;

Line 1964: INSERT INTO gcs_entry_headers

1960: END IF;
1961:
1962: g_no_rows := 0;
1963:
1964: INSERT INTO gcs_entry_headers
1965: (entry_id, entry_name, hierarchy_id, disabled_flag,
1966: entity_id, currency_code, balance_type_code,
1967: start_cal_period_id, end_cal_period_id,
1968: description, entry_type_code,

Line 2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

1997:
1998: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2000: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2001: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2002:
2003:
2004: FND_LOG.String (fnd_log.level_procedure,
2005: g_pkg_name || '.' || l_api_name,

Line 2038: INSERT INTO gcs_entry_headers

2034: -- convert the threshold amount.
2035:
2036: g_no_rows := 0;
2037:
2038: INSERT INTO gcs_entry_headers
2039: (entry_id, entry_name, hierarchy_id, disabled_flag,
2040: entity_id, currency_code, balance_type_code,
2041: start_cal_period_id, end_cal_period_id,
2042: description, entry_type_code,

Line 2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2072:
2073: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2074: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2075: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2076: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2077:
2078:
2079: FND_LOG.String (fnd_log.level_procedure,
2080: g_pkg_name || '.' || l_api_name,

Line 2094: -- Insert elimination entry headers into GCS_ENTRY_HEADERS for same

2090: --END Loop;
2091:
2092:
2093:
2094: -- Insert elimination entry headers into GCS_ENTRY_HEADERS for same
2095: -- currency.
2096:
2097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2098: fnd_log.STRING (fnd_log.level_procedure,

Line 2101: || ' entry headers into GCS_ENTRY_HEADERS'

2097: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2098: fnd_log.STRING (fnd_log.level_procedure,
2099: g_pkg_name || '.' || l_api_name,
2100: 'Intercompany- Inserting same currency '
2101: || ' entry headers into GCS_ENTRY_HEADERS'
2102: );
2103: END IF;
2104:
2105: -- Suspense exceeded flag population.

Line 2110: INSERT INTO gcs_entry_headers

2106: -- Now insert the same currency entries.
2107:
2108: -- Fixed bug#3691665
2109:
2110: INSERT INTO gcs_entry_headers
2111: (entry_id, entry_name, hierarchy_id, disabled_flag,
2112: entity_id, currency_code, balance_type_code,
2113: start_cal_period_id, end_cal_period_id,
2114: description, entry_type_code,

Line 2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2151:
2152: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2153: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2154: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2155: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2156:
2157:
2158: FND_LOG.String (fnd_log.level_procedure,
2159: g_pkg_name || '.' || l_api_name,

Line 2165: -- Insert elimination entry headers into GCS_ENTRY_HEADERS.

2161: --FND_FILE.Put_Line(FND_FILE.Log,'SHRD0117: '||FND_MESSAGE.get);
2162: END IF;
2163:
2164:
2165: -- Insert elimination entry headers into GCS_ENTRY_HEADERS.
2166:
2167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2168: fnd_log.STRING (fnd_log.level_procedure,
2169: g_pkg_name || '.' || l_api_name,

Line 2171: || ' headers into GCS_ENTRY_HEADERS'

2167: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2168: fnd_log.STRING (fnd_log.level_procedure,
2169: g_pkg_name || '.' || l_api_name,
2170: 'Intercompany- Inserting stat currency entry '
2171: || ' headers into GCS_ENTRY_HEADERS'
2172: );
2173: END IF;
2174:
2175: -- Suspense exceeded flag population.

Line 2179: INSERT INTO gcs_entry_headers

2175: -- Suspense exceeded flag population.
2176: -- Now insert the stat currency entries.
2177: -- For stat currency this flag is always 'N'
2178:
2179: INSERT INTO gcs_entry_headers
2180: (entry_id, entry_name, hierarchy_id, disabled_flag,
2181: entity_id, currency_code, balance_type_code,
2182: start_cal_period_id, end_cal_period_id,
2183: description, entry_type_code,

Line 2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2214:
2215: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2216: FND_MESSAGE.Set_Name('SQLGL','SHRD0117');
2217: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2218: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2219:
2220:
2221: FND_LOG.String (fnd_log.level_procedure,
2222: g_pkg_name || '.' || l_api_name,

Line 2235: || ' from gcs_entry_headers'

2231: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2232: fnd_log.STRING (fnd_log.level_procedure,
2233: g_pkg_name || '.' || l_api_name,
2234: 'Intercompany- Deleting entry headers '
2235: || ' from gcs_entry_headers'
2236: || ' where there are no entry lines '
2237:
2238: );
2239: END IF;

Line 2241: DELETE FROM gcs_entry_headers

2237:
2238: );
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

Line 2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');

2250:
2251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2252: FND_MESSAGE.Set_Name('SQLGL','SHRD0119');
2253: FND_MESSAGE.Set_Token('NUM',TO_CHAR(g_no_rows));
2254: FND_MESSAGE.Set_Token('TABLE','GCS_ENTRY_HEADERS');
2255:
2256:
2257: FND_LOG.String (fnd_log.level_procedure,
2258: g_pkg_name || '.' || l_api_name,

Line 2283: (SELECT entry_id from gcs_entry_headers geh

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));
2285:
2286:
2287: g_no_rows := NVL(SQL%ROWCOUNT,0);

Line 2328: GCS_ENTRY_HEADERS geh

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
2332: AND stat_result.target_entity_id =

Line 2408: GCS_ENTRY_HEADERS geh

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
2412: WHERE currency_code <> 'STAT');

Line 2438: WHERE EXISTS (SELECT 1 FROM GCS_ENTRY_HEADERS

2434: BEGIN
2435:
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