DBA Data[Home] [Help]

APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on FND_GLOBAL

Line 505: last_updated_by = fnd_global.user_id,

501: usage_rate_or_amount = nvl(cur_row.usage_rate_or_amount,
502: usage_rate_or_amount),
503: last_update_date = sysdate,/*BUG 6721823*/
504: /*FP: 13406111 : BUG 12814417 @Start */
505: last_updated_by = fnd_global.user_id,
506: -- creation_date = cur_row.creation_date,
507: -- created_by = cur_row.created_by,
508: last_update_login = fnd_global.login_id,
509: request_id = fnd_global.conc_request_id,

Line 508: last_update_login = fnd_global.login_id,

504: /*FP: 13406111 : BUG 12814417 @Start */
505: last_updated_by = fnd_global.user_id,
506: -- creation_date = cur_row.creation_date,
507: -- created_by = cur_row.created_by,
508: last_update_login = fnd_global.login_id,
509: request_id = fnd_global.conc_request_id,
510: program_application_id = fnd_global.prog_appl_id,
511: program_id = fnd_global.conc_program_id,
512: program_update_date = sysdate,

Line 509: request_id = fnd_global.conc_request_id,

505: last_updated_by = fnd_global.user_id,
506: -- creation_date = cur_row.creation_date,
507: -- created_by = cur_row.created_by,
508: last_update_login = fnd_global.login_id,
509: request_id = fnd_global.conc_request_id,
510: program_application_id = fnd_global.prog_appl_id,
511: program_id = fnd_global.conc_program_id,
512: program_update_date = sysdate,
513: /*BUG 12814417 @End */

Line 510: program_application_id = fnd_global.prog_appl_id,

506: -- creation_date = cur_row.creation_date,
507: -- created_by = cur_row.created_by,
508: last_update_login = fnd_global.login_id,
509: request_id = fnd_global.conc_request_id,
510: program_application_id = fnd_global.prog_appl_id,
511: program_id = fnd_global.conc_program_id,
512: program_update_date = sysdate,
513: /*BUG 12814417 @End */
514: scheduled_flag = nvl(cur_row.scheduled_flag,

Line 511: program_id = fnd_global.conc_program_id,

507: -- created_by = cur_row.created_by,
508: last_update_login = fnd_global.login_id,
509: request_id = fnd_global.conc_request_id,
510: program_application_id = fnd_global.prog_appl_id,
511: program_id = fnd_global.conc_program_id,
512: program_update_date = sysdate,
513: /*BUG 12814417 @End */
514: scheduled_flag = nvl(cur_row.scheduled_flag,
515: scheduled_flag),

Line 963: last_updated_by = fnd_global.user_id,

959: SET resource_id = cur_row.resource_id_new,
960: usage_rate_or_amount = cur_row.usage_rate_or_amount,
961: last_update_date = sysdate,/*BUG 6721823*/
962: /*FP BUG 13406111 :BUG 12814417 @Start */
963: last_updated_by = fnd_global.user_id,
964: -- creation_date = cur_row.creation_date,
965: -- created_by = cur_row.created_by,
966: last_update_login = fnd_global.login_id,
967: request_id = fnd_global.conc_request_id,

Line 966: last_update_login = fnd_global.login_id,

962: /*FP BUG 13406111 :BUG 12814417 @Start */
963: last_updated_by = fnd_global.user_id,
964: -- creation_date = cur_row.creation_date,
965: -- created_by = cur_row.created_by,
966: last_update_login = fnd_global.login_id,
967: request_id = fnd_global.conc_request_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,

Line 967: request_id = fnd_global.conc_request_id,

963: last_updated_by = fnd_global.user_id,
964: -- creation_date = cur_row.creation_date,
965: -- created_by = cur_row.created_by,
966: last_update_login = fnd_global.login_id,
967: request_id = fnd_global.conc_request_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: /*BUG 12814417 @End */

Line 968: program_application_id = fnd_global.prog_appl_id,

964: -- creation_date = cur_row.creation_date,
965: -- created_by = cur_row.created_by,
966: last_update_login = fnd_global.login_id,
967: request_id = fnd_global.conc_request_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: /*BUG 12814417 @End */
972: scheduled_flag = cur_row.scheduled_flag,

Line 969: program_id = fnd_global.conc_program_id,

965: -- created_by = cur_row.created_by,
966: last_update_login = fnd_global.login_id,
967: request_id = fnd_global.conc_request_id,
968: program_application_id = fnd_global.prog_appl_id,
969: program_id = fnd_global.conc_program_id,
970: program_update_date = sysdate,
971: /*BUG 12814417 @End */
972: scheduled_flag = cur_row.scheduled_flag,
973: assigned_units = cur_row.assigned_units,

Line 1147: last_updated_by = fnd_global.user_id,

1143: UPDATE WIP_OP_RESOURCE_INSTANCES
1144: SET serial_number = nvl(cur_row.resource_serial_number,serial_number),
1145: last_update_date = sysdate,/*BUG 6721823*/
1146: /*FP BUG 13406111 :BUG 12814417 @Start */
1147: last_updated_by = fnd_global.user_id,
1148: -- creation_date = nvl(cur_row.creation_date,creation_date),
1149: -- created_by = nvl(cur_row.created_by,created_by),
1150: /*BUG 12814417 @End */
1151: start_date = nvl(cur_row.start_date,start_date),

Line 1593: last_updated_by = fnd_global.user_id,

1589: /* Bug 5468646 - update component basis */
1590: basis_type = decode(cur_row.basis_type, fnd_api.g_miss_num, null, null, basis_type, cur_row.basis_type),
1591: last_update_date = sysdate,/*BUG 6721823*/
1592: /*FP BUG 13406111 :BUG 12814417 @Start */
1593: last_updated_by = fnd_global.user_id,
1594: -- creation_date = cur_row.creation_date,
1595: -- created_by = cur_row.created_by,
1596: last_update_login = fnd_global.login_id,
1597: request_id = fnd_global.conc_request_id,

Line 1596: last_update_login = fnd_global.login_id,

1592: /*FP BUG 13406111 :BUG 12814417 @Start */
1593: last_updated_by = fnd_global.user_id,
1594: -- creation_date = cur_row.creation_date,
1595: -- created_by = cur_row.created_by,
1596: last_update_login = fnd_global.login_id,
1597: request_id = fnd_global.conc_request_id,
1598: program_application_id = fnd_global.prog_appl_id,
1599: program_id = fnd_global.conc_program_id,
1600:

Line 1597: request_id = fnd_global.conc_request_id,

1593: last_updated_by = fnd_global.user_id,
1594: -- creation_date = cur_row.creation_date,
1595: -- created_by = cur_row.created_by,
1596: last_update_login = fnd_global.login_id,
1597: request_id = fnd_global.conc_request_id,
1598: program_application_id = fnd_global.prog_appl_id,
1599: program_id = fnd_global.conc_program_id,
1600:
1601: program_update_date = sysdate,

Line 1598: program_application_id = fnd_global.prog_appl_id,

1594: -- creation_date = cur_row.creation_date,
1595: -- created_by = cur_row.created_by,
1596: last_update_login = fnd_global.login_id,
1597: request_id = fnd_global.conc_request_id,
1598: program_application_id = fnd_global.prog_appl_id,
1599: program_id = fnd_global.conc_program_id,
1600:
1601: program_update_date = sysdate,
1602: /*BUG 12814417 @End */

Line 1599: program_id = fnd_global.conc_program_id,

1595: -- created_by = cur_row.created_by,
1596: last_update_login = fnd_global.login_id,
1597: request_id = fnd_global.conc_request_id,
1598: program_application_id = fnd_global.prog_appl_id,
1599: program_id = fnd_global.conc_program_id,
1600:
1601: program_update_date = sysdate,
1602: /*BUG 12814417 @End */
1603: department_id = NVL(cur_row.department_id,

Line 2286: last_updated_by = fnd_global.user_id,

2282:
2283: UPDATE WIP_OPERATIONS
2284: SET last_update_date = sysdate,/*BUG 6721823*/
2285: /*FP BUG 13406111 :BUG 12814417 @Start */
2286: last_updated_by = fnd_global.user_id,
2287: -- creation_date = cur_row.creation_date,
2288: -- created_by = cur_row.created_by,
2289: last_update_login = fnd_global.login_id,
2290: request_id = fnd_global.conc_request_id,

Line 2289: last_update_login = fnd_global.login_id,

2285: /*FP BUG 13406111 :BUG 12814417 @Start */
2286: last_updated_by = fnd_global.user_id,
2287: -- creation_date = cur_row.creation_date,
2288: -- created_by = cur_row.created_by,
2289: last_update_login = fnd_global.login_id,
2290: request_id = fnd_global.conc_request_id,
2291: program_application_id = fnd_global.prog_appl_id,
2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,

Line 2290: request_id = fnd_global.conc_request_id,

2286: last_updated_by = fnd_global.user_id,
2287: -- creation_date = cur_row.creation_date,
2288: -- created_by = cur_row.created_by,
2289: last_update_login = fnd_global.login_id,
2290: request_id = fnd_global.conc_request_id,
2291: program_application_id = fnd_global.prog_appl_id,
2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,
2294: /*BUG 12814417 @End */

Line 2291: program_application_id = fnd_global.prog_appl_id,

2287: -- creation_date = cur_row.creation_date,
2288: -- created_by = cur_row.created_by,
2289: last_update_login = fnd_global.login_id,
2290: request_id = fnd_global.conc_request_id,
2291: program_application_id = fnd_global.prog_appl_id,
2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,
2294: /*BUG 12814417 @End */
2295: standard_operation_id = NVL(cur_oper.standard_operation_id,

Line 2292: program_id = fnd_global.conc_program_id,

2288: -- created_by = cur_row.created_by,
2289: last_update_login = fnd_global.login_id,
2290: request_id = fnd_global.conc_request_id,
2291: program_application_id = fnd_global.prog_appl_id,
2292: program_id = fnd_global.conc_program_id,
2293: program_update_date = sysdate,
2294: /*BUG 12814417 @End */
2295: standard_operation_id = NVL(cur_oper.standard_operation_id,
2296: standard_operation_id),

Line 2380: LAST_UPDATED_BY = fnd_global.user_id,

2376: AND OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM)
2377: AND ORGANIZATION_ID = p_organization_id
2378: ),
2379: /*FP BUG 13406111 :BUG 12814417 @Start */
2380: LAST_UPDATED_BY = fnd_global.user_id,
2381: LAST_UPDATE_DATE = SYSDATE,
2382: LAST_UPDATE_LOGIN = fnd_global.login_id,
2383: REQUEST_ID = fnd_global.conc_request_id,
2384: PROGRAM_UPDATE_DATE = SYSDATE,

Line 2382: LAST_UPDATE_LOGIN = fnd_global.login_id,

2378: ),
2379: /*FP BUG 13406111 :BUG 12814417 @Start */
2380: LAST_UPDATED_BY = fnd_global.user_id,
2381: LAST_UPDATE_DATE = SYSDATE,
2382: LAST_UPDATE_LOGIN = fnd_global.login_id,
2383: REQUEST_ID = fnd_global.conc_request_id,
2384: PROGRAM_UPDATE_DATE = SYSDATE,
2385: PROGRAM_ID = fnd_global.conc_program_id,
2386: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id

Line 2383: REQUEST_ID = fnd_global.conc_request_id,

2379: /*FP BUG 13406111 :BUG 12814417 @Start */
2380: LAST_UPDATED_BY = fnd_global.user_id,
2381: LAST_UPDATE_DATE = SYSDATE,
2382: LAST_UPDATE_LOGIN = fnd_global.login_id,
2383: REQUEST_ID = fnd_global.conc_request_id,
2384: PROGRAM_UPDATE_DATE = SYSDATE,
2385: PROGRAM_ID = fnd_global.conc_program_id,
2386: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id
2387: /* BUG 12814417 @End */

Line 2385: PROGRAM_ID = fnd_global.conc_program_id,

2381: LAST_UPDATE_DATE = SYSDATE,
2382: LAST_UPDATE_LOGIN = fnd_global.login_id,
2383: REQUEST_ID = fnd_global.conc_request_id,
2384: PROGRAM_UPDATE_DATE = SYSDATE,
2385: PROGRAM_ID = fnd_global.conc_program_id,
2386: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id
2387: /* BUG 12814417 @End */
2388: WHERE WIP_ENTITY_ID = p_wip_entity_id
2389: AND OPERATION_SEQ_NUM = cur_oper.operation_seq_num

Line 2386: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id

2382: LAST_UPDATE_LOGIN = fnd_global.login_id,
2383: REQUEST_ID = fnd_global.conc_request_id,
2384: PROGRAM_UPDATE_DATE = SYSDATE,
2385: PROGRAM_ID = fnd_global.conc_program_id,
2386: PROGRAM_APPLICATION_ID = fnd_global.prog_appl_id
2387: /* BUG 12814417 @End */
2388: WHERE WIP_ENTITY_ID = p_wip_entity_id
2389: AND OPERATION_SEQ_NUM = cur_oper.operation_seq_num
2390: AND ORGANIZATION_ID = p_organization_id ;