APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_PLAN_STATES

Line 146: update qa_skiplot_plan_states

142: close new_start_lot;
143:
144: if x_next_lotid is not null and x_next_receipt_date is not null then
145:
146: update qa_skiplot_plan_states
147: set rule_start_lot_id = x_next_lotid,
148: rule_start_date = x_next_receipt_date
149: where process_plan_id = p_plan_state.process_plan_id and
150: criteria_id = p_plan_state.criteria_id;

Line 398: qa_skiplot_plan_states qsps

394: from qa_skiplot_association qsa,
395: qa_skiplot_processes qsp,
396: qa_skiplot_process_plans qspp,
397: qa_skiplot_process_plan_rules qsppr,
398: qa_skiplot_plan_states qsps
399: where qsa.criteria_id = :1 and
400: qsp.process_id = qsa.process_id and
401: qspp.process_plan_id = :2 and
402: qsppr.process_plan_id = qspp.process_plan_id and

Line 506: delete qa_skiplot_plan_states where

502: APP_EXCEPTION.RAISE_EXCEPTION;
503:
504: end if;
505:
506: delete qa_skiplot_plan_states where
507: process_plan_id = p_process_plan_id and
508: criteria_id = p_criteria_id
509: returning current_rule, last_receipt_date, last_receipt_lot_id into
510: old_rule, last_date, last_receipt_lot;

Line 516: insert into qa_skiplot_plan_states(

512: --
513: -- in wip p_receipt_date will be null,
514: -- use sysdate
515: --
516: insert into qa_skiplot_plan_states(
517: PROCESS_PLAN_ID,
518: CRITERIA_ID,
519: CURRENT_RULE,
520: CURRENT_ROUND,

Line 590: p_error_message => 'fail to update qa_skiplot_plan_states',

586: EXCEPTION
587: WHEN OTHERS THEN
588: insert_error_log (
589: p_module_name => 'QA_SKIPLOT_UTILITY.INIT_PLAN_STATES',
590: p_error_message => 'fail to update qa_skiplot_plan_states',
591: p_comments => SUBSTR (SQLERRM , 1 , 240));
592: END INIT_PLAN_STATES;
593:
594: --

Line 606: UPDATE qa_skiplot_plan_states

602: p_criteria_id IN NUMBER,
603: p_process_plan_id IN NUMBER) IS
604:
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

Line 643: p_error_message => 'fail to update qa_skiplot_plan_states',

639: EXCEPTION
640: WHEN OTHERS THEN
641: insert_error_log (
642: p_module_name => 'QA_SKIPLOT_UTILITY.RESET_PLAN_STATES',
643: p_error_message => 'fail to update qa_skiplot_plan_states',
644: p_comments => SUBSTR (SQLERRM , 1 , 240));
645: END RESET_PLAN_STATES;
646:
647: FUNCTION INSP_ROUND_FINISHED(

Line 857: update qa_skiplot_plan_states

853: else
854: x_rule_start_date := old_plan_state.rule_start_date;
855: end if;
856:
857: update qa_skiplot_plan_states
858: set current_rule = nvl(p_next_rule, current_rule),
859: current_round = nvl(p_next_round, current_round),
860: current_lot = nvl(p_next_lot, current_lot),
861: lot_accepted = nvl(p_lot_accepted, lot_accepted),