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.

APPS.PA_FIN_PLAN_PUB dependencies on PA_PERIOD_PROCESS_PKG

Line 6788: AND g.application_id = pa_period_process_pkg.application_id

6784: INTO x_start_period_start_date
6785: FROM GL_PERIOD_STATUSES g
6786: ,PA_IMPLEMENTATIONS i
6787: WHERE adjustment_period_flag = 'N'
6788: AND g.application_id = pa_period_process_pkg.application_id
6789: AND g.set_of_books_id = i.set_of_books_id
6790: AND p_profile_start_date BETWEEN g.start_date AND g.end_date;
6791: EXCEPTION
6792: WHEN NO_DATA_FOUND THEN

Line 6798: AND g.application_id = pa_period_process_pkg.application_id

6794: INTO x_start_period_start_date
6795: FROM GL_PERIOD_STATUSES g
6796: ,PA_IMPLEMENTATIONS i
6797: WHERE adjustment_period_flag = 'N'
6798: AND g.application_id = pa_period_process_pkg.application_id
6799: AND g.set_of_books_id = i.set_of_books_id;
6800: END;
6801:
6802: BEGIN

Line 6809: AND g.application_id = pa_period_process_pkg.application_id

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

Line 6819: AND g.application_id = pa_period_process_pkg.application_id

6815: INTO x_end_period_end_date--Selected the max(end_date) into x_end_period_end_date. Bug 3329002.
6816: FROM GL_PERIOD_STATUSES g
6817: ,PA_IMPLEMENTATIONS i
6818: WHERE adjustment_period_flag = 'N'
6819: AND g.application_id = pa_period_process_pkg.application_id
6820: AND g.set_of_books_id = i.set_of_books_id;
6821: END;
6822: END IF;
6823: END Get_start_and_end_dates;

Line 6889: WHERE a.application_id = pa_period_process_pkg.application_id

6885: SELECT start_date
6886: INTO l_profile_start_date
6887: FROM GL_PERIOD_STATUSES a
6888: ,PA_IMPLEMENTATIONS i
6889: WHERE a.application_id = pa_period_process_pkg.application_id
6890: AND a.set_of_books_id = i.set_of_books_id
6891: AND a.adjustment_period_flag = 'N'
6892: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6893: ,PA_IMPLEMENTATIONS i2

Line 6895: AND b.application_id = pa_period_process_pkg.application_id

6891: AND a.adjustment_period_flag = 'N'
6892: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6893: ,PA_IMPLEMENTATIONS i2
6894: WHERE b.adjustment_period_flag = 'N'
6895: AND b.application_id = pa_period_process_pkg.application_id
6896: AND b.set_of_books_id = i2.set_of_books_id
6897: AND a.start_date < b.start_date
6898: AND b.start_date <= p_profile_end_date);
6899: EXCEPTION

Line 6912: WHERE a.application_id = pa_period_process_pkg.application_id

6908: SELECT MIN(start_date)
6909: INTO l_profile_start_date
6910: FROM GL_PERIOD_STATUSES a
6911: ,PA_IMPLEMENTATIONS i
6912: WHERE a.application_id = pa_period_process_pkg.application_id
6913: AND a.set_of_books_id = i.set_of_books_id
6914: AND a.adjustment_period_flag = 'N';
6915: END;
6916: END IF;

Line 6978: WHERE a.application_id = pa_period_process_pkg.application_id

6974: SELECT end_date
6975: INTO l_profile_end_date
6976: FROM GL_PERIOD_STATUSES a
6977: ,PA_IMPLEMENTATIONS i
6978: WHERE a.application_id = pa_period_process_pkg.application_id
6979: AND a.set_of_books_id = i.set_of_books_id
6980: AND a.adjustment_period_flag = 'N'
6981: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6982: ,PA_IMPLEMENTATIONS i2

Line 6984: AND b.application_id = pa_period_process_pkg.application_id

6980: AND a.adjustment_period_flag = 'N'
6981: AND 51= (SELECT COUNT(*) FROM GL_PERIOD_STATUSES b
6982: ,PA_IMPLEMENTATIONS i2
6983: WHERE b.adjustment_period_flag = 'N'
6984: AND b.application_id = pa_period_process_pkg.application_id
6985: AND b.set_of_books_id = i2.set_of_books_id
6986: AND a.start_date > b.start_date
6987: AND b.start_date >= p_profile_start_date);
6988: EXCEPTION

Line 7001: WHERE a.application_id = pa_period_process_pkg.application_id

6997: SELECT MAX(end_date)
6998: INTO l_profile_end_date
6999: FROM GL_PERIOD_STATUSES a
7000: ,PA_IMPLEMENTATIONS i
7001: WHERE a.application_id = pa_period_process_pkg.application_id
7002: AND a.set_of_books_id = i.set_of_books_id
7003: AND a.adjustment_period_flag = 'N';
7004: END;
7005:

Line 7252: WHERE a.application_id = pa_period_process_pkg.application_id

7248: SELECT count(*)
7249: INTO l_number_of_periods
7250: FROM GL_PERIOD_STATUSES a
7251: ,PA_IMPLEMENTATIONS i
7252: WHERE a.application_id = pa_period_process_pkg.application_id
7253: AND a.set_of_books_id = i.set_of_books_id
7254: AND a.adjustment_period_flag = 'N'
7255: AND start_date BETWEEN TRUNC(SYSDATE) AND l_end_date; -- Bug :- 2623941, last condition has been put for 2623941
7256: /* Bug:- 2690087, sysdate has been changed to trunc(sysdate) */

Line 7304: AND g.application_id = pa_period_process_pkg.application_id

7300: INTO l_profile_start_date
7301: FROM GL_PERIOD_STATUSES g
7302: ,PA_IMPLEMENTATIONS i
7303: WHERE adjustment_period_flag = 'N'
7304: AND g.application_id = pa_period_process_pkg.application_id
7305: AND g.set_of_books_id = i.set_of_books_id
7306: AND TRUNC(SYSDATE) BETWEEN g.start_date AND g.end_date; /* Bug:- 2690087 */
7307:
7308: ELSIF p_period_type = PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA THEN