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_HEADERS

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 73: TYPE l_entry_id_tbl_type IS TABLE OF GCS_ENTRY_HEADERS.ENTRY_ID%TYPE INDEX BY BINARY_INTEGER;

69:
70: TYPE l_hierarchy_id_tbl_type IS TABLE OF GCS_HIERARCHIES_B.HIERARCHY_ID%TYPE INDEX BY BINARY_INTEGER;
71: l_hierarchy_id l_hierarchy_id_tbl_type;
72:
73: TYPE l_entry_id_tbl_type IS TABLE OF GCS_ENTRY_HEADERS.ENTRY_ID%TYPE INDEX BY BINARY_INTEGER;
74: l_entry_id l_entry_id_tbl_type;
75:
76: l_api_name VARCHAR2(30) := 'IMPORT_HIER_GRP_ENTRY';
77: l_end_cal_period_id NUMBER;

Line 173: SELECT hierarchy_id, gcs_entry_headers_s.NEXTVAL BULK COLLECT

169: END IF;
170:
171: -- Retreive the hierarchies , present in teh chosen hierarchy group
172: -- Create a new entry ID for each of the hierarchy
173: SELECT hierarchy_id, gcs_entry_headers_s.NEXTVAL BULK COLLECT
174: INTO l_hierarchy_id, l_entry_id
175: FROM gcs_hier_grp_members
176: WHERE hierarchy_grp_id = p_hierarchy_grp_id;
177:

Line 178: -- Insert the header information of the adjustment into gcs_entry_headers, for all of the hierarchies

174: INTO l_hierarchy_id, l_entry_id
175: FROM gcs_hier_grp_members
176: WHERE hierarchy_grp_id = p_hierarchy_grp_id;
177:
178: -- Insert the header information of the adjustment into gcs_entry_headers, for all of the hierarchies
179: FORALL l_counter IN l_hierarchy_id.FIRST .. l_hierarchy_id.LAST
180: INSERT INTO gcs_entry_headers
181: (entry_id,
182: entry_name,

Line 180: INSERT INTO gcs_entry_headers

176: WHERE hierarchy_grp_id = p_hierarchy_grp_id;
177:
178: -- Insert the header information of the adjustment into gcs_entry_headers, for all of the hierarchies
179: FORALL l_counter IN l_hierarchy_id.FIRST .. l_hierarchy_id.LAST
180: INSERT INTO gcs_entry_headers
181: (entry_id,
182: entry_name,
183: hierarchy_id,
184: disabled_flag,

Line 317: 'FROM fnd_currencies fc, gcs_entry_headers geh' || g_nl ||

313: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,
314: entity_id, NVL (minimum_accountable_unit, POWER (10, -PRECISION))' || g_nl ||
315: 'INTO l_entry_type_code, l_year_to_apply_re, l_hierarchy_id,
316: l_balance_code, l_entity_id, l_precision' || g_nl ||
317: 'FROM fnd_currencies fc, gcs_entry_headers geh' || g_nl ||
318: 'WHERE fc.currency_code = geh.currency_code ' || g_nl ||
319: 'AND geh.entry_id = ' || l_entry_id(1));
320: END IF;
321:

Line 328: FROM fnd_currencies fc, gcs_entry_headers geh

324: 'ONE_TIME',
325: 'RECURRING'),
326: NVL(minimum_accountable_unit, POWER(10, -PRECISION))
327: INTO l_entry_type_code, l_precision
328: FROM fnd_currencies fc, gcs_entry_headers geh
329: WHERE fc.currency_code = geh.currency_code
330: AND geh.entry_id = l_entry_id(1);
331:
332: IF (l_entry_type_code = 'RECURRING') THEN

Line 602: FROM gcs_entry_headers geh

598:
599: BEGIN
600: SELECT 'Y'
601: INTO l_existed_entry_flag
602: FROM gcs_entry_headers geh
603: WHERE geh.entry_id = p_entry_id;
604: -- case 1: this is a newly created entry
605: -- we'll just do an insertion
606: EXCEPTION

Line 642: 'UPDATE gcs_entry_headers' || g_nl ||

638: WHEN NO_DATA_FOUND THEN
639: IF fnd_log.g_current_runtime_level <= fnd_log.level_error THEN
640: fnd_log.STRING(fnd_log.level_error,
641: g_pkg_name || '.' || l_api_name,
642: 'UPDATE gcs_entry_headers' || g_nl ||
643: 'SET balance_type_code = ' ||
644: p_balance_type_code || ',' || g_nl ||
645: ' end_cal_period_id = ' || l_end_cal_period_id || ',' || g_nl ||
646: ' entry_type_code = MANUAL,' || g_nl ||

Line 660: UPDATE gcs_entry_headers

656: ' last_update_date = SYSDATE,' || g_nl ||
657: ' last_updated_by = ' || fnd_global.user_id ||
658: ' WHERE entry_id = ' || p_entry_id);
659: END IF;
660: UPDATE gcs_entry_headers
661: SET balance_type_code = p_balance_type_code,
662: end_cal_period_id = l_end_cal_period_id,
663: year_to_apply_re = l_year_to_apply_re,
664: entry_type_code = 'MANUAL',

Line 704: 'UPDATE gcs_entry_headers' || g_nl ||

700: IF l_processed_entry_flag = 'Y' THEN
701: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
702: fnd_log.STRING(fnd_log.level_procedure,
703: g_pkg_name || '.' || l_api_name,
704: 'UPDATE gcs_entry_headers' || g_nl ||
705: 'SET disabled_flag = ''Y'', entry_name = substr(entry_name, 0, 55) || '' OLD -'' || ' ||
706: p_new_entry_id || g_nl || 'WHERE entry_id = ' ||
707: p_entry_id);
708: END IF;

Line 709: UPDATE gcs_entry_headers

705: 'SET disabled_flag = ''Y'', entry_name = substr(entry_name, 0, 55) || '' OLD -'' || ' ||
706: p_new_entry_id || g_nl || 'WHERE entry_id = ' ||
707: p_entry_id);
708: END IF;
709: UPDATE gcs_entry_headers
710: SET disabled_flag = 'Y',
711: entry_name = substr(entry_name, 0, 55) || ' OLD -' ||
712: p_new_entry_id,
713: --Bugfix 6351281: Update the disabled cal period id as well

Line 882: 'INSERT INTO gcs_entry_headers' || g_nl ||

878: END IF;
879: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
880: fnd_log.STRING(fnd_log.level_procedure,
881: g_pkg_name || '.' || l_api_name,
882: 'INSERT INTO gcs_entry_headers' || g_nl ||
883: '(entry_id, entry_name, hierarchy_id, disabled_flag,' || g_nl ||
884: 'entity_id, currency_code, balance_type_code,' || g_nl ||
885: 'start_cal_period_id, end_cal_period_id,' || g_nl ||
886: 'year_to_apply_re, description, entry_type_code,' || g_nl ||

Line 903: INSERT INTO gcs_entry_headers

899: fnd_global.user_id || ', ' || g_nl || 'SYSDATE, ' ||
900: fnd_global.user_id || ', ' || fnd_global.login_id ||
901: ', ''' || p_period_init_entry_flag || ''');');
902: END IF;
903: INSERT INTO gcs_entry_headers
904: (entry_id,
905: entry_name,
906: hierarchy_id,
907: disabled_flag,

Line 997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;

993: gcs_utility_pkg.g_module_enter || ' ' || l_api_name ||
994: '() ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH:MI:SS'));
995: END IF;
996: IF p_entry_id IS NULL THEN
997: SELECT gcs_entry_headers_s.NEXTVAL INTO p_entry_id FROM DUAL;
998: END IF;
999: get_entry_header(p_category_code => p_category_code,
1000: p_xlate_flag => p_xlate_flag,
1001: p_entry_id => p_entry_id,

Line 1182: 'FROM fnd_currencies fc, gcs_entry_headers geh' || g_nl ||

1178: ''RECURRING''), year_to_apply_re, hierarchy_id, balance_type_code,
1179: entity_id, NVL (minimum_accountable_unit, POWER (10, -PRECISION))' || g_nl ||
1180: 'INTO l_entry_type_code, l_year_to_apply_re, l_hierarchy_id,
1181: l_balance_code, l_entity_id, l_precision' || g_nl ||
1182: 'FROM fnd_currencies fc, gcs_entry_headers geh' || g_nl ||
1183: 'WHERE fc.currency_code = geh.currency_code ' || g_nl ||
1184: 'AND geh.entry_id = ' || l_entry_id);
1185: END IF;
1186:

Line 1202: FROM fnd_currencies fc, gcs_entry_headers geh

1198: l_hierarchy_id,
1199: l_balance_code,
1200: l_entity_id,
1201: l_precision
1202: FROM fnd_currencies fc, gcs_entry_headers geh
1203: WHERE fc.currency_code = geh.currency_code
1204: AND geh.entry_id = l_entry_id;
1205:
1206: IF (l_entry_type_code = 'RECURRING') THEN

Line 1462: 'DELETE FROM gcs_entry_headers' || g_nl ||

1458: END IF;
1459: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1460: fnd_log.STRING(fnd_log.level_procedure,
1461: g_pkg_name || '.' || l_api_name,
1462: 'DELETE FROM gcs_entry_headers' || g_nl ||
1463: 'WHERE entry_id = ' || p_entry_id);
1464: END IF;
1465: /*
1466: DELETE FROM gcs_entry_headers

Line 1466: DELETE FROM gcs_entry_headers

1462: 'DELETE FROM gcs_entry_headers' || g_nl ||
1463: 'WHERE entry_id = ' || p_entry_id);
1464: END IF;
1465: /*
1466: DELETE FROM gcs_entry_headers
1467: WHERE entry_id = p_entry_id;
1468: */
1469: IF fnd_log.g_current_runtime_level <= fnd_log.level_procedure THEN
1470: fnd_log.STRING(fnd_log.level_procedure,