981: p_crh_rec IN ar_cash_receipt_history%ROWTYPE) IS
982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
982: l_new_crh_rec ar_cash_receipt_history%ROWTYPE;
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
983: BEGIN
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
984: IF PG_DEBUG in ('Y', 'C') THEN
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/
985: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()+');
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/
993: SELECT *
986: arp_util.debug(' Cash receipt_id = '||to_char(p_crh_rec.cash_receipt_id));
987: arp_util.debug('History_id = '||to_char(p_crh_rec.cash_receipt_history_id));
988: arp_util.debug('Amount = '||to_char(p_crh_rec.amount));
989: arp_util.debug('Status ='||p_crh_rec.status);
990: arp_util.debug('PC IS = '||to_char(p_crh_rec.posting_control_id));
991: END IF;
992: /*4354354 included nvl(factor_discount_amount,0) in the existing amount condition*/
993: SELECT *
994: INTO
1022: AR_NUMBER_DUMMY
1023: )
1024: AND NVL(crh.current_record_flag,AR_FLAG_DUMMY) = 'Y'
1025: FOR UPDATE NOWAIT;
1026: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()-');
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF PG_DEBUG in ('Y', 'C') THEN
1030: arp_util.debug('EXCEPTION: arp_cr_history_pkg.lock_hist_compare_p()');
1026: arp_util.debug('arp_cr_history_pkg.lock_hist_compare_p()-');
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF PG_DEBUG in ('Y', 'C') THEN
1030: arp_util.debug('EXCEPTION: arp_cr_history_pkg.lock_hist_compare_p()');
1031: END IF;
1032: RAISE;
1033: END lock_hist_compare_p;
1034: /* End bug fix 2742388 */