DBA Data[Home] [Help]

APPS.GCS_CONS_ENG_RUN_DTLS_PKG dependencies on FND_GLOBAL

Line 69: FND_GLOBAL.USER_ID,

65: p_pre_prop_entry_id,
66: p_pre_prop_stat_entry_id,
67: p_cons_relationship_id,
68: sysdate,
69: FND_GLOBAL.USER_ID,
70: sysdate,
71: FND_GLOBAL.USER_ID,
72: FND_GLOBAL.LOGIN_ID
73: )

Line 71: FND_GLOBAL.USER_ID,

67: p_cons_relationship_id,
68: sysdate,
69: FND_GLOBAL.USER_ID,
70: sysdate,
71: FND_GLOBAL.USER_ID,
72: FND_GLOBAL.LOGIN_ID
73: )
74: RETURNING run_detail_id INTO p_run_detail_id;
75:

Line 72: FND_GLOBAL.LOGIN_ID

68: sysdate,
69: FND_GLOBAL.USER_ID,
70: sysdate,
71: FND_GLOBAL.USER_ID,
72: FND_GLOBAL.LOGIN_ID
73: )
74: RETURNING run_detail_id INTO p_run_detail_id;
75:
76: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

Line 109: last_updated_by = FND_GLOBAL.user_id

105: pre_prop_stat_entry_id = NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),
106: request_error_code = NVL(p_request_error_code, request_error_code),
107: bp_request_error_code = NVL(p_bp_request_error_code, bp_request_error_code),
108: last_update_date = sysdate,
109: last_updated_by = FND_GLOBAL.user_id
110: WHERE run_detail_id = p_run_detail_id;
111:
112: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
113: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS', '<>');

Line 142: last_updated_by = FND_GLOBAL.USER_ID

138: pre_prop_stat_entry_id = NVL(p_pre_prop_stat_entry_id, pre_prop_stat_entry_id),
139: request_error_code = NVL(p_request_error_code, request_error_code),
140: bp_request_error_code = NVL(p_bp_request_error_code, bp_request_error_code),
141: last_update_date = sysdate,
142: last_updated_by = FND_GLOBAL.USER_ID
143: WHERE run_detail_id = p_run_detail_id;
144:
145: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, g_api || '.UPDATE_ENTRY_HEADERS_ASYNC', '<>');

Line 261: last_updated_by = FND_GLOBAL.LOGIN_ID

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
263: AND category_code = l_category_code
264: AND consolidation_entity_id = p_consolidation_entity_id
265: AND child_entity_id IS NULL;

Line 279: last_updated_by = FND_GLOBAL.LOGIN_ID

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
281: AND category_code = p_category_code
282: AND consolidation_entity_id = p_consolidation_entity_id
283: AND child_entity_id IS NULL;

Line 354: FND_GLOBAL.USER_ID,

350: request_error_code,
351: bp_request_error_code,
352: cons_relationship_id,
353: sysdate,
354: FND_GLOBAL.USER_ID,
355: sysdate,
356: FND_GLOBAL.USER_ID,
357: FND_GLOBAL.LOGIN_ID
358: FROM gcs_cons_eng_run_dtls

Line 356: FND_GLOBAL.USER_ID,

352: cons_relationship_id,
353: sysdate,
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

Line 357: FND_GLOBAL.LOGIN_ID

353: sysdate,
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

Line 412: FND_GLOBAL.USER_ID,

408: pre_prop_entry_id,
409: pre_prop_stat_entry_id,
410: cons_relationship_id,
411: sysdate,
412: FND_GLOBAL.USER_ID,
413: sysdate,
414: FND_GLOBAL.USER_ID,
415: FND_GLOBAL.LOGIN_ID
416: FROM gcs_cons_eng_run_dtls

Line 414: FND_GLOBAL.USER_ID,

410: cons_relationship_id,
411: sysdate,
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

Line 415: FND_GLOBAL.LOGIN_ID

411: sysdate,
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