DBA Data[Home] [Help]

APPS.QA_SKIPLOT_UTILITY dependencies on FND_API

Line 84: return fnd_api.g_true;

80: if day_range is null then
81: --
82: -- no adjacent date restriction
83: --
84: return fnd_api.g_true;
85: end if;
86:
87: prev_date := p_plan_state.last_receipt_date;
88: if trunc(nvl(p_receipt_date, sysdate)) - trunc(prev_date)

Line 90: return fnd_api.g_true;

86:
87: prev_date := p_plan_state.last_receipt_date;
88: if trunc(nvl(p_receipt_date, sysdate)) - trunc(prev_date)
89: <= day_range then
90: return fnd_api.g_true;
91: else
92: return fnd_api.g_false;
93: end if;
94: end check_adjacent_date;

Line 92: return fnd_api.g_false;

88: if trunc(nvl(p_receipt_date, sysdate)) - trunc(prev_date)
89: <= day_range then
90: return fnd_api.g_true;
91: else
92: return fnd_api.g_false;
93: end if;
94: end check_adjacent_date;
95:
96: --

Line 129: return fnd_api.g_true;

125: trunc(p_plan_state.last_receipt_date) - trunc(p_plan_state.rule_start_date)
126: <= p_plan_state.day_span then
127:
128:
129: return fnd_api.g_true;
130:
131: --
132: -- if day span restriction is violated, update
133: -- rule_start_lot_id and rule_start_date with

Line 160: return fnd_api.g_false;

156: p_module_name =>'QA_SKIPLOT_UTILITY.check_date_span',
157: p_error_message => 'Next lotid or next receipt date is null');
158: end if;
159:
160: return fnd_api.g_false;
161:
162: end if;
163:
164: end check_date_span;

Line 174: -- l_qa_installation VARCHAR2(1) := fnd_api.g_false;

170: p_organization_id IN NUMBER) RETURN VARCHAR2 IS
171:
172: -- Check in as Bug 2917141
173: -- Performance standard.
174: -- l_qa_installation VARCHAR2(1) := fnd_api.g_false;
175: -- l_skiplot_control VARCHAR2(1) := fnd_api.g_false;
176: -- l_skiplot_setup VARCHAR2(1) := fnd_api.g_false;
177: -- l_qa_inspection VARCHAR2(1) := fnd_api.g_false;
178:

Line 175: -- l_skiplot_control VARCHAR2(1) := fnd_api.g_false;

171:
172: -- Check in as Bug 2917141
173: -- Performance standard.
174: -- l_qa_installation VARCHAR2(1) := fnd_api.g_false;
175: -- l_skiplot_control VARCHAR2(1) := fnd_api.g_false;
176: -- l_skiplot_setup VARCHAR2(1) := fnd_api.g_false;
177: -- l_qa_inspection VARCHAR2(1) := fnd_api.g_false;
178:
179: l_qa_installation VARCHAR2(1);

Line 176: -- l_skiplot_setup VARCHAR2(1) := fnd_api.g_false;

172: -- Check in as Bug 2917141
173: -- Performance standard.
174: -- l_qa_installation VARCHAR2(1) := fnd_api.g_false;
175: -- l_skiplot_control VARCHAR2(1) := fnd_api.g_false;
176: -- l_skiplot_setup VARCHAR2(1) := fnd_api.g_false;
177: -- l_qa_inspection VARCHAR2(1) := fnd_api.g_false;
178:
179: l_qa_installation VARCHAR2(1);
180: l_skiplot_control VARCHAR2(1);

Line 177: -- l_qa_inspection VARCHAR2(1) := fnd_api.g_false;

173: -- Performance standard.
174: -- l_qa_installation VARCHAR2(1) := fnd_api.g_false;
175: -- l_skiplot_control VARCHAR2(1) := fnd_api.g_false;
176: -- l_skiplot_setup VARCHAR2(1) := fnd_api.g_false;
177: -- l_qa_inspection VARCHAR2(1) := fnd_api.g_false;
178:
179: l_qa_installation VARCHAR2(1);
180: l_skiplot_control VARCHAR2(1);
181: l_skiplot_setup VARCHAR2(1);

Line 192: if skiplot_avail <> fnd_api.g_miss_char then

188: for different users getting the same database connection in mobile, also when
189: the user changes the skipping flag in the middle of his work.
190: Temporarily commenting it at the cost of a little bit of performance.
191:
192: if skiplot_avail <> fnd_api.g_miss_char then
193: return skiplot_avail;
194: end if;
195: */
196:

Line 205: if l_qa_installation = fnd_api.g_true and

201: l_skiplot_setup := skiplot_setup(p_txn, p_organization_id);
202:
203: l_qa_inspection := QA_INSPECTION_PKG.qa_inspection;
204:
205: if l_qa_installation = fnd_api.g_true and
206: l_skiplot_control = fnd_api.g_true and
207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;

Line 206: l_skiplot_control = fnd_api.g_true and

202:
203: l_qa_inspection := QA_INSPECTION_PKG.qa_inspection;
204:
205: if l_qa_installation = fnd_api.g_true and
206: l_skiplot_control = fnd_api.g_true and
207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;
210: else

Line 207: l_skiplot_setup = fnd_api.g_true and

203: l_qa_inspection := QA_INSPECTION_PKG.qa_inspection;
204:
205: if l_qa_installation = fnd_api.g_true and
206: l_skiplot_control = fnd_api.g_true and
207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;
210: else
211: skiplot_avail := fnd_api.g_false;

Line 208: l_qa_inspection = fnd_api.g_true then

204:
205: if l_qa_installation = fnd_api.g_true and
206: l_skiplot_control = fnd_api.g_true and
207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;
210: else
211: skiplot_avail := fnd_api.g_false;
212: end if;

Line 209: skiplot_avail := fnd_api.g_true;

205: if l_qa_installation = fnd_api.g_true and
206: l_skiplot_control = fnd_api.g_true and
207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;
210: else
211: skiplot_avail := fnd_api.g_false;
212: end if;
213:

Line 211: skiplot_avail := fnd_api.g_false;

207: l_skiplot_setup = fnd_api.g_true and
208: l_qa_inspection = fnd_api.g_true then
209: skiplot_avail := fnd_api.g_true;
210: else
211: skiplot_avail := fnd_api.g_false;
212: end if;
213:
214: return skiplot_avail;
215:

Line 225: return fnd_api.g_false;

221: p_module_name =>'QA_SKIPLOT_UTILITY.CHECK_SKIPLOT_AVAILABILITY',
222: p_error_message => 'QA_SKIPLOT_CHECK_AVALIABLITY_ERR',
223: p_comments => SUBSTR (SQLERRM , 1 , 240));
224:
225: return fnd_api.g_false;
226:
227: END CHECK_SKIPLOT_AVAILABILITY;
228:
229: FUNCTION SKIPLOT_CONTROL

Line 238: sk_flag VARCHAR2(1) := fnd_api.g_false;

234: select qa_skipping_insp_flag
235: from mtl_parameters
236: where organization_id = x_org_id;
237:
238: sk_flag VARCHAR2(1) := fnd_api.g_false;
239:
240: BEGIN
241: --
242: -- open cursor when INV is ready

Line 250: return fnd_api.g_true;

246: fetch sk_ctrl into sk_flag;
247: close sk_ctrl;
248:
249: if sk_flag = 'Y' or sk_flag = 'T' then
250: return fnd_api.g_true;
251: else
252: return fnd_api.g_false;
253: end if;
254:

Line 252: return fnd_api.g_false;

248:
249: if sk_flag = 'Y' or sk_flag = 'T' then
250: return fnd_api.g_true;
251: else
252: return fnd_api.g_false;
253: end if;
254:
255: END SKIPLOT_CONTROL;
256:

Line 280: return fnd_api.g_true;

276: open rcv_criteria (p_organization_id);
277: fetch rcv_criteria into criteria_count;
278: close rcv_criteria;
279: if criteria_count > 0 then
280: return fnd_api.g_true;
281: else
282: return fnd_api.g_false;
283: end if;
284: else

Line 282: return fnd_api.g_false;

278: close rcv_criteria;
279: if criteria_count > 0 then
280: return fnd_api.g_true;
281: else
282: return fnd_api.g_false;
283: end if;
284: else
285: return fnd_api.g_false;
286: end if;

Line 285: return fnd_api.g_false;

281: else
282: return fnd_api.g_false;
283: end if;
284: else
285: return fnd_api.g_false;
286: end if;
287:
288: END SKIPLOT_SETUP;
289:

Line 669: return fnd_api.g_true;

665: -- jezheng
666: -- Thu Nov 29 16:56:22 PST 2001
667: --
668: if current_rule = 0 and (total_round = 0 or total_round is null) then
669: return fnd_api.g_true;
670: end if;
671:
672: if current_lot is not null and total_lots is not null and
673: current_lot - total_lots >= 0 then

Line 674: return fnd_api.g_true;

670: end if;
671:
672: if current_lot is not null and total_lots is not null and
673: current_lot - total_lots >= 0 then
674: return fnd_api.g_true;
675: end if;
676:
677: return fnd_api.g_false;
678:

Line 677: return fnd_api.g_false;

673: current_lot - total_lots >= 0 then
674: return fnd_api.g_true;
675: end if;
676:
677: return fnd_api.g_false;
678:
679: END INSP_ROUND_FINISHED;
680:
681:

Line 701: return fnd_api.g_true;

697: -- jezheng
698: -- Thu Nov 29 16:56:05 PST 2001
699: --
700: if current_rule = 0 and (total_round = 0 or total_round is null) then
701: return fnd_api.g_true;
702: end if;
703:
704: if c_round is not null and
705: total_round is not null and

Line 707: insp_round_finished(p_plan_state) = fnd_api.g_true then

703:
704: if c_round is not null and
705: total_round is not null and
706: c_round >= total_round and
707: insp_round_finished(p_plan_state) = fnd_api.g_true then
708:
709: return fnd_api.g_true;
710: end if;
711:

Line 709: return fnd_api.g_true;

705: total_round is not null and
706: c_round >= total_round and
707: insp_round_finished(p_plan_state) = fnd_api.g_true then
708:
709: return fnd_api.g_true;
710: end if;
711:
712: return fnd_api.g_false;
713:

Line 712: return fnd_api.g_false;

708:
709: return fnd_api.g_true;
710: end if;
711:
712: return fnd_api.g_false;
713:
714: END INSP_RULE_FINISHED;
715:
716:

Line 748: return fnd_api.g_true;

744:
745: BEGIN
746:
747: If (get_next_insp_rule(p_plan_state) = -1) and (p_plan_state.total_round is null) then
748: return fnd_api.g_true;
749: elsif p_plan_state.total_round - p_plan_state.current_round >0 then
750: return fnd_api.g_true;
751: else
752: return fnd_api.g_false;

Line 750: return fnd_api.g_true;

746:
747: If (get_next_insp_rule(p_plan_state) = -1) and (p_plan_state.total_round is null) then
748: return fnd_api.g_true;
749: elsif p_plan_state.total_round - p_plan_state.current_round >0 then
750: return fnd_api.g_true;
751: else
752: return fnd_api.g_false;
753: end if;
754:

Line 752: return fnd_api.g_false;

748: return fnd_api.g_true;
749: elsif p_plan_state.total_round - p_plan_state.current_round >0 then
750: return fnd_api.g_true;
751: else
752: return fnd_api.g_false;
753: end if;
754:
755: END MORE_ROUNDS;
756:

Line 769: return fnd_api.g_true;

765: required_num := p_plan_state.current_freq_num;
766:
767: if accepted_num is not null and required_num is not null and
768: accepted_num - required_num >= 0 then
769: return fnd_api.g_true;
770: end if;
771:
772:
773: return fnd_api.g_false;

Line 773: return fnd_api.g_false;

769: return fnd_api.g_true;
770: end if;
771:
772:
773: return fnd_api.g_false;
774: END ENOUGH_LOT_ACCEPTED;
775:
776:
777:

Line 799: return fnd_api.g_true;

795: return check_date_span (p_plan_state);
796: else
797: -- unknow mode
798: -- treat as no restriction.
799: return fnd_api.g_true;
800: end if;
801: END DATE_REASONABLE;
802:
803: PROCEDURE UPDATE_INSP_STAGE (

Line 1374: return fnd_api.g_true;

1370: p_stage => 'SKIPPING',
1371: p_criteria_id => p_plan_state.criteria_id,
1372: p_process_id => p_plan_state.process_id);
1373:
1374: return fnd_api.g_true;
1375: else
1376: return fnd_api.g_false;
1377: end if;
1378: END INSPECT_ZERO;

Line 1376: return fnd_api.g_false;

1372: p_process_id => p_plan_state.process_id);
1373:
1374: return fnd_api.g_true;
1375: else
1376: return fnd_api.g_false;
1377: end if;
1378: END INSPECT_ZERO;
1379:
1380: FUNCTION GET_PROCESS_ID (