DBA Data[Home] [Help]

APPS.AP_INVOICE_LINES_PKG dependencies on AP_UTILITIES_PKG

Line 191: l_line_base_amount := AP_UTILITIES_PKG.Ap_Round_Currency(

187: l_api_name := 'Generate_Dist_Tab_For_Dist_Set';
188:
189: --Bug 10182226: Populate line base amount.
190: if ( X_exchange_rate is not null and X_invoice_lines_rec.base_amount is null) then
191: l_line_base_amount := AP_UTILITIES_PKG.Ap_Round_Currency(
192: NVL(X_invoice_lines_rec.amount, 0) * X_exchange_rate,
193: X_base_currency);
194:
195: end if;

Line 323: l_dist_amount := AP_UTILITIES_PKG.Ap_Round_Currency(

319: l_dist_amount := 0;
320: l_dist_base_amount := NULL; -- Bug 5199337
321: ELSE
322: --bug6653070
323: l_dist_amount := AP_UTILITIES_PKG.Ap_Round_Currency(
324: NVL(l_dset_line_percent_dist,0)
325: * (NVL(X_invoice_lines_rec.amount,0))/100,
326: X_invoice_currency);
327: l_dist_base_amount := AP_UTILITIES_PKG.Ap_Round_Currency(

Line 327: l_dist_base_amount := AP_UTILITIES_PKG.Ap_Round_Currency(

323: l_dist_amount := AP_UTILITIES_PKG.Ap_Round_Currency(
324: NVL(l_dset_line_percent_dist,0)
325: * (NVL(X_invoice_lines_rec.amount,0))/100,
326: X_invoice_currency);
327: l_dist_base_amount := AP_UTILITIES_PKG.Ap_Round_Currency(
328: NVL(l_dist_amount, 0) * X_exchange_rate,
329: X_base_currency);
330:
331: END IF;

Line 591: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

587: -- is not from IMPORT
588: X_dist_tab(i).dist_ccid := l_dset_line_ccid;
589: IF ((X_dist_tab(i).project_id is not null AND
590: l_pa_allows_overrides = 'N')) then
591: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
592: l_dset_line_ccid,
593: X_chart_of_accounts_id,
594: X_invoice_lines_rec.accounting_date,
595: current_calling_sequence))) then

Line 606: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(

602: IF (X_invoice_lines_rec.overlay_dist_code_concat is NULL AND
603: X_invoice_lines_rec.balancing_segment is NULL AND
604: X_invoice_lines_rec.account_segment is NULL AND
605: X_invoice_lines_rec.cost_center_segment is NULL) then
606: IF ( NOT (AP_UTILITIES_PKG.IS_CCID_VALID(
607: l_dset_line_ccid,
608: X_chart_of_accounts_id,
609: X_invoice_lines_rec.accounting_date,
610: current_calling_sequence))) then

Line 616: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (

612: CLOSE DIST_SET_LINES_CUR;
613: RETURN(FALSE);
614: END IF;
615: ELSE -- account overlay information is provided at the line
616: IF ( NOT (AP_UTILITIES_PKG.OVERLAY_SEGMENTS (
617: X_invoice_lines_rec.balancing_segment,
618: X_invoice_lines_rec.cost_center_segment,
619: X_invoice_lines_rec.account_segment,
620: X_invoice_lines_rec.overlay_dist_code_concat,

Line 739: AP_UTILITIES_PKG.Ap_Round_Currency(

735: - l_running_total_amount);
736: l_running_total_base_amt :=
737: l_running_total_base_amt - X_dist_tab(l_max_i).base_amount;
738: X_dist_tab(l_max_i).base_amount :=
739: AP_UTILITIES_PKG.Ap_Round_Currency(
740: NVL(X_dist_tab(l_max_i).amount, 0) * X_exchange_rate ,
741: X_base_currency);
742: l_running_total_base_amt :=
743: l_running_total_base_amt + X_dist_tab(l_max_i).base_amount;

Line 2077: ap_utilities_pkg.get_gl_period_name(

2073: tax_dist.invoice_id invoice_id,
2074: l_user_id last_updated_by,
2075: l_sysdate last_update_date,
2076: tax_dist.line_type_lookup_code line_type_lookup_code,
2077: ap_utilities_pkg.get_gl_period_name(
2078: zx_dist.gl_date,
2079: tax_dist.org_id) period_name,
2080: tax_dist.set_of_books_id set_of_books_id,
2081: (-tax_dist.amount) amount,

Line 4413: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)),

4409: p_Last_Updated_By, -- last_updated_by
4410: /* Bug 5584997, Getting the accounting_date from line rec
4411: --Bug9345786. Commented the following code.
4412: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_line_rec.accounting_date,
4413: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)),
4414: -- accounting_date
4415: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_line_rec.period_name,
4416: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)),
4417: -- period_name, */

Line 4416: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)),

4412: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_line_rec.accounting_date,
4413: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)),
4414: -- accounting_date
4415: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_line_rec.period_name,
4416: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)),
4417: -- period_name, */
4418: --Bug9345786. Added following code instead.
4419: (CASE
4420: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.accounting_date

Line 4422: ap_utilities_pkg.get_reversal_gl_date(accounting_date, org_id)

4418: --Bug9345786. Added following code instead.
4419: (CASE
4420: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.accounting_date
4421: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date > p_line_rec.accounting_date) THEN
4422: ap_utilities_pkg.get_reversal_gl_date(accounting_date, org_id)
4423: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4424: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)
4425: ELSE
4426: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)

Line 4424: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)

4420: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.accounting_date
4421: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date > p_line_rec.accounting_date) THEN
4422: ap_utilities_pkg.get_reversal_gl_date(accounting_date, org_id)
4423: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4424: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)
4425: ELSE
4426: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)
4427: END), -- accounting_date
4428: (CASE

Line 4426: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)

4422: ap_utilities_pkg.get_reversal_gl_date(accounting_date, org_id)
4423: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4424: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)
4425: ELSE
4426: ap_utilities_pkg.get_reversal_gl_date(p_line_rec.accounting_date, org_id)
4427: END), -- accounting_date
4428: (CASE
4429: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.period_name
4430: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date > p_line_rec.accounting_date) THEN

Line 4431: ap_utilities_pkg.get_reversal_period(accounting_date, org_id)

4427: END), -- accounting_date
4428: (CASE
4429: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.period_name
4430: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date > p_line_rec.accounting_date) THEN
4431: ap_utilities_pkg.get_reversal_period(accounting_date, org_id)
4432: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4433: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)
4434: ELSE
4435: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)

Line 4433: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)

4429: WHEN (P_calling_mode = 'UNAPPLY_PREPAY') THEN p_line_rec.period_name
4430: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date > p_line_rec.accounting_date) THEN
4431: ap_utilities_pkg.get_reversal_period(accounting_date, org_id)
4432: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4433: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)
4434: ELSE
4435: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)
4436: END ), -- period_name
4437: Set_Of_Books_Id, -- set_of_book_id

Line 4435: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)

4431: ap_utilities_pkg.get_reversal_period(accounting_date, org_id)
4432: WHEN (P_calling_mode <> 'UNAPPLY_PREPAY' AND accounting_date <= p_line_rec.accounting_date) THEN
4433: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)
4434: ELSE
4435: ap_utilities_pkg.get_reversal_period(p_line_rec.accounting_date, org_id)
4436: END ), -- period_name
4437: Set_Of_Books_Id, -- set_of_book_id
4438: -1 * Amount, -- amount
4439: Description, -- description

Line 5279: ap_utilities_pkg.get_reversal_gl_date(p_inv_line_rec.accounting_date, org_id)),

5275: sysdate, -- last_update_date
5276: fnd_global.user_id, -- last_updated_by
5277: /* Bug 5584997, Getting the accounting_date from line rec */
5278: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.accounting_date,
5279: ap_utilities_pkg.get_reversal_gl_date(p_inv_line_rec.accounting_date, org_id)),
5280: -- accounting_date
5281: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.period_name,
5282: ap_utilities_pkg.get_reversal_period(p_inv_line_rec.accounting_date, org_id)),
5283: -- period_name,

Line 5282: ap_utilities_pkg.get_reversal_period(p_inv_line_rec.accounting_date, org_id)),

5278: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.accounting_date,
5279: ap_utilities_pkg.get_reversal_gl_date(p_inv_line_rec.accounting_date, org_id)),
5280: -- accounting_date
5281: DECODE(P_calling_mode,'UNAPPLY_PREPAY',p_inv_line_rec.period_name,
5282: ap_utilities_pkg.get_reversal_period(p_inv_line_rec.accounting_date, org_id)),
5283: -- period_name,
5284: Set_Of_Books_Id, -- set_of_book_id
5285: -1 * Amount, -- amount
5286: Description, -- description