DBA Data[Home] [Help]

APPS.ARP_PROCESS_BR_REMIT dependencies on AR_BILLS_MAINTAIN_PUB

Line 1079: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);

1075: EXIT WHEN CUR_BR%NOTFOUND;
1076: IF PG_DEBUG in ('Y', 'C') THEN
1077: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1078: END IF;
1079: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
1080: TOTAL_COUNT := TOTAL_COUNT + 1;
1081: TOTAL_AMOUNT := TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0);
1082: END LOOP;
1083: ELSE

Line 1094: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);

1090: IF (TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0) <= p_remit_total_high) THEN
1091: IF PG_DEBUG in ('Y', 'C') THEN
1092: arp_util.debug('create_remit_batch: ' || 'BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1093: END IF;
1094: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,l_ps_rec.payment_schedule_id,l_new_status);
1095: TOTAL_COUNT := TOTAL_COUNT + 1;
1096: TOTAL_AMOUNT := TOTAL_AMOUNT + NVL(l_ps_rec.amount_due_remaining,0);
1097: END IF;
1098: END LOOP;

Line 1241: AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit(p_ps_id,l_new_status);

1237: IF (p_action_flag = 'D') THEN
1238: IF PG_DEBUG in ('Y', 'C') THEN
1239: arp_util.debug('create_remit_batch: ' || 'Action Deselect - Remove the BR '||p_ps_id||' from its remittance');
1240: END IF;
1241: AR_BILLS_MAINTAIN_PUB.DeSelect_BR_Remit(p_ps_id,l_new_status);
1242: l_control_count := l_control_count - 1;
1243: l_control_amount := l_control_amount - l_br_amount;
1244: ELSIF (p_action_flag = 'E') THEN
1245: IF PG_DEBUG in ('Y', 'C') THEN

Line 1248: AR_BILLS_MAINTAIN_PUB.cancel_br_remit(p_ps_id);

1244: ELSIF (p_action_flag = 'E') THEN
1245: IF PG_DEBUG in ('Y', 'C') THEN
1246: arp_util.debug('create_remit_batch: ' || 'Action Erase - Remove the BR '||p_ps_id||' from its remittance');
1247: END IF;
1248: AR_BILLS_MAINTAIN_PUB.cancel_br_remit(p_ps_id);
1249: l_control_count := l_control_count - 1;
1250: l_control_amount := l_control_amount - l_br_amount;
1251: ELSE
1252: IF PG_DEBUG in ('Y', 'C') THEN

Line 1255: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,p_ps_id,l_new_status);

1251: ELSE
1252: IF PG_DEBUG in ('Y', 'C') THEN
1253: arp_util.debug('create_remit_batch: ' || 'Action Select - BR '||l_ps_rec.payment_schedule_id||' assign to the remittance '||p_batch_id);
1254: END IF;
1255: AR_BILLS_MAINTAIN_PUB.Select_BR_Remit(p_batch_id,p_ps_id,l_new_status);
1256: l_control_count := l_control_count + 1;
1257: l_control_amount := l_control_amount + l_br_amount;
1258: END IF;
1259: