DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RES_ENGINE dependencies on FND_API

Line 465: return fnd_api.g_false;

461: i := p_lot_plans.next(i);
462: end loop;
463:
464: if plan_status = 'PENDING' then
465: return fnd_api.g_false;
466: else
467: return fnd_api.g_true;
468: end if;
469:

Line 467: return fnd_api.g_true;

463:
464: if plan_status = 'PENDING' then
465: return fnd_api.g_false;
466: else
467: return fnd_api.g_true;
468: end if;
469:
470: end are_all_plans_completed;
471:

Line 494: return fnd_api.g_true;

490: end loop;
491:
492:
493: if plan_result = 'REJECT' then
494: return fnd_api.g_true;
495: else
496: return fnd_api.g_false;
497: end if;
498:

Line 496: return fnd_api.g_false;

492:
493: if plan_result = 'REJECT' then
494: return fnd_api.g_true;
495: else
496: return fnd_api.g_false;
497: end if;
498:
499: end is_any_plan_rejected;
500:

Line 523: return fnd_api.g_true;

519: --
520: -- maybe in wip, no need to check lot qty
521: --
522: if p_shipment_line_id is null then
523: return fnd_api.g_true;
524: end if;
525:
526: open c (p_txn_qty, p_shipment_line_id);
527: fetch c into conclusion;

Line 531: return fnd_api.g_true;

527: fetch c into conclusion;
528: close c;
529:
530: if conclusion = 'FINISHED' then
531: return fnd_api.g_true;
532: else
533: return fnd_api.g_false;
534: end if;
535: end is_lot_qty_finished;

Line 533: return fnd_api.g_false;

529:
530: if conclusion = 'FINISHED' then
531: return fnd_api.g_true;
532: else
533: return fnd_api.g_false;
534: end if;
535: end is_lot_qty_finished;
536:
537: --

Line 601: if p_reinsp_flag = fnd_api.g_true then

597: --
598: -- if re-inspection changed the result from accept to reject
599: -- or if 1st inspection shows reject, reset the plan states
600: --
601: if p_reinsp_flag = fnd_api.g_true then
602:
603: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
604: qa_skiplot_utility.init_plan_states(
605: p_process_id => pid,

Line 685: p_reinsp_flag := fnd_api.g_true;

681: fetch txn_type into p_txn_type;
682: close txn_type;
683:
684: if p_txn_type in ( 'ACCEPT', 'REJECT') then
685: p_reinsp_flag := fnd_api.g_true;
686: else
687: p_reinsp_flag := fnd_api.g_false;
688:
689: end if;

Line 687: p_reinsp_flag := fnd_api.g_false;

683:
684: if p_txn_type in ( 'ACCEPT', 'REJECT') then
685: p_reinsp_flag := fnd_api.g_true;
686: else
687: p_reinsp_flag := fnd_api.g_false;
688:
689: end if;
690:
691: end check_txn_type;

Line 1056: if p_reinsp_flag = fnd_api.g_true then

1052:
1053: --
1054: -- re-inspection
1055: --
1056: if p_reinsp_flag = fnd_api.g_true then
1057: --
1058: -- when only part of the lot qty is re-inspected
1059: -- we need to get the historical inspection info.
1060: -- this typically happens when transfering txn is done

Line 1146: if p_reinsp_flag = fnd_api.g_true then

1142:
1143: --
1144: -- re-inspection
1145: --
1146: if p_reinsp_flag = fnd_api.g_true then
1147: --
1148: -- Take the latest result, insp_qty, acpt_qty and rej_qty
1149: --
1150: null;

Line 1279: if is_any_plan_rejected(lot_plans) = fnd_api.g_true then

1275:
1276: --
1277: -- if any plan is rejected, reject the lot
1278: --
1279: if is_any_plan_rejected(lot_plans) = fnd_api.g_true then
1280: lot_result := 'REJECT';
1281: lot_status := 'INSPECTED';
1282: --
1283: -- if some plans are incomplete, lot result can not be decided.

Line 1286: elsif are_all_plans_completed (lot_plans) = fnd_api.g_false then

1282: --
1283: -- if some plans are incomplete, lot result can not be decided.
1284: -- this usually will not happen since we catch them at UI part
1285: --
1286: elsif are_all_plans_completed (lot_plans) = fnd_api.g_false then
1287: lot_result := 'INCOMPLETE';
1288: lot_status := 'PENDING';
1289: --
1290: -- only happens in receiving inspection when transafering

Line 1294: = fnd_api.g_false then

1290: -- only happens in receiving inspection when transafering
1291: -- occurs before inspection
1292: --
1293: elsif is_lot_qty_finished (p_total_txn_qty, p_shipment_line_id)
1294: = fnd_api.g_false then
1295: lot_result := 'ACCEPT';
1296: lot_status := 'PENDING';
1297: --
1298: -- if no rejection, all plans finished and lot qty finished,

Line 1337: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,

1333: --
1334: --
1335: update qa_skiplot_rcv_results
1336: set inspection_status = lot_status,
1337: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1338: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1339: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,
1340: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1341: last_insp_date = sysdate,

Line 1339: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,

1335: update qa_skiplot_rcv_results
1336: set inspection_status = lot_status,
1337: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1338: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1339: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,
1340: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1341: last_insp_date = sysdate,
1342: valid_flag = 2,
1343: last_update_date = sysdate,

Line 1351: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,

1347: returning criteria_id, inspection_result into c_id, lot_result;
1348: else
1349: update qa_skiplot_rcv_results
1350: set inspection_status = lot_status,
1351: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1352: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1353: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,
1354: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1355: last_insp_date = sysdate,

Line 1353: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,

1349: update qa_skiplot_rcv_results
1350: set inspection_status = lot_status,
1351: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1352: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1353: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,
1354: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1355: last_insp_date = sysdate,
1356: valid_flag = 2,
1357: last_update_date = sysdate,

Line 1408: if p_reinsp_flag = fnd_api.g_true then

1404:
1405: --
1406: -- re-inspection
1407: --
1408: if p_reinsp_flag = fnd_api.g_true then
1409: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
1410: --
1411: -- reset plan states if re-inspection failed
1412: --

Line 1441: = fnd_api.g_false then

1437: --
1438: -- if round is not finished, update the round parameters
1439: --
1440: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1441: = fnd_api.g_false then
1442:
1443: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1444: = fnd_api.g_false then
1445: forward_lot := 1;

Line 1444: = fnd_api.g_false then

1440: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1441: = fnd_api.g_false then
1442:
1443: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1444: = fnd_api.g_false then
1445: forward_lot := 1;
1446: --
1447: -- if this is over inspection, do not forward the
1448: -- current lot pointer

Line 1469: = fnd_api.g_true OR

1465: -- if date span exceeded then
1466: -- start a new round for this rule
1467: --
1468: elsif qa_skiplot_utility.more_rounds(plan_state)
1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then

Line 1473: p_plan_state => plan_state) = fnd_api.g_false then

1469: = fnd_api.g_true OR
1470: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1471: qa_skiplot_utility.date_reasonable (
1472: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1473: p_plan_state => plan_state) = fnd_api.g_false then
1474:
1475: qa_skiplot_utility.update_plan_state(
1476: p_process_plan_id => plan_state.process_plan_id,
1477: p_criteria_id => plan_state.criteria_id,

Line 1530: return fnd_api.g_true;

1526: fetch skiplot_flag into x_skiplot_flag;
1527: close skiplot_flag;
1528:
1529: if x_skiplot_flag = 'Y' then
1530: return fnd_api.g_true;
1531: elsif x_skiplot_flag = 'N' then
1532: return fnd_api.g_false;
1533: else
1534: return null;

Line 1532: return fnd_api.g_false;

1528:
1529: if x_skiplot_flag = 'Y' then
1530: return fnd_api.g_true;
1531: elsif x_skiplot_flag = 'N' then
1532: return fnd_api.g_false;
1533: else
1534: return null;
1535: end if;
1536: