eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PA_FIN_PLAN_PUB dependencies on PA_PERIOD_PROCESS_PKG

Line 6808: AND g.application_id = pa_period_process_pkg.application_id

6804: INTO x_start_period_start_date
6805: FROM GL_PERIOD_STATUSES g
6806: ,PA_IMPLEMENTATIONS i
6807: WHERE adjustment_period_flag = 'N'
6808: AND g.application_id = pa_period_process_pkg.application_id
6809: AND g.set_of_books_id = i.set_of_books_id
6810: AND p_profile_start_date BETWEEN g.start_date AND g.end_date;
6811: EXCEPTION
6812: WHEN NO_DATA_FOUND THEN

Line 6818: AND g.application_id = pa_period_process_pkg.application_id

6814: INTO x_start_period_start_date
6815: FROM GL_PERIOD_STATUSES g
6816: ,PA_IMPLEMENTATIONS i
6817: WHERE adjustment_period_flag = 'N'
6818: AND g.application_id = pa_period_process_pkg.application_id
6819: AND g.set_of_books_id = i.set_of_books_id;
6820: END;
6821:
6822: BEGIN

Line 6829: AND g.application_id = pa_period_process_pkg.application_id

6825: INTO x_end_period_end_date
6826: FROM GL_PERIOD_STATUSES g
6827: ,PA_IMPLEMENTATIONS i
6828: WHERE adjustment_period_flag = 'N'
6829: AND g.application_id = pa_period_process_pkg.application_id
6830: AND g.set_of_books_id = i.set_of_books_id
6831: AND p_profile_end_date BETWEEN g.start_date AND g.end_date;
6832: EXCEPTION
6833: WHEN NO_DATA_FOUND THEN

Line 6839: AND g.application_id = pa_period_process_pkg.application_id

6835: INTO x_end_period_end_date--Selected the max(end_date) into x_end_period_end_date. Bug 3329002.
6836: FROM GL_PERIOD_STATUSES g
6837: ,PA_IMPLEMENTATIONS i
6838: WHERE adjustment_period_flag = 'N'
6839: AND g.application_id = pa_period_process_pkg.application_id
6840: AND g.set_of_books_id = i.set_of_books_id;
6841: END;
6842: END IF;
6843: END Get_start_and_end_dates;

Line 6909: WHERE a.application_id = pa_period_process_pkg.application_id

6905: SELECT start_date
6906: INTO l_profile_start_date
6907: FROM GL_PERIOD_STATUSES a
6908: ,PA_IMPLEMENTATIONS i
6909: WHERE a.application_id = pa_period_process_pkg.application_id
6910: AND a.set_of_books_id = i.set_of_books_id
6911: AND a.adjustment_period_flag = 'N'
6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6913: ,PA_IMPLEMENTATIONS i2

Line 6915: AND b.application_id = pa_period_process_pkg.application_id

6911: AND a.adjustment_period_flag = 'N'
6912: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6913: ,PA_IMPLEMENTATIONS i2
6914: WHERE b.adjustment_period_flag = 'N'
6915: AND b.application_id = pa_period_process_pkg.application_id
6916: AND b.set_of_books_id = i2.set_of_books_id
6917: AND a.start_date < b.start_date
6918: AND b.start_date <= p_profile_end_date);
6919: EXCEPTION

Line 6932: WHERE a.application_id = pa_period_process_pkg.application_id

6928: SELECT MIN(start_date)
6929: INTO l_profile_start_date
6930: FROM GL_PERIOD_STATUSES a
6931: ,PA_IMPLEMENTATIONS i
6932: WHERE a.application_id = pa_period_process_pkg.application_id
6933: AND a.set_of_books_id = i.set_of_books_id
6934: AND a.adjustment_period_flag = 'N';
6935: END;
6936: END IF;

Line 6998: WHERE a.application_id = pa_period_process_pkg.application_id

6994: SELECT end_date
6995: INTO l_profile_end_date
6996: FROM GL_PERIOD_STATUSES a
6997: ,PA_IMPLEMENTATIONS i
6998: WHERE a.application_id = pa_period_process_pkg.application_id
6999: AND a.set_of_books_id = i.set_of_books_id
7000: AND a.adjustment_period_flag = 'N'
7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
7002: ,PA_IMPLEMENTATIONS i2

Line 7004: AND b.application_id = pa_period_process_pkg.application_id

7000: AND a.adjustment_period_flag = 'N'
7001: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
7002: ,PA_IMPLEMENTATIONS i2
7003: WHERE b.adjustment_period_flag = 'N'
7004: AND b.application_id = pa_period_process_pkg.application_id
7005: AND b.set_of_books_id = i2.set_of_books_id
7006: AND a.start_date > b.start_date
7007: AND b.start_date >= p_profile_start_date);
7008: EXCEPTION

Line 7021: WHERE a.application_id = pa_period_process_pkg.application_id

7017: SELECT MAX(end_date)
7018: INTO l_profile_end_date
7019: FROM GL_PERIOD_STATUSES a
7020: ,PA_IMPLEMENTATIONS i
7021: WHERE a.application_id = pa_period_process_pkg.application_id
7022: AND a.set_of_books_id = i.set_of_books_id
7023: AND a.adjustment_period_flag = 'N';
7024: END;
7025:

Line 7272: WHERE a.application_id = pa_period_process_pkg.application_id

7268: SELECT count(*)
7269: INTO l_number_of_periods
7270: FROM GL_PERIOD_STATUSES a
7271: ,PA_IMPLEMENTATIONS i
7272: WHERE a.application_id = pa_period_process_pkg.application_id
7273: AND a.set_of_books_id = i.set_of_books_id
7274: AND a.adjustment_period_flag = 'N'
7275: AND start_date BETWEEN TRUNC(SYSDATE) AND l_end_date; -- Bug :- 2623941, last condition has been put for 2623941
7276: /* Bug:- 2690087, sysdate has been changed to trunc(sysdate) */

Line 7324: AND g.application_id = pa_period_process_pkg.application_id

7320: INTO l_profile_start_date
7321: FROM GL_PERIOD_STATUSES g
7322: ,PA_IMPLEMENTATIONS i
7323: WHERE adjustment_period_flag = 'N'
7324: AND g.application_id = pa_period_process_pkg.application_id
7325: AND g.set_of_books_id = i.set_of_books_id
7326: AND TRUNC(SYSDATE) BETWEEN g.start_date AND g.end_date; /* Bug:- 2690087 */
7327:
7328: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA THEN