APPS.IBY_SCHED dependencies on IBY_ECAPP

Line 161: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type)

157: close c_tangibleInfo;
158: end bankInfo;
159:
160:
161: procedure update_ecapp (in_ecappid in iby_ecapp.ecappid%type)
162: is
163:
164:
165: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE

Line 190: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS

186:
187: i NUMBER := 0;
188:
189:
190: CURSOR c_trans_core (cin_ecappid in iby_ecapp.ecappid%type) IS
191: SELECT iby_trans_core_v.TRANSACTIONID,
192: iby_trans_core_v.STATUS,
193: iby_trans_core_v.UPDATEDATE,
194: iby_trans_core_v.REQTYPE,

Line 202: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS

198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
199: AND iby_trans_core_v.ecappid = cin_ecappid;
200:
201:
202: CURSOR c_trans_fi (cin_ecappid in iby_ecapp.ecappid%type) IS
203: SELECT iby_trans_fi_v.TRANSACTIONID,
204: iby_trans_fi_v.STATUS,
205: iby_trans_fi_v.UPDATEDATE,
206: iby_trans_fi_v.REQTYPE,

Line 215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS

211: AND iby_trans_fi_v.ecappid = cin_ecappid;
212:
213: -- r_trans_fi c_trans_fi%ROWTYPE;
214:
215: CURSOR c_trans_bankacct (cin_ecappid in iby_ecapp.ecappid%type) IS
216: SELECT iby_trans_bankacct_v.TRANSACTIONID,
217: iby_trans_bankacct_v.STATUS,
218: iby_trans_bankacct_v.UPDATEDATE,
219: iby_trans_bankacct_v.REQTYPE,

Line 228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS

224: AND iby_trans_bankacct_v.ecappid = cin_ecappid;
225:
226: -- r_trans_bankacct c_trans_bankacct%ROWTYPE;
227:
228: CURSOR c_trans_pcard (cin_ecappid in iby_ecapp.ecappid%type) IS
229: SELECT iby_trans_pcard_v.TRANSACTIONID,
230: iby_trans_pcard_v.STATUS,
231: iby_trans_pcard_v.UPDATEDATE,
232: iby_trans_pcard_v.REQTYPE,

Line 329: FROM iby_ecapp_v

325:
326: -- Now getting the application short name
327: SELECT application_short_name
328: INTO ecapp_name
329: FROM iby_ecapp_v
330: WHERE ecappid = in_ecappid;
331:
332: -- dbms_output.put_line('Total count for inner loop : ' || i);
333: --dbms_output.put_line('Sending in : ' || txn_id_Tab(1) ||'** ' ||Status_Tab(1) ||'** '|| updatedt_Tab(1) || '** '|| refcode_Tab(1) ||'** '|| txn_mid_Tab(1));

Line 375: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status

371: WHEN OTHERS THEN
372:
373: /*
374: * If we reached here it means that either the ecapp name does not
375: * exist in iby_ecapp_v, or that the procedure ecapp_pkg.update_status
376: * does not exist. Both these are ok. Swallow the exception and
377: * all procedure to exit gracefully. Fix for bug 3883880.
378: */
379: NULL;