540: decode(p_lot_id, null, null, sysdate),
541: nvl(p_lot_id,last_receipt_lot),
542: nvl(last_date,sysdate),
543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:
542: nvl(last_date,sysdate),
543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:
549: update_state_history (
550: p_process_plan_id => p_process_plan_id,
543: sysdate,
544: fnd_global.user_id,
545: sysdate,
546: fnd_global.user_id,
547: fnd_global.login_id);
548:
549: update_state_history (
550: p_process_plan_id => p_process_plan_id,
551: p_criteria_id => p_criteria_id,
605: BEGIN
606: UPDATE qa_skiplot_plan_states
607: SET last_receipt_date = SYSDATE,
608: last_update_date = SYSDATE,
609: last_updated_by = fnd_global.user_id,
610: last_update_login = fnd_global.login_id
611: WHERE process_plan_id = p_process_plan_id AND
612: criteria_id = p_criteria_id;
613: END RESET_LAST_RECEIPT_DATE;
606: UPDATE qa_skiplot_plan_states
607: SET last_receipt_date = SYSDATE,
608: last_update_date = SYSDATE,
609: last_updated_by = fnd_global.user_id,
610: last_update_login = fnd_global.login_id
611: WHERE process_plan_id = p_process_plan_id AND
612: criteria_id = p_criteria_id;
613: END RESET_LAST_RECEIPT_DATE;
614:
863: last_receipt_date = decode(p_last_receipt_lot_id, null, last_receipt_date, sysdate),
864: rule_start_lot_id = nvl(p_rule_start_lotid, rule_start_lot_id),
865: rule_start_date = x_rule_start_date,
866: last_update_date = sysdate,
867: last_updated_by = fnd_global.user_id,
868: last_update_login = fnd_global.login_id
869: where process_plan_id = p_process_plan_id and
870: criteria_id = p_criteria_id;
871:
864: rule_start_lot_id = nvl(p_rule_start_lotid, rule_start_lot_id),
865: rule_start_date = x_rule_start_date,
866: last_update_date = sysdate,
867: last_updated_by = fnd_global.user_id,
868: last_update_login = fnd_global.login_id
869: where process_plan_id = p_process_plan_id and
870: criteria_id = p_criteria_id;
871:
872: if p_next_rule is not null then
1225: p_old_freq_denom,
1226: p_new_freq_num,
1227: p_new_freq_denom,
1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:
1227: p_new_freq_denom,
1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:
1234: launch_workflow (
1235: p_process_plan_id => p_process_plan_id,
1228: sysdate,
1229: fnd_global.user_id,
1230: sysdate,
1231: fnd_global.user_id,
1232: fnd_global.login_id);
1233:
1234: launch_workflow (
1235: p_process_plan_id => p_process_plan_id,
1236: p_criteria_id => p_criteria_id,
1297: p_module_name,
1298: p_error_message,
1299: p_comments,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1299: p_comments,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1306: update qa_skiplot_log
1307: set MODULE_NAME = p_module_name,
1300: sysdate,
1301: fnd_global.user_id,
1302: sysdate,
1303: fnd_global.user_id,
1304: fnd_global.login_id);
1305: else
1306: update qa_skiplot_log
1307: set MODULE_NAME = p_module_name,
1308: ERROR_MESSAGE = p_error_message,
1307: set MODULE_NAME = p_module_name,
1308: ERROR_MESSAGE = p_error_message,
1309: COMMENTS = p_comments,
1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;
1309: COMMENTS = p_comments,
1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;
1316: end if;
1317:
1310: LAST_UPDATE_DATE = sysdate,
1311: LAST_UPDATED_BY = fnd_global.user_id,
1312: CREATION_DATE = sysdate,
1313: CREATED_BY = fnd_global.user_id,
1314: LAST_UPDATE_LOGIN = fnd_global.login_id
1315: where LOG_ID = x_logid;
1316: end if;
1317:
1318: COMMIT;