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_UTILS2 dependencies on GL_PERIOD_STATUSES

Line 1293: gl_period_statuses GPS

1289:
1290: SELECT GPS.end_date
1291: INTO v_gl_per_end_dt
1292: FROM pa_cost_distribution_lines CDL,
1293: gl_period_statuses GPS
1294: WHERE GPS.application_id = 101
1295: AND GPS.set_of_books_id = l_sob_id
1296: AND GPS.adjustment_period_flag = 'N'
1297: AND CDL.expenditure_item_id = l_adj_exp_item_id

Line 1312: FROM gl_period_statuses GPS

1308: IF (l_gl_date <= v_gl_per_end_dt) THEN
1309:
1310: SELECT GPS.start_date
1311: INTO l_prvdr_accr_date
1312: FROM gl_period_statuses GPS
1313: WHERE GPS.application_id = 101
1314: AND GPS.set_of_books_id = l_sob_id
1315: AND GPS.adjustment_period_flag = 'N'
1316: AND GPS.start_date = (SELECT min(GPS1.start_date)

Line 1317: FROM gl_period_statuses GPS1

1313: WHERE GPS.application_id = 101
1314: AND GPS.set_of_books_id = l_sob_id
1315: AND GPS.adjustment_period_flag = 'N'
1316: AND GPS.start_date = (SELECT min(GPS1.start_date)
1317: FROM gl_period_statuses GPS1
1318: WHERE GPS1.application_id = 101
1319: AND GPS1.set_of_books_id = l_sob_id
1320: AND GPS1.adjustment_period_flag = 'N'
1321: AND GPS1.start_date > v_gl_per_end_dt);

Line 1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;

1758: p_set_of_books_id IN NUMBER,
1759: p_caller_flag IN VARCHAR2
1760: )
1761: IS
1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;

Line 1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;

1759: p_caller_flag IN VARCHAR2
1760: )
1761: IS
1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.

Line 1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;

1760: )
1761: IS
1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.

Line 1765: l_gl_date gl_period_statuses.start_date%TYPE;

1761: IS
1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1769:

Line 1766: l_period_name gl_period_statuses.period_name%TYPE;

1762: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1769:
1770: CURSOR c_get_gl_date (c_reference_date DATE) IS

Line 1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.

1763: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1769:
1770: CURSOR c_get_gl_date (c_reference_date DATE) IS
1771: SELECT PERIOD.start_date,

Line 1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.

1764: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1765: l_gl_date gl_period_statuses.start_date%TYPE;
1766: l_period_name gl_period_statuses.period_name%TYPE;
1767: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1768: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1769:
1770: CURSOR c_get_gl_date (c_reference_date DATE) IS
1771: SELECT PERIOD.start_date,
1772: PERIOD.end_date,

Line 1774: FROM GL_PERIOD_STATUSES PERIOD

1770: CURSOR c_get_gl_date (c_reference_date DATE) IS
1771: SELECT PERIOD.start_date,
1772: PERIOD.end_date,
1773: PERIOD.period_name
1774: FROM GL_PERIOD_STATUSES PERIOD
1775: WHERE PERIOD.application_id = p_application_id
1776: AND PERIOD.set_of_books_id = p_set_of_books_id
1777: AND PERIOD.closing_status||'' IN ('O','F')
1778: AND PERIOD.adjustment_period_flag = 'N'

Line 1792: FROM GL_PERIOD_STATUSES PERIOD

1788: ,PERIOD.period_name
1789: INTO l_earliest_start_date
1790: ,l_earliest_end_date
1791: ,l_earliest_period_name
1792: FROM GL_PERIOD_STATUSES PERIOD
1793: WHERE PERIOD.set_of_books_id = p_set_of_books_id
1794: AND PERIOD.application_id = p_application_id
1795: AND PERIOD.adjustment_period_flag = 'N'
1796: AND PERIOD.end_date = (

Line 1798: FROM GL_PERIOD_STATUSES PERIOD1

1794: AND PERIOD.application_id = p_application_id
1795: AND PERIOD.adjustment_period_flag = 'N'
1796: AND PERIOD.end_date = (
1797: SELECT MIN (PERIOD1.end_date)
1798: FROM GL_PERIOD_STATUSES PERIOD1
1799: WHERE PERIOD1.closing_status in ('O','F')
1800: AND PERIOD1.application_id = p_application_id /* Bug# 1899771 */
1801: AND PERIOD1.adjustment_period_flag = 'N' /* Bug# 1899771 */
1802: AND PERIOD1.set_of_books_id = p_set_of_books_id) ;

Line 1837: FROM GL_PERIOD_STATUSES PERIOD

1833: INTO l_start_date,
1834: l_end_date,
1835: l_gl_date,
1836: l_period_name
1837: FROM GL_PERIOD_STATUSES PERIOD
1838: WHERE PERIOD.application_id = p_application_id
1839: AND PERIOD.set_of_books_id = p_set_of_books_id
1840: AND PERIOD.effective_period_num =
1841: ( SELECT min(PERIOD1.effective_period_num)

Line 1842: FROM GL_PERIOD_STATUSES PERIOD1

1838: WHERE PERIOD.application_id = p_application_id
1839: AND PERIOD.set_of_books_id = p_set_of_books_id
1840: AND PERIOD.effective_period_num =
1841: ( SELECT min(PERIOD1.effective_period_num)
1842: FROM GL_PERIOD_STATUSES PERIOD1
1843: WHERE PERIOD1.application_id = p_application_id
1844: AND PERIOD1.set_of_books_id = p_set_of_books_id
1845: AND PERIOD1.closing_status||'' IN ('O','F')
1846: AND PERIOD1.adjustment_period_flag = 'N'

Line 1849: FROM GL_PERIOD_STATUSES PERIOD2,

1845: AND PERIOD1.closing_status||'' IN ('O','F')
1846: AND PERIOD1.adjustment_period_flag = 'N'
1847: AND PERIOD1.effective_period_num >=
1848: ( SELECT PERIOD2.effective_period_num
1849: FROM GL_PERIOD_STATUSES PERIOD2,
1850: GL_DATE_PERIOD_MAP DPM,
1851: GL_SETS_OF_BOOKS SOB
1852: WHERE SOB.set_of_books_id = p_set_of_books_id
1853: AND DPM.period_set_name = SOB.period_set_name

Line 1902: FROM GL_PERIOD_STATUSES PERIOD

1898: INTO l_gl_date
1899: ,l_start_date
1900: ,l_end_date
1901: ,l_period_name
1902: FROM GL_PERIOD_STATUSES PERIOD
1903: WHERE PERIOD.application_id = p_application_id
1904: AND PERIOD.set_of_books_id = p_set_of_books_id
1905: AND PERIOD.effective_period_num =
1906: ( SELECT min(PERIOD1.effective_period_num)

Line 1907: FROM GL_PERIOD_STATUSES PERIOD1

1903: WHERE PERIOD.application_id = p_application_id
1904: AND PERIOD.set_of_books_id = p_set_of_books_id
1905: AND PERIOD.effective_period_num =
1906: ( SELECT min(PERIOD1.effective_period_num)
1907: FROM GL_PERIOD_STATUSES PERIOD1
1908: WHERE PERIOD1.application_id = p_application_id
1909: AND PERIOD1.set_of_books_id = p_set_of_books_id
1910: AND PERIOD1.closing_status||'' IN ('O','F')
1911: AND PERIOD1.adjustment_period_flag = 'N'

Line 1914: FROM GL_PERIOD_STATUSES PERIOD2,

1910: AND PERIOD1.closing_status||'' IN ('O','F')
1911: AND PERIOD1.adjustment_period_flag = 'N'
1912: AND PERIOD1.effective_period_num >=
1913: ( SELECT PERIOD2.effective_period_num
1914: FROM GL_PERIOD_STATUSES PERIOD2,
1915: GL_DATE_PERIOD_MAP DPM,
1916: GL_SETS_OF_BOOKS SOB
1917: WHERE SOB.set_of_books_id = p_set_of_books_id
1918: AND DPM.period_set_name = SOB.period_set_name

Line 3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;

3576: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3582: l_debug_mode VARCHAR2(1);
3583:
3584: BEGIN

Line 3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;

3577: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3578:
3579: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3580: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3581: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3582: l_debug_mode VARCHAR2(1);
3583:
3584: BEGIN
3585: ---Initialize the out variables.

Line 3656: FROM GL_PERIOD_STATUSES PERIOD

3652:
3653: BEGIN
3654: SELECT PERIOD.start_date,PERIOD.end_date
3655: INTO l_org_accr_start_date,l_org_accr_end_date
3656: FROM GL_PERIOD_STATUSES PERIOD
3657: WHERE PERIOD.application_id = p_application_id
3658: AND PERIOD.set_of_books_id = p_set_of_books_id
3659: AND PERIOD.adjustment_period_flag = 'N'
3660: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

Line 3684: FROM GL_PERIOD_STATUSES PERIOD

3680:
3681: BEGIN
3682: SELECT PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status,PERIOD.period_name
3683: INTO l_rev_accr_nxt_st_dt,l_rev_accr_nxt_end_dt,l_period_status,l_period_name
3684: FROM GL_PERIOD_STATUSES PERIOD
3685: WHERE PERIOD.application_id = p_application_id
3686: AND PERIOD.set_of_books_id = p_set_of_books_id
3687: AND PERIOD.adjustment_period_flag = 'N'
3688: AND PERIOD.start_date = ( SELECT min(PERIOD.start_date)

Line 3689: FROM GL_PERIOD_STATUSES PERIOD

3685: WHERE PERIOD.application_id = p_application_id
3686: AND PERIOD.set_of_books_id = p_set_of_books_id
3687: AND PERIOD.adjustment_period_flag = 'N'
3688: AND PERIOD.start_date = ( SELECT min(PERIOD.start_date)
3689: FROM GL_PERIOD_STATUSES PERIOD
3690: WHERE PERIOD.application_id = p_application_id
3691: AND PERIOD.set_of_books_id = p_set_of_books_id
3692: AND PERIOD.adjustment_period_flag = 'N'
3693: AND PERIOD.start_date > l_org_accr_end_date);

Line 3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;

3773: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3774: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3775: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3776: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3777: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3778: l_debug_mode VARCHAR2(1);
3779: BEGIN
3780:
3781: ---Initialize the out variables.

Line 3858: FROM GL_PERIOD_STATUSES PERIOD

3854: --- Either the cache is empty or the reference date is not in the range.
3855: BEGIN
3856: SELECT PERIOD.period_name,PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status
3857: INTO l_accr_gl_period_name, l_accr_gl_period_st_dt,l_accr_gl_period_end_dt,l_period_status
3858: FROM GL_PERIOD_STATUSES PERIOD
3859: WHERE PERIOD.application_id = p_application_id
3860: AND PERIOD.set_of_books_id = p_set_of_books_id
3861: AND PERIOD.adjustment_period_flag = 'N'
3862: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

Line 5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;

5053: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5054: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5055: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5056: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5057: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5058:
5059: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5060:
5061: l_gl_app_id NUMBER := 101;

Line 5120: FROM GL_PERIOD_STATUSES PERIOD

5116: BEGIN
5117:
5118: SELECT PERIOD.period_name,PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status
5119: INTO l_gl_period_name, l_gl_period_st_dt,l_gl_period_end_dt,l_period_status
5120: FROM GL_PERIOD_STATUSES PERIOD
5121: WHERE PERIOD.application_id = l_application_id
5122: AND PERIOD.set_of_books_id = l_set_of_books_id
5123: AND PERIOD.adjustment_period_flag = 'N'
5124: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

Line 5165: FROM GL_PERIOD_STATUSES PERIOD

5161: INTO l_gl_period_st_dt,
5162: l_gl_period_end_dt,
5163: l_gl_dt,
5164: l_gl_period_name
5165: FROM GL_PERIOD_STATUSES PERIOD
5166: WHERE PERIOD.application_id = l_application_id
5167: AND PERIOD.set_of_books_id = l_set_of_books_id
5168: AND PERIOD.effective_period_num =
5169: (SELECT min(PERIOD1.effective_period_num)

Line 5170: FROM GL_PERIOD_STATUSES PERIOD1

5166: WHERE PERIOD.application_id = l_application_id
5167: AND PERIOD.set_of_books_id = l_set_of_books_id
5168: AND PERIOD.effective_period_num =
5169: (SELECT min(PERIOD1.effective_period_num)
5170: FROM GL_PERIOD_STATUSES PERIOD1
5171: WHERE PERIOD1.application_id = l_application_id
5172: AND PERIOD1.set_of_books_id = l_set_of_books_id
5173: AND PERIOD1.closing_status||'' IN ('O','F')
5174: AND PERIOD1.adjustment_period_flag = 'N'

Line 5177: FROM GL_PERIOD_STATUSES PERIOD2,

5173: AND PERIOD1.closing_status||'' IN ('O','F')
5174: AND PERIOD1.adjustment_period_flag = 'N'
5175: AND PERIOD1.effective_period_num >=
5176: (SELECT PERIOD2.effective_period_num
5177: FROM GL_PERIOD_STATUSES PERIOD2,
5178: GL_DATE_PERIOD_MAP DPM,
5179: GL_SETS_OF_BOOKS SOB
5180: WHERE SOB.set_of_books_id = l_set_of_books_id
5181: AND DPM.period_set_name = SOB.period_set_name

Line 5204: FROM GL_PERIOD_STATUSES PERIOD

5200: INTO l_gl_dt,
5201: l_gl_period_st_dt,
5202: l_gl_period_end_dt,
5203: l_gl_period_name
5204: FROM GL_PERIOD_STATUSES PERIOD
5205: WHERE PERIOD.application_id = l_application_id
5206: AND PERIOD.set_of_books_id = l_set_of_books_id
5207: AND PERIOD.effective_period_num =
5208: (SELECT min(PERIOD1.effective_period_num)

Line 5209: FROM GL_PERIOD_STATUSES PERIOD1

5205: WHERE PERIOD.application_id = l_application_id
5206: AND PERIOD.set_of_books_id = l_set_of_books_id
5207: AND PERIOD.effective_period_num =
5208: (SELECT min(PERIOD1.effective_period_num)
5209: FROM GL_PERIOD_STATUSES PERIOD1
5210: WHERE PERIOD1.application_id = l_application_id
5211: AND PERIOD1.set_of_books_id = l_set_of_books_id
5212: AND PERIOD1.closing_status||'' IN ('O','F')
5213: AND PERIOD1.adjustment_period_flag = 'N'

Line 5216: FROM GL_PERIOD_STATUSES PERIOD2,

5212: AND PERIOD1.closing_status||'' IN ('O','F')
5213: AND PERIOD1.adjustment_period_flag = 'N'
5214: AND PERIOD1.effective_period_num >=
5215: (SELECT PERIOD2.effective_period_num
5216: FROM GL_PERIOD_STATUSES PERIOD2,
5217: GL_DATE_PERIOD_MAP DPM,
5218: GL_SETS_OF_BOOKS SOB
5219: WHERE SOB.set_of_books_id = l_set_of_books_id
5220: AND DPM.period_set_name = SOB.period_set_name