[Home] [Help]
244: ,pap1.period_name
245: INTO l_earliest_start_date
246: ,l_earliest_end_date
247: ,l_earliest_period_name
248: FROM pa_periods_all pap1
249: WHERE pap1.status IN ('O','F')
250: AND pap1.org_id = p_org_id
251: AND pap1.start_date = ( SELECT MIN(pap.start_date)
252: FROM pa_periods_all pap
248: FROM pa_periods_all pap1
249: WHERE pap1.status IN ('O','F')
250: AND pap1.org_id = p_org_id
251: AND pap1.start_date = ( SELECT MIN(pap.start_date)
252: FROM pa_periods_all pap
253: WHERE status IN ('O','F')
254: AND org_id = p_org_id
255: );
256: END IF ;
272: INTO l_start_date
273: ,l_end_date
274: ,l_pa_date
275: ,l_period_name
276: FROM pa_periods_all pap
277: WHERE pap.status in ('O','F')
278: AND pap.end_date >= TRUNC(p_expenditure_item_date)
279: AND p_accounting_date BETWEEN pap.start_date and pap.end_date
280: AND org_id = p_org_id ;
286: END; /* Added for Bug 1657231 */
287:
288: /*If the l_pa_date obtained is NULL, try to find a pa_date without the accounting-date
289: *check. This approach was used even previously.
290: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.
291: */
292:
293: IF ( l_pa_date IS NULL )
294: THEN
299: INTO l_start_date
300: ,l_end_date
301: ,l_pa_date
302: ,l_period_name
303: FROM pa_periods_all pap1
304: WHERE pap1.org_id = p_org_id /*Added While fixing bug 1657231*/
305: AND pap1.start_date = ( SELECT MIN(pap.start_date)
306: FROM pa_periods_all pap
307: WHERE status IN ('O','F')
302: ,l_period_name
303: FROM pa_periods_all pap1
304: WHERE pap1.org_id = p_org_id /*Added While fixing bug 1657231*/
305: AND pap1.start_date = ( SELECT MIN(pap.start_date)
306: FROM pa_periods_all pap
307: WHERE status IN ('O','F')
308: AND pap.start_date >= TRUNC(p_expenditure_item_date)
309: AND org_id = p_org_id
310: );
327: ,pap1.period_name
328: INTO l_earliest_start_date
329: ,l_earliest_end_date
330: ,l_earliest_period_name
331: FROM pa_periods_all pap1
332: WHERE pap1.status IN ('O', 'F')
333: AND pap1.org_id = p_org_id
334: AND pap1.end_date = ( SELECT MIN(pap.end_date)
335: FROM pa_periods_all pap
331: FROM pa_periods_all pap1
332: WHERE pap1.status IN ('O', 'F')
333: AND pap1.org_id = p_org_id
334: AND pap1.end_date = ( SELECT MIN(pap.end_date)
335: FROM pa_periods_all pap
336: WHERE pap.status IN ('O','F')
337: -- AND p_accounting_date BETWEEN pap.start_date AND pap.end_date /* commented for bug 1982225 */
338: AND pap.org_id = p_org_id
339: );
351: INTO l_start_date
352: ,l_end_date
353: ,l_pa_date
354: ,l_period_name
355: FROM pa_periods_all pap
356: WHERE status in ('O','F')
357: AND pap.end_date >= TRUNC(p_expenditure_item_date)
358: AND p_accounting_date BETWEEN pap.start_date and pap.end_date
359: AND org_id = p_org_id ;
365: END; /* Added for Bug 1657231 */
366:
367: /*If the l_pa_date obtained is NULL, try to find a pa_date without the accounting-date
368: *check. This approach was used even previously.
369: *This SQL will FAIL - if there are more than one row in pa_periods_all - with the same end_date.
370: */
371:
372: IF ( l_pa_date IS NULL )
373: THEN
378: INTO l_start_date
379: ,l_end_date
380: ,l_pa_date
381: ,l_period_name
382: FROM pa_periods_all pap1
383: WHERE pap1.end_date = ( SELECT MIN(pap.end_date)
384: FROM pa_periods_all pap
385: WHERE pap.status IN ('O','F')
386: AND pap.end_date >= TRUNC(p_expenditure_item_date)
380: ,l_pa_date
381: ,l_period_name
382: FROM pa_periods_all pap1
383: WHERE pap1.end_date = ( SELECT MIN(pap.end_date)
384: FROM pa_periods_all pap
385: WHERE pap.status IN ('O','F')
386: AND pap.end_date >= TRUNC(p_expenditure_item_date)
387: AND pap.org_id = p_org_id
388: )
671: l_pa_period_end_date DATE;
672: BEGIN
673: SELECT MIN(pap.end_date)
674: INTO l_pa_period_end_date
675: FROM pa_periods pap
676: WHERE pap.status in ( 'O', 'F')
677: AND pap.end_date >= p_raw_cdl_date;
678:
679: RETURN l_pa_period_end_date;
751: ,x_error_stage OUT NOCOPY NUMBER
752: )
753: IS
754: l_prvdr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
755: l_prvdr_pa_period_name pa_periods.period_name%TYPE;
756: l_prvdr_gl_period_name gl_periods.period_name%TYPE;
757:
758: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
759: l_recvr_pa_period_name pa_periods.period_name%TYPE;
755: l_prvdr_pa_period_name pa_periods.period_name%TYPE;
756: l_prvdr_gl_period_name gl_periods.period_name%TYPE;
757:
758: l_recvr_pa_date pa_cost_distribution_lines_all.pa_date%TYPE;
759: l_recvr_pa_period_name pa_periods.period_name%TYPE;
760: l_recvr_gl_date pa_cost_distribution_lines_all.gl_date%TYPE;
761: l_recvr_gl_period_name gl_periods.period_name%TYPE;
762:
763: l_pa_gl_app_id NUMBER := 8721;
825: IF ( l_use_same_pa_gl_period_prvdr = 'Y' )
826: THEN
827: l_stage := 300;
828: /*
829: * Copy Gl period information to Pa periods.
830: */
831: l_prvdr_pa_date := p_prvdr_gl_date;
832: l_prvdr_pa_period_name := l_prvdr_gl_period_name;
833: ELSE -- implementation option is not set
832: l_prvdr_pa_period_name := l_prvdr_gl_period_name;
833: ELSE -- implementation option is not set
834: l_stage := 400;
835: /*
836: * Get Pa periods based on ei date.
837: */
838:
839: l_prvdr_pa_date := pa_utils2.get_pa_date
840: ( p_ei_date => p_expenditure_item_date
850: IF ( l_use_same_pa_gl_period_recvr = 'Y' )
851: THEN
852: l_stage := 425;
853: /*
854: * Copy Gl period information to Pa periods.
855: */
856: l_recvr_pa_date := l_recvr_gl_date;
857: l_recvr_pa_period_name := l_recvr_gl_period_name;
858: ELSE -- implementation option is not set
857: l_recvr_pa_period_name := l_recvr_gl_period_name;
858: ELSE -- implementation option is not set
859: l_stage := 450;
860: /*
861: * Get Pa periods based on ei date.
862: */
863:
864: -- Bug 2248543 Added provider and receiver org_id check
865: if ( p_prvdr_org_id <> p_recvr_org_id ) then
877: END IF; -- implementations option
878: ELSE -- profile option is not set.
879: l_stage := 500;
880: /*
881: * Get Pa periods based on ei date.
882: */
883: l_prvdr_pa_date := pa_integration.get_raw_cdl_pa_date
884: ( p_expenditure_item_date => p_expenditure_item_date
885: ,p_accounting_date => p_prvdr_gl_date