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 3160: SELECT pa_utils.getweekending(MAX(expenditure_item_date))

3156: G_TRANSACTION_STATUS_CODE := 'P';
3157:
3158: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
3159: write_log(LOG, G_err_stage);
3160: SELECT pa_utils.getweekending(MAX(expenditure_item_date))
3161: INTO G_EXPENDITURE_ENDING_DATE
3162: FROM ap_invoice_distributions
3163: WHERE invoice_id = l_invoice_id_tbl(i);
3164:

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

5161:
5162: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
5163: write_log(LOG, G_err_stage);
5164: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
5165: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
5166: INTO G_EXPENDITURE_ENDING_DATE
5167: FROM ap_invoice_distributions
5168: WHERE invoice_id = l_invoice_id_tbl(i);
5169:

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

6171:
6172: /* Get the weekending date of the maximum expenditure item date of this PO distribution */
6173:
6174: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
6175: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
6176: INTO G_EXPENDITURE_ENDING_DATE
6177: FROM po_distributions
6178: WHERE po_distribution_id = l_po_dist_id_tbl(i);
6179:

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

8163: G_TRANSACTION_STATUS_CODE := 'P';
8164:
8165: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
8166: write_log(LOG, G_err_stage);
8167: SELECT pa_utils.getweekending(MAX(expenditure_item_date))
8168: INTO G_EXPENDITURE_ENDING_DATE
8169: FROM ap_invoice_distributions
8170: WHERE invoice_id = l_invoice_id_tbl(i);
8171:

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

9942:
9943: G_err_stage := 'GET MAX EXPENDITURE ENDING DATE';
9944: write_log(LOG, G_err_stage);
9945: /* Bug 5051103 - replace expnediture_item_date with l_ei_date_tbl(i) */
9946: SELECT pa_utils.getweekending(MAX(l_ei_date_tbl(i)))
9947: INTO G_EXPENDITURE_ENDING_DATE
9948: FROM ap_invoice_distributions
9949: WHERE invoice_id = l_invoice_id_tbl(i);
9950: