[Home] [Help]
58: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
59: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS.begin', '<
60: END IF;
61:
62: UPDATE gcs_entry_headers
63: SET processed_run_name = p_run_name,
64: disabled_flag = 'Y',
65: last_update_date = sysdate,
66: last_updated_by = FND_GLOBAL.USER_ID,
725: gcr.child_entity_id,
726: DECODE(geh.suspense_exceeded_flag, 'Y',
727: 'WARNING',
728: 'COMPLETED') request_status
729: FROM gcs_entry_headers geh,
730: gcs_ad_transactions gad,
731: gcs_cons_relationships gcr
732: WHERE geh.entry_id = gad.assoc_entry_id
733: AND gcr.cons_relationship_id = NVL(gad.post_cons_relationship_id, gad.pre_cons_relationship_id)
756: SELECT geh.entry_id,
757: geh.currency_code,
758: geh.process_code,
759: geh.period_init_entry_flag
760: FROM gcs_entry_headers geh
761: WHERE 'MANUAL' = DECODE(geh.period_init_entry_flag, 'Y', 'MANUAL', geh.entry_type_code)
762: -- Bugfix 3718501 : Modified the Join Condition to Extract Automatically Generated A&D Entries
763: -- AND geh.entry_type_code = 'MANUAL' -- Bugfix 3704972 : Extract Only Manual Adjustments
764: -- Bugfix 3827087 : Modifed the Join Condition to Extract Period Initialization Entries as well
1007: WHERE run_detail_id = l_parameter_list.run_detail_id;
1008: END IF;
1009:
1010: SELECT gcerd.run_detail_id,
1011: gcs_entry_headers_s.nextval
1012: INTO l_parameter_list.run_detail_id,
1013: l_parameter_list.xlate_entry_id
1014: FROM gcs_cons_eng_run_dtls gcerd
1015: WHERE gcerd.run_name = cons_entity_wf_info.run_identifier
1241: SELECT gcerd.child_entity_id,
1242: gcerd.rule_id,
1243: geh.entry_id
1244: FROM gcs_cons_eng_run_dtls gcerd,
1245: gcs_entry_headers geh,
1246: gcs_cons_eng_runs gcer
1247: WHERE geh.hierarchy_id = p_hierarchy_id
1248: AND geh.entity_id = p_target_entity_id
1249: AND geh.category_code = p_category_code