DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RES_ENGINE dependencies on FND_API

Line 483: return fnd_api.g_false;

479: i := p_lot_plans.next(i);
480: end loop;
481:
482: if plan_status = 'PENDING' then
483: return fnd_api.g_false;
484: else
485: return fnd_api.g_true;
486: end if;
487:

Line 485: return fnd_api.g_true;

481:
482: if plan_status = 'PENDING' then
483: return fnd_api.g_false;
484: else
485: return fnd_api.g_true;
486: end if;
487:
488: end are_all_plans_completed;
489:

Line 512: return fnd_api.g_true;

508: end loop;
509:
510:
511: if plan_result = 'REJECT' then
512: return fnd_api.g_true;
513: else
514: return fnd_api.g_false;
515: end if;
516:

Line 514: return fnd_api.g_false;

510:
511: if plan_result = 'REJECT' then
512: return fnd_api.g_true;
513: else
514: return fnd_api.g_false;
515: end if;
516:
517: end is_any_plan_rejected;
518:

Line 541: return fnd_api.g_true;

537: --
538: -- maybe in wip, no need to check lot qty
539: --
540: if p_shipment_line_id is null then
541: return fnd_api.g_true;
542: end if;
543:
544: open c (p_txn_qty, p_shipment_line_id);
545: fetch c into conclusion;

Line 549: return fnd_api.g_true;

545: fetch c into conclusion;
546: close c;
547:
548: if conclusion = 'FINISHED' then
549: return fnd_api.g_true;
550: else
551: return fnd_api.g_false;
552: end if;
553: end is_lot_qty_finished;

Line 551: return fnd_api.g_false;

547:
548: if conclusion = 'FINISHED' then
549: return fnd_api.g_true;
550: else
551: return fnd_api.g_false;
552: end if;
553: end is_lot_qty_finished;
554:
555: --

Line 619: if p_reinsp_flag = fnd_api.g_true then

615: --
616: -- if re-inspection changed the result from accept to reject
617: -- or if 1st inspection shows reject, reset the plan states
618: --
619: if p_reinsp_flag = fnd_api.g_true then
620:
621: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
622: qa_skiplot_utility.init_plan_states(
623: p_process_id => pid,

Line 703: p_reinsp_flag := fnd_api.g_true;

699: fetch txn_type into p_txn_type;
700: close txn_type;
701:
702: if p_txn_type in ( 'ACCEPT', 'REJECT') then
703: p_reinsp_flag := fnd_api.g_true;
704: else
705: p_reinsp_flag := fnd_api.g_false;
706:
707: end if;

Line 705: p_reinsp_flag := fnd_api.g_false;

701:
702: if p_txn_type in ( 'ACCEPT', 'REJECT') then
703: p_reinsp_flag := fnd_api.g_true;
704: else
705: p_reinsp_flag := fnd_api.g_false;
706:
707: end if;
708:
709: end check_txn_type;

Line 1136: if p_reinsp_flag = fnd_api.g_true then

1132:
1133: --
1134: -- re-inspection
1135: --
1136: if p_reinsp_flag = fnd_api.g_true then
1137: --
1138: -- when only part of the lot qty is re-inspected
1139: -- we need to get the historical inspection info.
1140: -- this typically happens when transfering txn is done

Line 1226: if p_reinsp_flag = fnd_api.g_true then

1222:
1223: --
1224: -- re-inspection
1225: --
1226: if p_reinsp_flag = fnd_api.g_true then
1227: --
1228: -- Take the latest result, insp_qty, acpt_qty and rej_qty
1229: --
1230: null;

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

1368:
1369: --
1370: -- if any plan is rejected, reject the lot
1371: --
1372: if is_any_plan_rejected(lot_plans) = fnd_api.g_true then
1373: lot_result := 'REJECT';
1374: lot_status := 'INSPECTED';
1375: --
1376: -- if some plans are incomplete, lot result can not be decided.

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

1375: --
1376: -- if some plans are incomplete, lot result can not be decided.
1377: -- this usually will not happen since we catch them at UI part
1378: --
1379: elsif are_all_plans_completed (lot_plans) = fnd_api.g_false then
1380: lot_result := 'INCOMPLETE';
1381: lot_status := 'PENDING';
1382: --
1383: -- only happens in receiving inspection when transafering

Line 1387: = fnd_api.g_false then

1383: -- only happens in receiving inspection when transafering
1384: -- occurs before inspection
1385: --
1386: elsif is_lot_qty_finished (p_total_txn_qty, p_shipment_line_id)
1387: = fnd_api.g_false then
1388: lot_result := 'ACCEPT';
1389: lot_status := 'PENDING';
1390: --
1391: -- if no rejection, all plans finished and lot qty finished,

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

1491: END IF;
1492:
1493: update qa_skiplot_rcv_results
1494: set inspection_status = lot_status,
1495: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1496: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1497: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,
1498: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1499: last_insp_date = sysdate,

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

1493: update qa_skiplot_rcv_results
1494: set inspection_status = lot_status,
1495: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1496: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1497: transacted_qty = decode (p_reinsp_flag, fnd_api.g_true, transacted_qty,
1498: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1499: last_insp_date = sysdate,
1500: valid_flag = 2,
1501: last_update_date = sysdate,

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

1508: /* End of inclusion for bug 8678609. */
1509: else
1510: update qa_skiplot_rcv_results
1511: set inspection_status = lot_status,
1512: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1513: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1514: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,
1515: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1516: last_insp_date = sysdate,

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

1510: update qa_skiplot_rcv_results
1511: set inspection_status = lot_status,
1512: inspection_result = decode(p_reinsp_flag, fnd_api.g_true, lot_result,
1513: decode (inspection_result, 'REJECT', 'REJECT', lot_result)),
1514: transacted_qty = decode(p_reinsp_flag, fnd_api.g_true, transacted_qty,
1515: (nvl(transacted_qty, 0) + nvl(p_total_txn_qty, 0))),
1516: last_insp_date = sysdate,
1517: valid_flag = 2,
1518: last_update_date = sysdate,

Line 1569: if p_reinsp_flag = fnd_api.g_true then

1565:
1566: --
1567: -- re-inspection
1568: --
1569: if p_reinsp_flag = fnd_api.g_true then
1570: if p_prev_txn_type = 'ACCEPT' and p_insp_result = 'REJECT' then
1571: --
1572: -- reset plan states if re-inspection failed
1573: --

Line 1602: = fnd_api.g_false then

1598: --
1599: -- if round is not finished, update the round parameters
1600: --
1601: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1602: = fnd_api.g_false then
1603:
1604: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1605: = fnd_api.g_false then
1606: forward_lot := 1;

Line 1605: = fnd_api.g_false then

1601: elsif qa_skiplot_utility.insp_round_finished(plan_state)
1602: = fnd_api.g_false then
1603:
1604: if qa_skiplot_utility.enough_lot_accepted (plan_state)
1605: = fnd_api.g_false then
1606: forward_lot := 1;
1607: --
1608: -- if this is over inspection, do not forward the
1609: -- current lot pointer

Line 1630: = fnd_api.g_true OR

1626: -- if date span exceeded then
1627: -- start a new round for this rule
1628: --
1629: elsif qa_skiplot_utility.more_rounds(plan_state)
1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then

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

1630: = fnd_api.g_true OR
1631: qa_skiplot_utility.get_next_insp_rule(plan_state) = -1 OR
1632: qa_skiplot_utility.date_reasonable (
1633: p_check_mode => qa_skiplot_utility.DATE_SPAN_CHECK,
1634: p_plan_state => plan_state) = fnd_api.g_false then
1635:
1636: qa_skiplot_utility.update_plan_state(
1637: p_process_plan_id => plan_state.process_plan_id,
1638: p_criteria_id => plan_state.criteria_id,

Line 1691: return fnd_api.g_true;

1687: fetch skiplot_flag into x_skiplot_flag;
1688: close skiplot_flag;
1689:
1690: if x_skiplot_flag = 'Y' then
1691: return fnd_api.g_true;
1692: elsif x_skiplot_flag = 'N' then
1693: return fnd_api.g_false;
1694: else
1695: return null;

Line 1693: return fnd_api.g_false;

1689:
1690: if x_skiplot_flag = 'Y' then
1691: return fnd_api.g_true;
1692: elsif x_skiplot_flag = 'N' then
1693: return fnd_api.g_false;
1694: else
1695: return null;
1696: end if;
1697: