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.

APPS.PSA_MF_MISC_PKG dependencies on PSA_MF_MISC_DIST_ALL

Line 58: psa_mf_misc_dist_all mf,

54: mf.misc_cash_distribution_id,
55: mf.distribution_ccid,
56: ar.code_combination_id
57: FROM
58: psa_mf_misc_dist_all mf,
59: ar_misc_cash_distributions ar
60: WHERE
61: mf.reference1 = p_status
62: AND mf.misc_cash_distribution_id = ar.misc_cash_distribution_id

Line 108: -- records in psa_mf_misc_dist_all

104: LOOP
105:
106: -- Changes for Cash Mgt
107: -- Before checking for existence of records, the status should also be used to classify the
108: -- records in psa_mf_misc_dist_all
109:
110: SELECT COUNT(*) INTO mf_dist_count
111: FROM psa_mf_misc_dist_all psa,
112: ar_misc_cash_distributions ar

Line 111: FROM psa_mf_misc_dist_all psa,

107: -- Before checking for existence of records, the status should also be used to classify the
108: -- records in psa_mf_misc_dist_all
109:
110: SELECT COUNT(*) INTO mf_dist_count
111: FROM psa_mf_misc_dist_all psa,
112: ar_misc_cash_distributions ar
113: WHERE psa.misc_cash_distribution_id = ar.misc_cash_distribution_id
114: AND ar.cash_receipt_id = g_cash_receipt_id
115: AND psa.reference1 = I.status;

Line 362: SELECT cash_ccid FROM psa_mf_misc_dist_all

358: WHERE crh.cash_receipt_history_id = x_cash_receipt_hist_id AND
359: crh.cash_receipt_history_id = crh1.reversal_cash_receipt_hist_id(+);
360:
361: CURSOR c_reversal_ccid(p_misc_dist_id in number) IS
362: SELECT cash_ccid FROM psa_mf_misc_dist_all
363: WHERE reference1 = 'REMITTED'
364: AND misc_cash_distribution_id = p_misc_dist_id;
365:
366: l_reversal_ccid NUMBER;

Line 445: -- we delete records from psa_mf_misc_dist_all when the Dist records

441: -- ========================= FND LOG ===========================
442:
443: IF cr_status IN ('NSF','STOP','REV') THEN
444:
445: -- we delete records from psa_mf_misc_dist_all when the Dist records
446: --have not yet been posted and the Receipt has been reversed.
447: --These records are re-created by the code written below.
448:
449: DELETE FROM psa_mf_misc_dist_all

Line 449: DELETE FROM psa_mf_misc_dist_all

445: -- we delete records from psa_mf_misc_dist_all when the Dist records
446: --have not yet been posted and the Receipt has been reversed.
447: --These records are re-created by the code written below.
448:
449: DELETE FROM psa_mf_misc_dist_all
450: WHERE reference5 = g_cash_receipt_id
451: AND posting_control_id = -3;
452:
453: -- ========================= FND LOG ===========================

Line 467: FROM psa_mf_misc_dist_all

463: FETCH c_misc_dist_new INTO misc_dist_new_rec;
464: EXIT WHEN c_misc_dist_new%NOTFOUND;
465:
466: SELECT COUNT(*) INTO psa_count
467: FROM psa_mf_misc_dist_all
468: WHERE misc_cash_distribution_id = misc_dist_new_rec.misc_cash_distribution_id
469: AND posting_control_id >0;
470:
471: -- ========================= FND LOG ===========================

Line 531: ' Create_distributions --> calling psa_mf_misc_dist_all_pkg.insert_row ');

527: END IF;
528:
529: -- ========================= FND LOG ===========================
530: psa_utils.debug_other_string(g_state_level,l_full_path,
531: ' Create_distributions --> calling psa_mf_misc_dist_all_pkg.insert_row ');
532: -- ========================= FND LOG ===========================
533:
534: psa_mf_misc_dist_all_pkg.insert_row
535: (

Line 534: psa_mf_misc_dist_all_pkg.insert_row

530: psa_utils.debug_other_string(g_state_level,l_full_path,
531: ' Create_distributions --> calling psa_mf_misc_dist_all_pkg.insert_row ');
532: -- ========================= FND LOG ===========================
533:
534: psa_mf_misc_dist_all_pkg.insert_row
535: (
536: X_ROWID => x_dummy,
537: X_MISC_MF_CASH_DIST_ID => 1001,
538: X_MISC_CASH_DISTRIBUTION_ID => misc_dist_new_rec.misc_cash_distribution_id,

Line 582: ' Create_distributions --> delete from psa_mf_misc_dist_all ');

578: -- ========================= FND LOG ===========================
579: psa_utils.debug_other_string(g_state_level,l_full_path,
580: ' Create_distributions --> cr_status NOT IN (NSF,STOP,REV)');
581: psa_utils.debug_other_string(g_state_level,l_full_path,
582: ' Create_distributions --> delete from psa_mf_misc_dist_all ');
583: -- ========================= FND LOG ===========================
584:
585: DELETE FROM psa_mf_misc_dist_all
586: WHERE misc_cash_distribution_id IN

Line 585: DELETE FROM psa_mf_misc_dist_all

581: psa_utils.debug_other_string(g_state_level,l_full_path,
582: ' Create_distributions --> delete from psa_mf_misc_dist_all ');
583: -- ========================= FND LOG ===========================
584:
585: DELETE FROM psa_mf_misc_dist_all
586: WHERE misc_cash_distribution_id IN
587: (SELECT misc_cash_distribution_id
588: FROM ar_misc_cash_distributions
589: WHERE reference5 = g_cash_receipt_id);

Line 677: ' Create_distributions --> Calling psa_mf_misc_dist_all_pkg.insert_row ');

673: END IF;
674:
675: -- ========================= FND LOG ===========================
676: psa_utils.debug_other_string(g_state_level,l_full_path,
677: ' Create_distributions --> Calling psa_mf_misc_dist_all_pkg.insert_row ');
678: -- ========================= FND LOG ===========================
679:
680: SELECT first_posted_record_flag INTO first_rec_flag
681: FROM ar_cash_receipt_history

Line 691: psa_mf_misc_dist_all_pkg.insert_row

687: EXIT WHEN c_reversal_ccid%NOTFOUND;
688: CLOSE c_reversal_ccid;
689: END IF;
690:
691: psa_mf_misc_dist_all_pkg.insert_row
692: (
693: X_ROWID => x_dummy,
694: X_MISC_MF_CASH_DIST_ID => 1001,
695: X_MISC_CASH_DISTRIBUTION_ID => l_misc_dist_rec.misc_cash_distribution_id,

Line 788: FROM psa_mf_misc_dist_all psa,

784: -- ========================= FND LOG ===========================
785:
786:
787: SELECT COUNT(MISC_MF_CASH_DIST_ID) INTO psa_dist_count
788: FROM psa_mf_misc_dist_all psa,
789: ar_misc_cash_distributions ar
790: WHERE psa.reference1 = p_status
791: AND psa.misc_cash_distribution_id = ar.misc_cash_distribution_id
792: AND ar.cash_receipt_id = g_cash_receipt_id;

Line 803: ' Misc_rct_changed --> delete psa_mf_misc_dist_all ' || SQL%ROWCOUNT);

799:
800:
801: -- ========================= FND LOG ===========================
802: psa_utils.debug_other_string(g_state_level,l_full_path,
803: ' Misc_rct_changed --> delete psa_mf_misc_dist_all ' || SQL%ROWCOUNT);
804: -- ========================= FND LOG ===========================
805:
806: IF ar_dist_count = psa_dist_count THEN
807: -- ========================= FND LOG ===========================