APPS.AR_RECEIPT_VAL_PVT dependencies on AR_ACTIVITY_DETAILS

Line 4442: ar_activity_details_pkg.insert_row (

4438: l_cr_unapp_bal := Nvl(l_cr_unapp_bal,0) - (Nvl(l_calc_line_amount,0)
4439: + Nvl(l_calc_tax_amount,0));
4440: End If;
4441:
4442: ar_activity_details_pkg.insert_row (
4443: x_rowid => l_rowid,
4444: x_cash_receipt_id => p_cash_receipt_id,
4445: x_customer_trx_line_id => line_grp.line_id,
4446: x_allocated_receipt_amount => Nvl(l_calc_tot_amount_app,0),

Line 4586: ar_activity_details_pkg.insert_row (

4582: arp_util.debug('l_cr_unapp_bal (R) => '||to_char(l_cr_unapp_bal));
4583: END IF;
4584: End If;
4585:
4586: ar_activity_details_pkg.insert_row (
4587: x_rowid => l_rowid,
4588: x_cash_receipt_id => p_cash_receipt_id,
4589: x_customer_trx_line_id => All_lines_row.line_id,
4590: x_allocated_receipt_amount => Nvl(l_calc_amount_app_from,0),

Line 4661: 'AR_ACTIVITY_DETAILS',

4657: l_attribute_rec.attribute15 := sp_lines_row.attribute15;
4658:
4659: ar_receipt_lib_pvt.Validate_Desc_Flexfield(
4660: l_attribute_rec,
4661: 'AR_ACTIVITY_DETAILS',
4662: l_dflex_val_return_status
4663: );
4664:
4665: If l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS Then

Line 4759: ar_activity_details_pkg.insert_row(

4755: arp_util.debug('l_cr_unapp_bal (R) => '||to_char(l_cr_unapp_bal));
4756: END IF;
4757: --- End If;
4758: --bug7311231, Picking the flexfield value from ar_llca_trx_lines_gt, for each line.
4759: ar_activity_details_pkg.insert_row(
4760: x_rowid => l_rowid,
4761: x_cash_receipt_id => p_cash_receipt_id,
4762: x_customer_trx_line_id => sp_lines_row.customer_trx_line_id,
4763: x_allocated_receipt_amount => Nvl(l_calc_amount_app_from,0),

Line 4860: from ar_activity_details rcv_lines,

4856: rcv_lines.freight_discount frt_disc,
4857: 0 chg_disc,
4858: --
4859: rcv_lines.allocated_receipt_amount
4860: from ar_activity_details rcv_lines,
4861: ra_customer_trx_lines trx_lines
4862: where trx_lines.customer_trx_id = p_cust_trx_id
4863: and rcv_lines.cash_receipt_id = p_cash_rec_id
4864: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111

Line 4878: from ar_Activity_details rcv_lines,

4874: sum(Nvl(rcv_lines.line_discount,0)) lin_disc,
4875: sum(Nvl(rcv_lines.tax_discount,0)) tax_disc,
4876: sum(NVl(rcv_lines.freight_discount,0)) frt_disc,
4877: sum(Nvl(rcv_lines.allocated_receipt_amount,0)) allocated
4878: from ar_Activity_details rcv_lines,
4879: ra_customer_trx_lines_all trx_lines
4880: where trx_lines.customer_trx_id = pf_ct_id
4881: and rcv_lines.cash_receipt_id = pf_cr_id
4882: and nvl(rcv_lines.CURRENT_ACTIVITY_FLAG, 'Y') = 'Y' -- Bug 7241111