APPS.PAY_ADHOC_UTILS_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 315: l_flex_num pay_external_accounts.id_flex_num%type;

311: --
312: l_concat_string varchar2(2000);
313: l_proc constant varchar2(72) := g_package||'get_bank_details';
314:
315: l_flex_num pay_external_accounts.id_flex_num%type;
316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;

Line 316: l_segment1 pay_external_accounts.segment1%type;

312: l_concat_string varchar2(2000);
313: l_proc constant varchar2(72) := g_package||'get_bank_details';
314:
315: l_flex_num pay_external_accounts.id_flex_num%type;
316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;

Line 317: l_segment2 pay_external_accounts.segment2%type;

313: l_proc constant varchar2(72) := g_package||'get_bank_details';
314:
315: l_flex_num pay_external_accounts.id_flex_num%type;
316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;

Line 318: l_segment3 pay_external_accounts.segment3%type;

314:
315: l_flex_num pay_external_accounts.id_flex_num%type;
316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;

Line 319: l_segment4 pay_external_accounts.segment4%type;

315: l_flex_num pay_external_accounts.id_flex_num%type;
316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;

Line 320: l_segment5 pay_external_accounts.segment5%type;

316: l_segment1 pay_external_accounts.segment1%type;
317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;

Line 321: l_segment6 pay_external_accounts.segment6%type;

317: l_segment2 pay_external_accounts.segment2%type;
318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;

Line 322: l_segment7 pay_external_accounts.segment7%type;

318: l_segment3 pay_external_accounts.segment3%type;
319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;

Line 323: l_segment8 pay_external_accounts.segment8%type;

319: l_segment4 pay_external_accounts.segment4%type;
320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;

Line 324: l_segment9 pay_external_accounts.segment9%type;

320: l_segment5 pay_external_accounts.segment5%type;
321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;

Line 325: l_segment10 pay_external_accounts.segment10%type;

321: l_segment6 pay_external_accounts.segment6%type;
322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;

Line 326: l_segment11 pay_external_accounts.segment11%type;

322: l_segment7 pay_external_accounts.segment7%type;
323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;

Line 327: l_segment12 pay_external_accounts.segment12%type;

323: l_segment8 pay_external_accounts.segment8%type;
324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;

Line 328: l_segment13 pay_external_accounts.segment13%type;

324: l_segment9 pay_external_accounts.segment9%type;
325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;

Line 329: l_segment14 pay_external_accounts.segment14%type;

325: l_segment10 pay_external_accounts.segment10%type;
326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;

Line 330: l_segment15 pay_external_accounts.segment15%type;

326: l_segment11 pay_external_accounts.segment11%type;
327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;

Line 331: l_segment16 pay_external_accounts.segment16%type;

327: l_segment12 pay_external_accounts.segment12%type;
328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;

Line 332: l_segment17 pay_external_accounts.segment17%type;

328: l_segment13 pay_external_accounts.segment13%type;
329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;

Line 333: l_segment18 pay_external_accounts.segment18%type;

329: l_segment14 pay_external_accounts.segment14%type;
330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;

Line 334: l_segment19 pay_external_accounts.segment19%type;

330: l_segment15 pay_external_accounts.segment15%type;
331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;

Line 335: l_segment20 pay_external_accounts.segment20%type;

331: l_segment16 pay_external_accounts.segment16%type;
332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;

Line 336: l_segment21 pay_external_accounts.segment21%type;

332: l_segment17 pay_external_accounts.segment17%type;
333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;

Line 337: l_segment22 pay_external_accounts.segment22%type;

333: l_segment18 pay_external_accounts.segment18%type;
334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;

Line 338: l_segment23 pay_external_accounts.segment23%type;

334: l_segment19 pay_external_accounts.segment19%type;
335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;

Line 339: l_segment24 pay_external_accounts.segment24%type;

335: l_segment20 pay_external_accounts.segment20%type;
336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;

Line 340: l_segment25 pay_external_accounts.segment25%type;

336: l_segment21 pay_external_accounts.segment21%type;
337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;

Line 341: l_segment26 pay_external_accounts.segment26%type;

337: l_segment22 pay_external_accounts.segment22%type;
338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;
345: l_segment30 pay_external_accounts.segment30%type;

Line 342: l_segment27 pay_external_accounts.segment27%type;

338: l_segment23 pay_external_accounts.segment23%type;
339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;
345: l_segment30 pay_external_accounts.segment30%type;
346:

Line 343: l_segment28 pay_external_accounts.segment28%type;

339: l_segment24 pay_external_accounts.segment24%type;
340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;
345: l_segment30 pay_external_accounts.segment30%type;
346:
347: cursor csr_flex_num is

Line 344: l_segment29 pay_external_accounts.segment29%type;

340: l_segment25 pay_external_accounts.segment25%type;
341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;
345: l_segment30 pay_external_accounts.segment30%type;
346:
347: cursor csr_flex_num is
348: select exa.id_flex_num,

Line 345: l_segment30 pay_external_accounts.segment30%type;

341: l_segment26 pay_external_accounts.segment26%type;
342: l_segment27 pay_external_accounts.segment27%type;
343: l_segment28 pay_external_accounts.segment28%type;
344: l_segment29 pay_external_accounts.segment29%type;
345: l_segment30 pay_external_accounts.segment30%type;
346:
347: cursor csr_flex_num is
348: select exa.id_flex_num,
349: exa.segment1,

Line 379: from pay_external_accounts exa

375: exa.segment27,
376: exa.segment28,
377: exa.segment29,
378: exa.segment30
379: from pay_external_accounts exa
380: where exa.external_account_id = p_external_account_id;
381: --
382: BEGIN
383: --