DBA Data[Home] [Help]

APPS.ENG_PROPAGATION_LOG_UTIL dependencies on FND_PROFILE

Line 20: G_LOG_LEVEL CONSTANT NUMBER := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));

16: G_RET_STS_WARNING CONSTANT VARCHAR2(1) := 'W';
17: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
19:
20: G_LOG_LEVEL CONSTANT NUMBER := TO_NUMBER(FND_PROFILE.Value('AFLOG_LEVEL'));
21: G_LOG_MODE VARCHAR2(3);
22:
23: ---------------------------------------------------------------
24: -- Propagation Log Map Table --

Line 56: ELSIF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0)

52: BEGIN
53: IF G_LOG_LEVEL IS NULL
54: THEN
55: G_LOG_MODE := 'OFF';
56: ELSIF (TO_NUMBER(FND_PROFILE.Value('CONC_REQUEST_ID')) <> 0)
57: THEN
58: G_LOG_MODE := 'SRS';
59: ELSE
60: G_LOG_MODE := 'SQL';

Line 254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')

250: , created_by = FND_GLOBAL.USER_ID
251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;

Line 255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')

251: , last_update_date = SYSDATE
252: , last_updated_by = FND_GLOBAL.USER_ID
253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
259: ELSE

Line 257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')

253: , last_update_login = FND_GLOBAL.LOGIN_ID
254: , program_id = FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
255: , program_application_id = FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
256: , program_update_date = SYSDATE
257: , request_id = FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
258: WHERE change_propagation_map_id = p_entity_map_rec.change_propagation_map_id;
259: ELSE
260: SELECT eng_change_propagation_maps_s.nextval
261: INTO p_entity_map_rec.change_propagation_map_id

Line 301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')

297: , p_entity_map_rec.revised_item_sequence_id
298: , p_entity_map_rec.local_change_id
299: , p_entity_map_rec.local_revised_item_seq_id
300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type

Line 302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')

298: , p_entity_map_rec.local_change_id
299: , p_entity_map_rec.local_revised_item_seq_id
300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type
306: , p_entity_map_rec.revised_line_id1

Line 304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')

300: , p_entity_map_rec.LOCAL_ORGANIZATION_ID
301: , FND_GLOBAL.CONC_PROGRAM_ID--FND_PROFILE.value('CONC_PROGRAM_ID')
302: , FND_GLOBAL.PROG_APPL_ID--FND_PROFILE.value('PROG_APPL_ID')
303: , SYSDATE
304: , FND_GLOBAL.CONC_REQUEST_ID--FND_PROFILE.value('CONC_REQUEST_ID')
305: , p_entity_map_rec.revised_line_type
306: , p_entity_map_rec.revised_line_id1
307: , p_entity_map_rec.revised_line_id2
308: , p_entity_map_rec.revised_line_id3