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_ENTRY_PKG dependencies on GCS_ENTRY_LINES

Line 32: -- Inserts rows into gcs_entry_headers and gcs_entry_lines,

28: -- Enhancement : 6416736, Created a new procedure
29: -- Procedure
30: -- import_hier_grp_entry()
31: -- Purpose
32: -- Inserts rows into gcs_entry_headers and gcs_entry_lines,
33: -- for all the hierarchies in the chosen hierarchy group
34: -- Arguments
35: -- p_entry_id Entry ID
36: -- p_end_cal_period_id End Calendar Period ID

Line 227: -- Insert the lines information of the adjustment into gcs_entry_lines,

223: l_user_id,
224: l_user_id,
225: 'N');
226:
227: -- Insert the lines information of the adjustment into gcs_entry_lines,
228: -- for all of the hierarchies
229:
230: FORALL l_counter IN l_entry_id.FIRST .. l_entry_id.LAST EXECUTE
231: IMMEDIATE

Line 232: 'INSERT INTO gcs_entry_lines(

228: -- for all of the hierarchies
229:
230: FORALL l_counter IN l_entry_id.FIRST .. l_entry_id.LAST EXECUTE
231: IMMEDIATE
232: 'INSERT INTO gcs_entry_lines(
233: entry_id ,
234: line_type_code,
235: description ,
236: company_cost_center_org_id,

Line 303: FROM gcs_entry_lines

299: last_update_date,
300: last_updated_by ,
301: last_update_login,
302: entry_line_number
303: FROM gcs_entry_lines
304: WHERE entry_id = :2 '
305: USING l_entry_id(l_counter),
306: p_entry_id
307: ;

Line 334: UPDATE gcs_entry_lines

330: AND geh.entry_id = l_entry_id(1);
331:
332: IF (l_entry_type_code = 'RECURRING') THEN
333: FORALL l_counter IN l_entry_id.FIRST .. l_entry_id.LAST
334: UPDATE gcs_entry_lines
335: SET ytd_debit_balance_e = ROUND(ytd_debit_balance_e /
336: l_precision) * l_precision,
337: ytd_credit_balance_e = ROUND(ytd_credit_balance_e /
338: l_precision) * l_precision,

Line 346: WHERE gcs_entry_lines.line_item_id =

342: l_precision) * l_precision,
343: line_type_code = CASE WHEN (SELECT feata.dim_attribute_varchar_member
344: FROM fem_ext_acct_types_attr feata,
345: fem_ln_items_attr flia
346: WHERE gcs_entry_lines.line_item_id =
347: flia.line_item_id
348: AND flia.value_set_id =
349: g_gcs_dimension_info('LINE_ITEM_ID')
350: .associated_value_set_id

Line 379: UPDATE gcs_entry_lines

375: END LOOP;
376: END IF;
377: ELSE
378: FORALL l_counter IN l_entry_id.FIRST .. l_entry_id.LAST
379: UPDATE gcs_entry_lines
380: SET ytd_debit_balance_e = ROUND(ytd_debit_balance_e /
381: l_precision) * l_precision,
382: ytd_credit_balance_e = ROUND(ytd_credit_balance_e /
383: l_precision) * l_precision,

Line 433: -- Delete the rows in the gcs_entry_lines table (lines information) as the same data

429: END IF;
430:
431: END LOOP;
432:
433: -- Delete the rows in the gcs_entry_lines table (lines information) as the same data
434: -- is pushed for all of the hierarchies (present in the chosen hierarchy group).
435:
436: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
437:

Line 436: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;

432:
433: -- Delete the rows in the gcs_entry_lines table (lines information) as the same data
434: -- is pushed for all of the hierarchies (present in the chosen hierarchy group).
435:
436: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
437:
438: -- Write the appropriate information to the execution report
439: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
440: fnd_log.STRING(fnd_log.level_procedure,

Line 550: || 'FROM gcs_entry_lines'

546: 'SELECT DECODE (COUNT (entry_id), 0, ''ACTUAL'', ''ADB'')'
547: || g_nl
548: || 'INTO l_balance_type_code'
549: || g_nl
550: || 'FROM gcs_entry_lines'
551: || g_nl
552: || 'WHERE entry_id = '||p_new_entry_id
553: || g_nl
554: || 'AND FINANCIAL_ELEM_ID = 140'

Line 559: FROM gcs_entry_lines

555: );
556: END IF;
557: SELECT DECODE (COUNT (entry_id), 0, 'ACTUAL', 'ADB')
558: INTO l_balance_type_code
559: FROM gcs_entry_lines
560: WHERE entry_id = p_new_entry_id AND financial_elem_id = 140;
561: ***/
562:
563: --Bugfix 5449718: Added check for net to re flag before populated l_year_to_apply_re

Line 680: 'DELETE FROM gcs_entry_lines' || g_nl ||

676: -- delete old entry lines and flag new lines as loaded
677: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
678: fnd_log.STRING(fnd_log.level_procedure,
679: g_pkg_name || '.' || l_api_name,
680: 'DELETE FROM gcs_entry_lines' || g_nl ||
681: 'WHERE entry_id = ' || p_entry_id);
682: END IF;
683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN

Line 683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;

679: g_pkg_name || '.' || l_api_name,
680: 'DELETE FROM gcs_entry_lines' || g_nl ||
681: 'WHERE entry_id = ' || p_entry_id);
682: END IF;
683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
685: fnd_log.STRING(fnd_log.level_procedure,
686: g_pkg_name || '.' || l_api_name,
687: 'UPDATE gcs_entry_lines' || g_nl ||

Line 687: 'UPDATE gcs_entry_lines' || g_nl ||

683: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
684: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
685: fnd_log.STRING(fnd_log.level_procedure,
686: g_pkg_name || '.' || l_api_name,
687: 'UPDATE gcs_entry_lines' || g_nl ||
688: 'set entry_id = ' || p_entry_id || g_nl ||
689: 'WHERE entry_id = ' || p_new_entry_id);
690: END IF;
691: UPDATE gcs_entry_lines

Line 691: UPDATE gcs_entry_lines

687: 'UPDATE gcs_entry_lines' || g_nl ||
688: 'set entry_id = ' || p_entry_id || g_nl ||
689: 'WHERE entry_id = ' || p_new_entry_id);
690: END IF;
691: UPDATE gcs_entry_lines
692: SET entry_id = p_entry_id
693: WHERE entry_id = p_new_entry_id;
694: p_entry_lines_id := p_entry_id;
695: p_orig_entry_id := p_entry_id;

Line 1211: 'UPDATE gcs_entry_lines' || g_nl ||

1207: -- update the line_type_code for recurring entry lines
1208: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1209: fnd_log.STRING(fnd_log.level_procedure,
1210: g_pkg_name || '.' || l_api_name,
1211: 'UPDATE gcs_entry_lines' || g_nl ||
1212: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision)
1213: * l_precision, ' || g_nl ||
1214: 'ytd_credit_balance_e = ROUND (ytd_credit_balance_e / l_precision)
1215: * l_precision, ' || g_nl ||

Line 1223: WHERE gcs_entry_lines.line_item_id = flia.line_item_id

1219: CASE
1220: WHEN (SELECT feata.dim_attribute_varchar_member
1221: FROM fem_ext_acct_types_attr feata,
1222: fem_ln_items_attr flia
1223: WHERE gcs_entry_lines.line_item_id = flia.line_item_id
1224: AND flia.attribute_id = ' ||
1225: g_dimension_attr_info('LINE_ITEM_ID-EXTENDED_ACCOUNT_TYPE')
1226: .attribute_id || '
1227: AND feata.attribute_id = ' ||

Line 1249: UPDATE gcs_entry_lines

1245: END ' ||
1246: 'WHERE entry_id = ' || l_entry_id);
1247: END IF;
1248:
1249: UPDATE gcs_entry_lines
1250: SET ytd_debit_balance_e = ROUND(ytd_debit_balance_e /
1251: l_precision) * l_precision,
1252: ytd_credit_balance_e = ROUND(ytd_credit_balance_e /
1253: l_precision) * l_precision,

Line 1261: WHERE gcs_entry_lines.line_item_id =

1257: l_precision) * l_precision,
1258: line_type_code = CASE WHEN (SELECT feata.dim_attribute_varchar_member
1259: FROM fem_ext_acct_types_attr feata,
1260: fem_ln_items_attr flia
1261: WHERE gcs_entry_lines.line_item_id =
1262: flia.line_item_id
1263: AND flia.value_set_id =
1264: g_gcs_dimension_info('LINE_ITEM_ID')
1265: .associated_value_set_id

Line 1293: 'UPDATE gcs_entry_lines' || g_nl ||

1289: ELSE
1290: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1291: fnd_log.STRING(fnd_log.level_procedure,
1292: g_pkg_name || '.' || l_api_name,
1293: 'UPDATE gcs_entry_lines' || g_nl ||
1294: 'SET ytd_debit_balance_e = ROUND (ytd_debit_balance_e / l_precision) * l_precision, ' || g_nl ||
1295: 'ytd_credit_balance_e = ROUND (ytd_credit_balance_e / l_precision) * l_precision, ' || g_nl ||
1296: 'ytd_balance_e = ROUND (nvl(ytd_debit_balance_e, 0) / l_precision) * l_precision ' || g_nl ||
1297: '- ROUND (nvl(ytd_credit_balance_e, 0) / l_precision) * l_precision, ' || g_nl ||

Line 1300: UPDATE gcs_entry_lines

1296: 'ytd_balance_e = ROUND (nvl(ytd_debit_balance_e, 0) / l_precision) * l_precision ' || g_nl ||
1297: '- ROUND (nvl(ytd_credit_balance_e, 0) / l_precision) * l_precision, ' || g_nl ||
1298: 'WHERE entry_id = ' || l_entry_id);
1299: END IF;
1300: UPDATE gcs_entry_lines
1301: SET ytd_debit_balance_e = ROUND(ytd_debit_balance_e /
1302: l_precision) * l_precision,
1303: ytd_credit_balance_e = ROUND(ytd_credit_balance_e /
1304: l_precision) * l_precision,

Line 1472: 'DELETE FROM gcs_entry_lines' || g_nl ||

1468: */
1469: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1470: fnd_log.STRING(fnd_log.level_procedure,
1471: g_pkg_name || '.' || l_api_name,
1472: 'DELETE FROM gcs_entry_lines' || g_nl ||
1473: 'WHERE entry_id = ' || p_entry_id);
1474: END IF;
1475: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
1476: x_retcode := fnd_api.g_ret_sts_success;

Line 1475: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;

1471: g_pkg_name || '.' || l_api_name,
1472: 'DELETE FROM gcs_entry_lines' || g_nl ||
1473: 'WHERE entry_id = ' || p_entry_id);
1474: END IF;
1475: DELETE FROM gcs_entry_lines WHERE entry_id = p_entry_id;
1476: x_retcode := fnd_api.g_ret_sts_success;
1477: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1478: fnd_log.STRING(fnd_log.level_procedure,
1479: g_pkg_name || '.' || l_api_name,