APPS.AR_RECEIPT_VAL_PVT dependencies on AR_ACTIVITY_DETAILS

Line 4304: ar_activity_details_pkg.insert_row (

4300: l_cr_unapp_bal := Nvl(l_cr_unapp_bal,0) - (Nvl(l_calc_line_amount,0)
4301: + Nvl(l_calc_tax_amount,0));
4302: End If;
4303:
4304: ar_activity_details_pkg.insert_row (
4305: x_rowid => l_rowid,
4306: x_cash_receipt_id => p_cash_receipt_id,
4307: x_customer_trx_line_id => line_grp.line_id,
4308: x_allocated_receipt_amount => Nvl(l_calc_tot_amount_app,0),

Line 4448: ar_activity_details_pkg.insert_row (

4444: arp_util.debug('l_cr_unapp_bal (R) => '||to_char(l_cr_unapp_bal));
4445: END IF;
4446: End If;
4447:
4448: ar_activity_details_pkg.insert_row (
4449: x_rowid => l_rowid,
4450: x_cash_receipt_id => p_cash_receipt_id,
4451: x_customer_trx_line_id => All_lines_row.line_id,
4452: x_allocated_receipt_amount => Nvl(l_calc_amount_app_from,0),

Line 4523: 'AR_ACTIVITY_DETAILS',

4519: l_attribute_rec.attribute15 := sp_lines_row.attribute15;
4520:
4521: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
4522: l_attribute_rec,
4523: 'AR_ACTIVITY_DETAILS',
4524: l_dflex_val_return_status
4525: );
4526:
4527: If l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 4621: ar_activity_details_pkg.insert_row(

4617: arp_util.debug('l_cr_unapp_bal (R) => '||to_char(l_cr_unapp_bal));
4618: END IF;
4619: --- End If;
4620: --bug7311231, Picking the flexfield value from ar_llca_trx_lines_gt, for each line.
4621: ar_activity_details_pkg.insert_row(
4622: x_rowid => l_rowid,
4623: x_cash_receipt_id => p_cash_receipt_id,
4624: x_customer_trx_line_id => sp_lines_row.customer_trx_line_id,
4625: x_allocated_receipt_amount => Nvl(l_calc_amount_app_from,0),

Line 4722: from ar_activity_details rcv_lines,

4718: rcv_lines.freight_discount frt_disc,
4719: 0 chg_disc,
4720: --
4721: rcv_lines.allocated_receipt_amount
4722: from ar_activity_details rcv_lines,
4723: ra_customer_trx_lines trx_lines
4724: where trx_lines.customer_trx_id = p_cust_trx_id
4725: and rcv_lines.cash_receipt_id = p_cash_rec_id
4726: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111

Line 4740: from ar_Activity_details rcv_lines,

4736: sum(Nvl(rcv_lines.line_discount,0)) lin_disc,
4737: sum(Nvl(rcv_lines.tax_discount,0)) tax_disc,
4738: sum(NVl(rcv_lines.freight_discount,0)) frt_disc,
4739: sum(Nvl(rcv_lines.allocated_receipt_amount,0)) allocated
4740: from ar_Activity_details rcv_lines,
4741: ra_customer_trx_lines_all trx_lines
4742: where trx_lines.customer_trx_id = pf_ct_id
4743: and rcv_lines.cash_receipt_id = pf_cr_id
4744: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111