APPS.IBY_SCHED dependencies on IBY_TRANS_CORE_V

Line 165: TYPE txn_mid_TabTyp is TABLE OF iby_trans_core_v.trxnmid%TYPE

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
166: INDEX BY BINARY_INTEGER;
167:
168: o_status VARCHAR2(80);
169: o_errcode VARCHAR2(80);

Line 191: SELECT iby_trans_core_v.TRANSACTIONID,

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,
195: iby_trans_core_v.REFERENCECODE,

Line 192: iby_trans_core_v.STATUS,

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,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID

Line 193: iby_trans_core_v.UPDATEDATE,

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,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v

Line 194: iby_trans_core_v.REQTYPE,

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,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')

Line 195: iby_trans_core_v.REFERENCECODE,

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,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
199: AND iby_trans_core_v.ecappid = cin_ecappid;

Line 196: iby_trans_core_v.TRXNMID

192: iby_trans_core_v.STATUS,
193: iby_trans_core_v.UPDATEDATE,
194: iby_trans_core_v.REQTYPE,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
199: AND iby_trans_core_v.ecappid = cin_ecappid;
200:

Line 197: FROM iby_trans_core_v

193: iby_trans_core_v.UPDATEDATE,
194: iby_trans_core_v.REQTYPE,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')
199: AND iby_trans_core_v.ecappid = cin_ecappid;
200:
201:

Line 198: WHERE iby_trans_core_v.needsupdt IN ('Y','F')

194: iby_trans_core_v.REQTYPE,
195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
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

Line 199: AND iby_trans_core_v.ecappid = cin_ecappid;

195: iby_trans_core_v.REFERENCECODE,
196: iby_trans_core_v.TRXNMID
197: FROM iby_trans_core_v
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,