DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on FND_GLOBAL

Line 3386: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,

3382:
3383: FOR i IN 1..20
3384: LOOP
3385: copy_segments(i) := substr(l_concatenated_copy_segments,
3386: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3387: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3388: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3389: END LOOP;
3390:

Line 3387: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -

3383: FOR i IN 1..20
3384: LOOP
3385: copy_segments(i) := substr(l_concatenated_copy_segments,
3386: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3387: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3388: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3389: END LOOP;
3390:
3391: END IF;

Line 3388: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );

3384: LOOP
3385: copy_segments(i) := substr(l_concatenated_copy_segments,
3386: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3387: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3388: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3389: END LOOP;
3390:
3391: END IF;
3392:

Line 3418: l_event.param_value_7 := FND_GLOBAL.USER_NAME;

3414: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
3415: l_event.param_value_6 := 'DB';
3416:
3417: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
3418: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
3419:
3420: IF (item.transfer_or_copy = 'C')
3421: THEN
3422: l_child_event_name := 'oracle.apps.eng.copyToManufacturing';

Line 7399: l_event.param_value_7 := FND_GLOBAL.USER_NAME;

7395: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
7396: l_event.param_value_6 := 'DB';
7397:
7398: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
7399: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
7400:
7401: IF (l_pending_from_ecn IS NULL)
7402: THEN
7403: l_child_event_name := 'oracle.apps.bom.billUpdate';

Line 7534: l_event.param_value_7 := FND_GLOBAL.USER_NAME;

7530: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
7531: l_event.param_value_6 := 'DB';
7532:
7533: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
7534: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
7535:
7536: IF (l_pending_from_ecn IS NULL)
7537: THEN
7538: l_child_event_name := 'oracle.apps.bom.routingUpdate';

Line 9126: p_request_id => fnd_global.conc_request_id);

9122: p_change_notice => IMPL.change_notice,
9123: p_status_code => 6,
9124: p_curr_status_code => IMPL.curr_status_code,
9125: p_plm_or_erp_change => IMPL.l_plm_or_erp_change,
9126: p_request_id => fnd_global.conc_request_id);
9127:
9128: -- If Header can be implemented, then go ahead.
9129:
9130: IF (l_implement_header = 'T')

Line 9139: LAST_UPDATED_BY = fnd_global.user_id,

9135: SET STATUS_TYPE = 6,
9136: STATUS_CODE=6,
9137: IMPLEMENTATION_DATE = SYSDATE,
9138: LAST_UPDATE_DATE = SYSDATE,
9139: LAST_UPDATED_BY = fnd_global.user_id,
9140: LAST_UPDATE_LOGIN = fnd_global.login_id,
9141: REQUEST_ID = fnd_global.conc_request_id,
9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9143: PROGRAM_ID = fnd_global.conc_program_id,

Line 9140: LAST_UPDATE_LOGIN = fnd_global.login_id,

9136: STATUS_CODE=6,
9137: IMPLEMENTATION_DATE = SYSDATE,
9138: LAST_UPDATE_DATE = SYSDATE,
9139: LAST_UPDATED_BY = fnd_global.user_id,
9140: LAST_UPDATE_LOGIN = fnd_global.login_id,
9141: REQUEST_ID = fnd_global.conc_request_id,
9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9143: PROGRAM_ID = fnd_global.conc_program_id,
9144: PROGRAM_UPDATE_DATE = SYSDATE,

Line 9141: REQUEST_ID = fnd_global.conc_request_id,

9137: IMPLEMENTATION_DATE = SYSDATE,
9138: LAST_UPDATE_DATE = SYSDATE,
9139: LAST_UPDATED_BY = fnd_global.user_id,
9140: LAST_UPDATE_LOGIN = fnd_global.login_id,
9141: REQUEST_ID = fnd_global.conc_request_id,
9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9143: PROGRAM_ID = fnd_global.conc_program_id,
9144: PROGRAM_UPDATE_DATE = SYSDATE,
9145: promote_status_code = null

Line 9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,

9138: LAST_UPDATE_DATE = SYSDATE,
9139: LAST_UPDATED_BY = fnd_global.user_id,
9140: LAST_UPDATE_LOGIN = fnd_global.login_id,
9141: REQUEST_ID = fnd_global.conc_request_id,
9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9143: PROGRAM_ID = fnd_global.conc_program_id,
9144: PROGRAM_UPDATE_DATE = SYSDATE,
9145: promote_status_code = null
9146: WHERE CHANGE_NOTICE = IMPL.change_notice

Line 9143: PROGRAM_ID = fnd_global.conc_program_id,

9139: LAST_UPDATED_BY = fnd_global.user_id,
9140: LAST_UPDATE_LOGIN = fnd_global.login_id,
9141: REQUEST_ID = fnd_global.conc_request_id,
9142: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9143: PROGRAM_ID = fnd_global.conc_program_id,
9144: PROGRAM_UPDATE_DATE = SYSDATE,
9145: promote_status_code = null
9146: WHERE CHANGE_NOTICE = IMPL.change_notice
9147: AND ORGANIZATION_ID = IMPL.organization_id;

Line 9156: last_updated_by = fnd_global.user_id,

9152: eng_lifecycle_statuses
9153: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9154: completion_date = sysdate,
9155: last_update_date = sysdate,
9156: last_updated_by = fnd_global.user_id,
9157: last_update_login = fnd_global.login_id
9158: WHERE entity_name = 'ENG_CHANGE'
9159: AND entity_id1 =
9160: (

Line 9157: last_update_login = fnd_global.login_id

9153: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9154: completion_date = sysdate,
9155: last_update_date = sysdate,
9156: last_updated_by = fnd_global.user_id,
9157: last_update_login = fnd_global.login_id
9158: WHERE entity_name = 'ENG_CHANGE'
9159: AND entity_id1 =
9160: (
9161: SELECT