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,
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,
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 */
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,
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),
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,
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,
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 */
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,
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,
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),
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,
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:
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,
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 */
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,
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,
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,
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 */
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,
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),
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,
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
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 */
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
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 ;