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

Line 1: PACKAGE BODY GCS_CONS_ENG_RUN_DTLS_PKG AS

1: PACKAGE BODY GCS_CONS_ENG_RUN_DTLS_PKG AS
2: /* $Header: gcs_eng_run_dtlb.pls 120.2 2005/12/07 02:23:58 skamdar noship $ */
3:
4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_RUN_DTLS_PKG';
5:

Line 4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_RUN_DTLS_PKG';

1: PACKAGE BODY GCS_CONS_ENG_RUN_DTLS_PKG AS
2: /* $Header: gcs_eng_run_dtlb.pls 120.2 2005/12/07 02:23:58 skamdar noship $ */
3:
4: g_api VARCHAR2(80) := 'gcs.plsql.GCS_CONS_ENG_RUN_DTLS_PKG';
5:
6: PROCEDURE insert_row ( p_run_detail_id OUT NOCOPY NUMBER,
7: p_run_name IN VARCHAR2,
8: p_consolidation_entity_id IN NUMBER,

Line 30: INSERT INTO gcs_cons_eng_run_dtls

26: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.INSERT_ROW', '<>');
27: END IF;
28:
29:
30: INSERT INTO gcs_cons_eng_run_dtls
31: (
32: RUN_DETAIL_ID,
33: RUN_NAME,
34: CONSOLIDATION_ENTITY_ID,

Line 54: gcs_cons_eng_run_dtls_s.nextval,

50: LAST_UPDATE_LOGIN
51: )
52: VALUES
53: (
54: gcs_cons_eng_run_dtls_s.nextval,
55: p_run_name,
56: p_consolidation_entity_id,
57: p_category_code,
58: p_child_entity_id,

Line 101: UPDATE gcs_cons_eng_run_dtls

97: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
98: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS', '<>');
99: END IF;
100:
101: UPDATE gcs_cons_eng_run_dtls
102: SET entry_id = NVL(p_entry_id, entry_id),
103: stat_entry_id = NVL(p_stat_entry_id, stat_entry_id),
104: pre_prop_entry_id = NVL(p_pre_prop_entry_id, pre_prop_entry_id),
105: pre_prop_stat_entry_id = NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),

Line 134: UPDATE gcs_cons_eng_run_dtls

130: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
131: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS_ASYNC', '<>');
132: END IF;
133:
134: UPDATE gcs_cons_eng_run_dtls
135: SET entry_id = NVL(p_entry_id, entry_id),
136: stat_entry_id = NVL(p_stat_entry_id, stat_entry_id),
137: pre_prop_entry_id = NVL(p_pre_prop_entry_id, pre_prop_entry_id),
138: pre_prop_stat_entry_id = NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),

Line 176: FROM gcs_cons_eng_run_dtls

172: END IF;
173:
174: SELECT count(request_error_code)
175: INTO l_row_count
176: FROM gcs_cons_eng_run_dtls
177: WHERE run_name = p_run_name
178: AND consolidation_entity_id = p_consolidation_entity_id
179: AND child_entity_id IS NOT NULL
180: AND category_code = p_category_code;

Line 191: FROM gcs_cons_eng_run_dtls

187: l_status_code := 'NOT_APPLICABLE';
188: ELSE
189: SELECT count(request_error_code)
190: INTO l_warning_row_count
191: FROM gcs_cons_eng_run_dtls
192: WHERE run_name = p_run_name
193: AND consolidation_entity_id = p_consolidation_entity_id
194: AND child_entity_id IS NOT NULL
195: AND category_code = p_category_code

Line 258: UPDATE gcs_cons_eng_run_dtls

254: l_status_code := retrieve_status_code ( p_consolidation_entity_id => p_consolidation_entity_id,
255: p_category_code => l_category_code,
256: p_run_name => p_run_name);
257:
258: UPDATE gcs_cons_eng_run_dtls
259: SET request_error_code = l_status_code,
260: last_update_date = sysdate,
261: last_updated_by = FND_GLOBAL.LOGIN_ID
262: WHERE run_name = p_run_name

Line 276: UPDATE gcs_cons_eng_run_dtls

272: ELSE
273: l_status_code := p_status;
274: END IF;
275:
276: UPDATE gcs_cons_eng_run_dtls
277: SET request_error_code = l_status_code,
278: last_update_date = sysdate,
279: last_updated_by = FND_GLOBAL.LOGIN_ID
280: WHERE run_name = p_run_name

Line 321: INSERT INTO gcs_cons_eng_run_dtls

317:
318: BEGIN
319:
320: IF (p_itemtype = 'GCSOPRWF') THEN
321: INSERT INTO gcs_cons_eng_run_dtls
322: (
323: run_detail_id,
324: run_name,
325: consolidation_entity_id,

Line 341: SELECT gcs_cons_eng_run_dtls_s.nextval,

337: creation_date,
338: created_by,
339: last_update_login
340: )
341: SELECT gcs_cons_eng_run_dtls_s.nextval,
342: p_current_run_name,
343: consolidation_entity_id,
344: category_code,
345: child_entity_id,

Line 358: FROM gcs_cons_eng_run_dtls

354: FND_GLOBAL.USER_ID,
355: sysdate,
356: FND_GLOBAL.USER_ID,
357: FND_GLOBAL.LOGIN_ID
358: FROM gcs_cons_eng_run_dtls
359: WHERE run_name = p_prior_run_name
360: AND child_entity_id = p_entity_id
361: AND category_code IN (select category_code
362: from gcs_categories_b

Line 367: DELETE FROM gcs_cons_eng_run_dtls

363: where target_entity_code = 'CHILD'
364: and category_type_code <> 'PROCESS');
365: ELSE
366:
367: DELETE FROM gcs_cons_eng_run_dtls
368: WHERE run_name = p_current_run_name
369: AND consolidation_entity_id = p_entity_id
370: AND category_code IN (select category_code
371: from gcs_categories_b

Line 375: INSERT INTO gcs_cons_eng_run_dtls

371: from gcs_categories_b
372: where target_entity_code IN ('ELIMINATION', 'PARENT'))
373: AND child_entity_id IS NULL;
374:
375: INSERT INTO gcs_cons_eng_run_dtls
376: (
377: run_detail_id,
378: run_name,
379: consolidation_entity_id,

Line 397: SELECT gcs_cons_eng_run_dtls_s.nextval,

393: creation_date,
394: created_by,
395: last_update_login
396: )
397: SELECT gcs_cons_eng_run_dtls_s.nextval,
398: p_current_run_name,
399: consolidation_entity_id,
400: category_code,
401: child_entity_id,

Line 416: FROM gcs_cons_eng_run_dtls

412: FND_GLOBAL.USER_ID,
413: sysdate,
414: FND_GLOBAL.USER_ID,
415: FND_GLOBAL.LOGIN_ID
416: FROM gcs_cons_eng_run_dtls
417: WHERE run_name = p_prior_run_name
418: AND consolidation_entity_id = p_entity_id
419: AND category_code IN (select category_code
420: from gcs_categories_b

Line 427: END GCS_CONS_ENG_RUN_DTLS_PKG;

423:
424: COMMIT;
425:
426: END;
427: END GCS_CONS_ENG_RUN_DTLS_PKG;