eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CSE_IFA_TRANS_PKG dependencies on FA_MASS_EXTERNAL_TRANSFERS

Line 63: select fa_mass_external_transfers_s.nextval

59:
60: l_from_units := -p_units;
61:
62: -- Select sequence number
63: select fa_mass_external_transfers_s.nextval
64: into l_seq_num
65: from dual;
66:
67: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table

Line 67: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table

63: select fa_mass_external_transfers_s.nextval
64: into l_seq_num
65: from dual;
66:
67: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table
68:
69: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
70: l_seq_num);
71:

Line 72: INSERT INTO fa_mass_external_transfers(batch_name,

68:
69: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
70: l_seq_num);
71:
72: INSERT INTO fa_mass_external_transfers(batch_name,
73: mass_external_transfer_id,
74: transaction_reference_num,
75: transaction_type,
76: from_asset_id,

Line 108: select fa_mass_external_transfers_s.nextval

104: sysdate,
105: sysdate);
106:
107: -- Select sequence number
108: select fa_mass_external_transfers_s.nextval
109: into l_seq_num
110: from dual;
111:
112: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table

Line 112: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table

108: select fa_mass_external_transfers_s.nextval
109: into l_seq_num
110: from dual;
111:
112: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table
113:
114: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
115: l_seq_num);
116:

Line 117: INSERT INTO fa_mass_external_transfers(batch_name,

113:
114: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
115: l_seq_num);
116:
117: INSERT INTO fa_mass_external_transfers(batch_name,
118: mass_external_transfer_id,
119: transaction_reference_num,
120: transaction_type,
121: from_asset_id,

Line 362: select fa_mass_external_transfers_s.nextval

358: l_employee_id
359: from fa_distribution_history
360: where distribution_id = l_temp_dist_id;
361:
362: select fa_mass_external_transfers_s.nextval
363: into l_seq_num
364: from dual;
365:
366: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||

Line 369: INSERT INTO fa_mass_external_transfers(batch_name,

365:
366: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
367: l_seq_num);
368:
369: INSERT INTO fa_mass_external_transfers(batch_name,
370: mass_external_transfer_id,
371: transaction_reference_num,
372: transaction_type,
373: from_asset_id,

Line 409: select fa_mass_external_transfers_s.nextval

405:
406: l_from_units := -p_units;
407:
408: -- Select sequence number
409: select fa_mass_external_transfers_s.nextval
410: into l_seq_num
411: from dual;
412:
413: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table

Line 413: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table

409: select fa_mass_external_transfers_s.nextval
410: into l_seq_num
411: from dual;
412:
413: -- Insert the FROM record into the FA_MASS_EXTERNAL_TRANSFERS interface table
414:
415: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
416: l_seq_num);
417:

Line 418: INSERT INTO fa_mass_external_transfers(batch_name,

414:
415: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
416: l_seq_num);
417:
418: INSERT INTO fa_mass_external_transfers(batch_name,
419: mass_external_transfer_id,
420: transaction_reference_num,
421: transaction_type,
422: from_asset_id,

Line 454: select fa_mass_external_transfers_s.nextval

450: sysdate,
451: sysdate);
452:
453: -- Select sequence number
454: select fa_mass_external_transfers_s.nextval
455: into l_seq_num
456: from dual;
457:
458: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table

Line 458: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table

454: select fa_mass_external_transfers_s.nextval
455: into l_seq_num
456: from dual;
457:
458: -- Insert the TO record into the FA_MASS_EXTERNAL_TRANSFERS interface table
459:
460: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
461: l_seq_num);
462:

Line 463: INSERT INTO fa_mass_external_transfers(batch_name,

459:
460: cse_util_pkg.write_log('Inserting record with MASS_EXTERNAL_TRANSFER_ID ' ||
461: l_seq_num);
462:
463: INSERT INTO fa_mass_external_transfers(batch_name,
464: mass_external_transfer_id,
465: transaction_reference_num,
466: transaction_type,
467: from_asset_id,

Line 571: select fa_mass_external_transfers_s.nextval

567: close c_dist1;
568:
569: -- Select sequence number
570:
571: select fa_mass_external_transfers_s.nextval
572: into l_seq_num
573: from dual;
574:
575: -- Insert the record into the FA_MASS_EXTERNAL_TRANSFERS interface table

Line 575: -- Insert the record into the FA_MASS_EXTERNAL_TRANSFERS interface table

571: select fa_mass_external_transfers_s.nextval
572: into l_seq_num
573: from dual;
574:
575: -- Insert the record into the FA_MASS_EXTERNAL_TRANSFERS interface table
576:
577: cse_util_pkg.write_log('Distribution exists. Inserting record with MASS_EXTERNAL_TRANSFER_ID ' || l_seq_num);
578:
579: if (p_units < 0) then -- Subtracting

Line 581: INSERT INTO fa_mass_external_transfers(batch_name,

577: cse_util_pkg.write_log('Distribution exists. Inserting record with MASS_EXTERNAL_TRANSFER_ID ' || l_seq_num);
578:
579: if (p_units < 0) then -- Subtracting
580:
581: INSERT INTO fa_mass_external_transfers(batch_name,
582: mass_external_transfer_id,
583: transaction_reference_num,
584: transaction_type,
585: from_asset_id,

Line 618: INSERT INTO fa_mass_external_transfers(batch_name,

614: sysdate);
615:
616: elsif (p_units > 0) then -- Adding
617:
618: INSERT INTO fa_mass_external_transfers(batch_name,
619: mass_external_transfer_id,
620: transaction_reference_num,
621: transaction_type,
622: from_asset_id,