APPS.PAAPIMP_PKG dependencies on PA_UTILS

Line 132: IF PA_UTILS4.get_ledger_cash_basis_flag = 'N' THEN

128: write_log(LOG,'Current Org ID is:'||G_ORG_ID);
129: End If;
130:
131: IF l_process_receipts = 'Y' THEN
132: IF PA_UTILS4.get_ledger_cash_basis_flag = 'N' THEN
133:
134: G_err_stage := 'Before calling Net Zero Ad of RCV Transctions';
135: If g_body_debug_mode = 'Y' Then
136: write_log(LOG, G_err_stage);

Line 467: IF PA_UTILS4.get_ledger_cash_basis_flag = 'N' THEN

463: G_INVOICE_SOURCE1 := p_invoice_source1;
464: G_INVOICE_SOURCE2 := p_invoice_source2;
465: G_INVOICE_SOURCE3 := p_invoice_source3;
466:
467: IF PA_UTILS4.get_ledger_cash_basis_flag = 'N' THEN
468: G_ACCTNG_METHOD := 'A';
469: --write_log(LOG,'Accounting Method is Accrual');
470: ELSE
471: G_ACCTNG_METHOD := 'C';

Line 4262: SELECT pa_utils.getweekending(MAX(expenditure_item_date))

4258: G_TRANSACTION_STATUS_CODE := 'P';
4259:
4260: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
4261: write_log(LOG, G_err_stage);
4262: SELECT pa_utils.getweekending(MAX(expenditure_item_date))
4263: INTO G_EXPENDITURE_ENDING_DATE
4264: FROM ap_invoice_distributions
4265: WHERE invoice_id = l_invoice_id_tbl(i);
4266:

Line 6483: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))

6479:
6480: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
6481: write_log(LOG, G_err_stage);
6482: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
6483: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
6484: INTO G_EXPENDITURE_ENDING_DATE
6485: FROM ap_invoice_distributions
6486: WHERE invoice_id = l_invoice_id_tbl(i);
6487:

Line 7633: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))

7629:
7630: /* Get the weekending date of the maximum expenditure item date of this PO distribution */
7631:
7632: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
7633: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
7634: INTO G_EXPENDITURE_ENDING_DATE
7635: FROM po_distributions
7636: WHERE po_distribution_id = l_po_dist_id_tbl(i);
7637:

Line 9877: SELECT pa_utils.getweekending(MAX(expenditure_item_date))

9873: G_TRANSACTION_STATUS_CODE := 'P';
9874:
9875: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
9876: write_log(LOG, G_err_stage);
9877: SELECT pa_utils.getweekending(MAX(expenditure_item_date))
9878: INTO G_EXPENDITURE_ENDING_DATE
9879: FROM ap_invoice_distributions
9880: WHERE invoice_id = l_invoice_id_tbl(i);
9881:

Line 11701: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))

11697:
11698: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
11699: write_log(LOG, G_err_stage);
11700: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
11701: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
11702: INTO G_EXPENDITURE_ENDING_DATE
11703: FROM ap_invoice_distributions
11704: WHERE invoice_id = l_invoice_id_tbl(i);
11705:

Line 13061: SELECT pa_utils.getweekending(l_ei_date_tbl(p_current_index))

13057: l_insert_flag_tbl(p_current_index) := 'U'; -- update adjustment record
13058: l_ei_date_tbl(p_current_index) := l_ei_date_tbl(l_rev_parent_dist_ind_tbl(i)); -- Set the reversal dist ei date same as parent's.
13059: write_log(LOG, 'Parent dist ='||l_rev_parent_dist_id_tbl(i)||' Child dist = '||l_rev_child_dist_id_tbl(i));
13060: /*Start changes for bug#15974243 */
13061: SELECT pa_utils.getweekending(l_ei_date_tbl(p_current_index))
13062: INTO l_exp_end_date_tbl(p_current_index)
13063: FROM dual;
13064: /*End changes for bug#15974243 */
13065: