APPS.QA_ERES_DEFER dependencies on EDR_PSIG_PAGE_FLOW

Line 165: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

161: l_sql_string VARCHAR2(1000);
162:
163: BEGIN
164:
165: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
166: l_status_code := 20;
167:
168: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
169: l_status_code := 30;

Line 168: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

164:
165: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
166: l_status_code := 20;
167:
168: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
169: l_status_code := 30;
170:
171: END IF;
172:

Line 199: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

195: l_status_code VARCHAR2(30);
196:
197: BEGIN
198:
199: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
200: l_status_code := g_approved;
201:
202: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
203: l_status_code := g_rejected;

Line 202: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

198:
199: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
200: l_status_code := g_approved;
201:
202: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
203: l_status_code := g_rejected;
204:
205: END IF;
206:

Line 227: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

223: l_status_code VARCHAR2(30);
224:
225: BEGIN
226:
227: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
228: l_status_code := g_approved;
229:
230: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
231: l_status_code := g_rejected;

Line 230: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

226:
227: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
228: l_status_code := g_approved;
229:
230: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
231: l_status_code := g_rejected;
232:
233: END IF;
234:

Line 256: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

252: l_status_code VARCHAR2(30);
253:
254: BEGIN
255:
256: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
257: l_status_code := g_approved;
258:
259: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
260: l_status_code := g_rejected;

Line 259: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

255:
256: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
257: l_status_code := g_approved;
258:
259: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
260: l_status_code := g_rejected;
261:
262: END IF;
263:

Line 284: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

280: l_status_code VARCHAR2(30);
281:
282: BEGIN
283:
284: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
285: l_status_code := g_approved;
286:
287: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
288: l_status_code := g_rejected;

Line 287: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

283:
284: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
285: l_status_code := g_approved;
286:
287: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
288: l_status_code := g_rejected;
289:
290: END IF;
291:

Line 313: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

309: l_status_code VARCHAR2(30);
310:
311: BEGIN
312:
313: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
314: l_status_code := g_approved;
315:
316: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
317: l_status_code := g_rejected;

Line 316: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

312:
313: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
314: l_status_code := g_approved;
315:
316: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
317: l_status_code := g_rejected;
318:
319: END IF;
320:

Line 343: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

339:
340:
341: BEGIN
342:
343: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
344: l_status_code := g_approved;
345:
346: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
347: l_status_code := g_rejected;

Line 346: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

342:
343: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
344: l_status_code := g_approved;
345:
346: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
347: l_status_code := g_rejected;
348:
349: END IF;
350:

Line 375: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

371:
372: BEGIN
373:
374: -- Get the Signature status
375: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
376: l_status_code := g_approved;
377:
378: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
379: l_status_code := g_rejected;

Line 378: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

374: -- Get the Signature status
375: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
376: l_status_code := g_approved;
377:
378: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
379: l_status_code := g_rejected;
380:
381: END IF;
382:

Line 404: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

400:
401: BEGIN
402:
403: -- Get the Signature status
404: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
405: l_status_code := g_approved;
406:
407: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
408: l_status_code := g_rejected;

Line 407: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

403: -- Get the Signature status
404: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
405: l_status_code := g_approved;
406:
407: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
408: l_status_code := g_rejected;
409:
410: END IF;
411:

Line 441: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN

437:
438: BEGIN
439:
440: -- Get the Signature status
441: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
442: l_status_code := g_approved;
443:
444: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
445: l_status_code := g_rejected;

Line 444: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN

440: -- Get the Signature status
441: IF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'SUCCESS') THEN
442: l_status_code := g_approved;
443:
444: ELSIF (EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS = 'REJECTED') THEN
445: l_status_code := g_rejected;
446:
447: END IF;
448: