DBA Data[Home] [Help]

APPS.ENGPKIMP dependencies on FND_GLOBAL

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

3626:
3627: FOR i IN 1..20
3628: LOOP
3629: copy_segments(i) := substr(l_concatenated_copy_segments,
3630: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3631: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3632: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3633: END LOOP;
3634:

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

3627: FOR i IN 1..20
3628: LOOP
3629: copy_segments(i) := substr(l_concatenated_copy_segments,
3630: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3631: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3632: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3633: END LOOP;
3634:
3635: END IF;

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

3628: LOOP
3629: copy_segments(i) := substr(l_concatenated_copy_segments,
3630: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i))+1,
3631: ( to_number( instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i+1) ) -
3632: to_number(instr(l_concatenated_copy_segments,fnd_global.local_chr(1),1,i)+1)) );
3633: END LOOP;
3634:
3635: END IF;
3636:

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

3658: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
3659: l_event.param_value_6 := 'DB';
3660:
3661: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
3662: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
3663:
3664: IF (item.transfer_or_copy = 'C')
3665: THEN
3666: l_child_event_name := 'oracle.apps.eng.copyToManufacturing';

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

7718: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
7719: l_event.param_value_6 := 'DB';
7720:
7721: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
7722: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
7723:
7724: IF (l_pending_from_ecn IS NULL)
7725: THEN
7726: l_child_event_name := 'oracle.apps.bom.billUpdate';

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

7853: l_event.param_name_6 := '#WF_SOURCE_APPLICATION_TYPE';
7854: l_event.param_value_6 := 'DB';
7855:
7856: l_event.param_name_7 := '#WF_SIGN_REQUESTER';
7857: l_event.param_value_7 := FND_GLOBAL.USER_NAME;
7858:
7859: IF (l_pending_from_ecn IS NULL)
7860: THEN
7861: l_child_event_name := 'oracle.apps.bom.routingUpdate';

Line 9471: p_request_id => fnd_global.conc_request_id);

9467: p_change_notice => IMPL.change_notice,
9468: p_status_code => 6,
9469: p_curr_status_code => IMPL.curr_status_code,
9470: p_plm_or_erp_change => IMPL.l_plm_or_erp_change,
9471: p_request_id => fnd_global.conc_request_id);
9472:
9473: -- If Header can be implemented, then go ahead.
9474:
9475: IF (l_implement_header = 'T')

Line 9484: LAST_UPDATED_BY = fnd_global.user_id,

9480: SET STATUS_TYPE = 6,
9481: STATUS_CODE=6,
9482: IMPLEMENTATION_DATE = SYSDATE,
9483: LAST_UPDATE_DATE = SYSDATE,
9484: LAST_UPDATED_BY = fnd_global.user_id,
9485: LAST_UPDATE_LOGIN = fnd_global.login_id,
9486: REQUEST_ID = fnd_global.conc_request_id,
9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9488: PROGRAM_ID = fnd_global.conc_program_id,

Line 9485: LAST_UPDATE_LOGIN = fnd_global.login_id,

9481: STATUS_CODE=6,
9482: IMPLEMENTATION_DATE = SYSDATE,
9483: LAST_UPDATE_DATE = SYSDATE,
9484: LAST_UPDATED_BY = fnd_global.user_id,
9485: LAST_UPDATE_LOGIN = fnd_global.login_id,
9486: REQUEST_ID = fnd_global.conc_request_id,
9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9488: PROGRAM_ID = fnd_global.conc_program_id,
9489: PROGRAM_UPDATE_DATE = SYSDATE,

Line 9486: REQUEST_ID = fnd_global.conc_request_id,

9482: IMPLEMENTATION_DATE = SYSDATE,
9483: LAST_UPDATE_DATE = SYSDATE,
9484: LAST_UPDATED_BY = fnd_global.user_id,
9485: LAST_UPDATE_LOGIN = fnd_global.login_id,
9486: REQUEST_ID = fnd_global.conc_request_id,
9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9488: PROGRAM_ID = fnd_global.conc_program_id,
9489: PROGRAM_UPDATE_DATE = SYSDATE,
9490: promote_status_code = null

Line 9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,

9483: LAST_UPDATE_DATE = SYSDATE,
9484: LAST_UPDATED_BY = fnd_global.user_id,
9485: LAST_UPDATE_LOGIN = fnd_global.login_id,
9486: REQUEST_ID = fnd_global.conc_request_id,
9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9488: PROGRAM_ID = fnd_global.conc_program_id,
9489: PROGRAM_UPDATE_DATE = SYSDATE,
9490: promote_status_code = null
9491: WHERE CHANGE_NOTICE = IMPL.change_notice

Line 9488: PROGRAM_ID = fnd_global.conc_program_id,

9484: LAST_UPDATED_BY = fnd_global.user_id,
9485: LAST_UPDATE_LOGIN = fnd_global.login_id,
9486: REQUEST_ID = fnd_global.conc_request_id,
9487: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id,
9488: PROGRAM_ID = fnd_global.conc_program_id,
9489: PROGRAM_UPDATE_DATE = SYSDATE,
9490: promote_status_code = null
9491: WHERE CHANGE_NOTICE = IMPL.change_notice
9492: AND ORGANIZATION_ID = IMPL.organization_id;

Line 9501: last_updated_by = fnd_global.user_id,

9497: eng_lifecycle_statuses
9498: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9499: completion_date = sysdate,
9500: last_update_date = sysdate,
9501: last_updated_by = fnd_global.user_id,
9502: last_update_login = fnd_global.login_id
9503: WHERE entity_name = 'ENG_CHANGE'
9504: AND entity_id1 =
9505: (

Line 9502: last_update_login = fnd_global.login_id

9498: SET start_date = nvl(start_date,sysdate), -- set the start date on implemented phase after promoting the header to implemented phase
9499: completion_date = sysdate,
9500: last_update_date = sysdate,
9501: last_updated_by = fnd_global.user_id,
9502: last_update_login = fnd_global.login_id
9503: WHERE entity_name = 'ENG_CHANGE'
9504: AND entity_id1 =
9505: (
9506: SELECT