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 1277: gl_period_statuses GPS

1273:
1274: SELECT GPS.end_date
1275: INTO v_gl_per_end_dt
1276: FROM pa_cost_distribution_lines CDL,
1277: gl_period_statuses GPS
1278: WHERE GPS.application_id = 101
1279: AND GPS.set_of_books_id = l_sob_id
1280: AND GPS.adjustment_period_flag = 'N'
1281: AND CDL.expenditure_item_id = l_adj_exp_item_id

Line 1296: FROM gl_period_statuses GPS

1292: IF (l_gl_date <= v_gl_per_end_dt) THEN
1293:
1294: SELECT GPS.start_date
1295: INTO l_prvdr_accr_date
1296: FROM gl_period_statuses GPS
1297: WHERE GPS.application_id = 101
1298: AND GPS.set_of_books_id = l_sob_id
1299: AND GPS.adjustment_period_flag = 'N'
1300: AND GPS.start_date = (SELECT min(GPS1.start_date)

Line 1301: FROM gl_period_statuses GPS1

1297: WHERE GPS.application_id = 101
1298: AND GPS.set_of_books_id = l_sob_id
1299: AND GPS.adjustment_period_flag = 'N'
1300: AND GPS.start_date = (SELECT min(GPS1.start_date)
1301: FROM gl_period_statuses GPS1
1302: WHERE GPS1.application_id = 101
1303: AND GPS1.set_of_books_id = l_sob_id
1304: AND GPS1.adjustment_period_flag = 'N'
1305: AND GPS1.start_date > v_gl_per_end_dt);

Line 1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;

1742: p_set_of_books_id IN NUMBER,
1743: p_caller_flag IN VARCHAR2
1744: )
1745: IS
1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;

Line 1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;

1743: p_caller_flag IN VARCHAR2
1744: )
1745: IS
1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.

Line 1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;

1744: )
1745: IS
1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1752: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.

Line 1749: l_gl_date gl_period_statuses.start_date%TYPE;

1745: IS
1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1752: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1753:

Line 1750: l_period_name gl_period_statuses.period_name%TYPE;

1746: l_earliest_start_date gl_period_statuses.start_date%TYPE;
1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1752: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1753:
1754: CURSOR c_get_gl_date (c_reference_date DATE) IS

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

1747: l_earliest_end_date gl_period_statuses.end_date%TYPE;
1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1752: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1753:
1754: CURSOR c_get_gl_date (c_reference_date DATE) IS
1755: SELECT PERIOD.start_date,

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

1748: l_earliest_period_name gl_period_statuses.period_name%TYPE;
1749: l_gl_date gl_period_statuses.start_date%TYPE;
1750: l_period_name gl_period_statuses.period_name%TYPE;
1751: l_start_date gl_period_statuses.start_date%TYPE; -- start date for the l_gl_date.
1752: l_end_date gl_period_statuses.start_date%TYPE; -- end date for the l_gl_date.
1753:
1754: CURSOR c_get_gl_date (c_reference_date DATE) IS
1755: SELECT PERIOD.start_date,
1756: PERIOD.end_date,

Line 1758: FROM GL_PERIOD_STATUSES PERIOD

1754: CURSOR c_get_gl_date (c_reference_date DATE) IS
1755: SELECT PERIOD.start_date,
1756: PERIOD.end_date,
1757: PERIOD.period_name
1758: FROM GL_PERIOD_STATUSES PERIOD
1759: WHERE PERIOD.application_id = p_application_id
1760: AND PERIOD.set_of_books_id = p_set_of_books_id
1761: AND PERIOD.closing_status||'' IN ('O','F')
1762: AND PERIOD.adjustment_period_flag = 'N'

Line 1775: FROM GL_PERIOD_STATUSES PERIOD

1771: ,PERIOD.period_name
1772: INTO l_earliest_start_date
1773: ,l_earliest_end_date
1774: ,l_earliest_period_name
1775: FROM GL_PERIOD_STATUSES PERIOD
1776: WHERE PERIOD.set_of_books_id = p_set_of_books_id
1777: AND PERIOD.application_id = p_application_id
1778: AND PERIOD.adjustment_period_flag = 'N'
1779: AND PERIOD.end_date = (

Line 1781: FROM GL_PERIOD_STATUSES PERIOD1

1777: AND PERIOD.application_id = p_application_id
1778: AND PERIOD.adjustment_period_flag = 'N'
1779: AND PERIOD.end_date = (
1780: SELECT MIN (PERIOD1.end_date)
1781: FROM GL_PERIOD_STATUSES PERIOD1
1782: WHERE PERIOD1.closing_status in ('O','F')
1783: AND PERIOD1.application_id = p_application_id /* Bug# 1899771 */
1784: AND PERIOD1.adjustment_period_flag = 'N' /* Bug# 1899771 */
1785: AND PERIOD1.set_of_books_id = p_set_of_books_id) ;

Line 1820: FROM GL_PERIOD_STATUSES PERIOD

1816: INTO l_start_date,
1817: l_end_date,
1818: l_gl_date,
1819: l_period_name
1820: FROM GL_PERIOD_STATUSES PERIOD
1821: WHERE PERIOD.application_id = p_application_id
1822: AND PERIOD.set_of_books_id = p_set_of_books_id
1823: AND PERIOD.effective_period_num =
1824: ( SELECT min(PERIOD1.effective_period_num)

Line 1825: FROM GL_PERIOD_STATUSES PERIOD1

1821: WHERE PERIOD.application_id = p_application_id
1822: AND PERIOD.set_of_books_id = p_set_of_books_id
1823: AND PERIOD.effective_period_num =
1824: ( SELECT min(PERIOD1.effective_period_num)
1825: FROM GL_PERIOD_STATUSES PERIOD1
1826: WHERE PERIOD1.application_id = p_application_id
1827: AND PERIOD1.set_of_books_id = p_set_of_books_id
1828: AND PERIOD1.closing_status||'' IN ('O','F')
1829: AND PERIOD1.adjustment_period_flag = 'N'

Line 1832: FROM GL_PERIOD_STATUSES PERIOD2,

1828: AND PERIOD1.closing_status||'' IN ('O','F')
1829: AND PERIOD1.adjustment_period_flag = 'N'
1830: AND PERIOD1.effective_period_num >=
1831: ( SELECT PERIOD2.effective_period_num
1832: FROM GL_PERIOD_STATUSES PERIOD2,
1833: GL_DATE_PERIOD_MAP DPM,
1834: GL_SETS_OF_BOOKS SOB
1835: WHERE SOB.set_of_books_id = p_set_of_books_id
1836: AND DPM.period_set_name = SOB.period_set_name

Line 1885: FROM GL_PERIOD_STATUSES PERIOD

1881: INTO l_gl_date
1882: ,l_start_date
1883: ,l_end_date
1884: ,l_period_name
1885: FROM GL_PERIOD_STATUSES PERIOD
1886: WHERE PERIOD.application_id = p_application_id
1887: AND PERIOD.set_of_books_id = p_set_of_books_id
1888: AND PERIOD.effective_period_num =
1889: ( SELECT min(PERIOD1.effective_period_num)

Line 1890: FROM GL_PERIOD_STATUSES PERIOD1

1886: WHERE PERIOD.application_id = p_application_id
1887: AND PERIOD.set_of_books_id = p_set_of_books_id
1888: AND PERIOD.effective_period_num =
1889: ( SELECT min(PERIOD1.effective_period_num)
1890: FROM GL_PERIOD_STATUSES PERIOD1
1891: WHERE PERIOD1.application_id = p_application_id
1892: AND PERIOD1.set_of_books_id = p_set_of_books_id
1893: AND PERIOD1.closing_status||'' IN ('O','F')
1894: AND PERIOD1.adjustment_period_flag = 'N'

Line 1897: FROM GL_PERIOD_STATUSES PERIOD2,

1893: AND PERIOD1.closing_status||'' IN ('O','F')
1894: AND PERIOD1.adjustment_period_flag = 'N'
1895: AND PERIOD1.effective_period_num >=
1896: ( SELECT PERIOD2.effective_period_num
1897: FROM GL_PERIOD_STATUSES PERIOD2,
1898: GL_DATE_PERIOD_MAP DPM,
1899: GL_SETS_OF_BOOKS SOB
1900: WHERE SOB.set_of_books_id = p_set_of_books_id
1901: AND DPM.period_set_name = SOB.period_set_name

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

3538: l_rev_accr_nxt_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3542: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3543: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3544: l_debug_mode VARCHAR2(1);
3545:
3546: BEGIN

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

3539: l_rev_accr_nxt_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3540:
3541: l_rev_accr_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3542: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
3543: l_period_name gl_period_statuses.period_name%TYPE := NULL;
3544: l_debug_mode VARCHAR2(1);
3545:
3546: BEGIN
3547: ---Initialize the out variables.

Line 3618: FROM GL_PERIOD_STATUSES PERIOD

3614:
3615: BEGIN
3616: SELECT PERIOD.start_date,PERIOD.end_date
3617: INTO l_org_accr_start_date,l_org_accr_end_date
3618: FROM GL_PERIOD_STATUSES PERIOD
3619: WHERE PERIOD.application_id = p_application_id
3620: AND PERIOD.set_of_books_id = p_set_of_books_id
3621: AND PERIOD.adjustment_period_flag = 'N'
3622: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

Line 3646: FROM GL_PERIOD_STATUSES PERIOD

3642:
3643: BEGIN
3644: SELECT PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status,PERIOD.period_name
3645: INTO l_rev_accr_nxt_st_dt,l_rev_accr_nxt_end_dt,l_period_status,l_period_name
3646: FROM GL_PERIOD_STATUSES PERIOD
3647: WHERE PERIOD.application_id = p_application_id
3648: AND PERIOD.set_of_books_id = p_set_of_books_id
3649: AND PERIOD.adjustment_period_flag = 'N'
3650: AND PERIOD.start_date = ( SELECT min(PERIOD.start_date)

Line 3651: FROM GL_PERIOD_STATUSES PERIOD

3647: WHERE PERIOD.application_id = p_application_id
3648: AND PERIOD.set_of_books_id = p_set_of_books_id
3649: AND PERIOD.adjustment_period_flag = 'N'
3650: AND PERIOD.start_date = ( SELECT min(PERIOD.start_date)
3651: FROM GL_PERIOD_STATUSES PERIOD
3652: WHERE PERIOD.application_id = p_application_id
3653: AND PERIOD.set_of_books_id = p_set_of_books_id
3654: AND PERIOD.adjustment_period_flag = 'N'
3655: AND PERIOD.start_date > l_org_accr_end_date);

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

3735: l_accr_gl_period_name pa_cost_distribution_lines_all.pa_period_name%TYPE := NULL;
3736: l_accr_gl_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3737: l_accr_gl_period_st_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3738: l_accr_gl_period_end_dt pa_cost_distribution_lines_all.gl_date%TYPE := NULL;
3739: l_period_status gl_period_statuses.closing_status%TYPE :=NULL;
3740: l_debug_mode VARCHAR2(1);
3741: BEGIN
3742:
3743: ---Initialize the out variables.

Line 3820: FROM GL_PERIOD_STATUSES PERIOD

3816: --- Either the cache is empty or the reference date is not in the range.
3817: BEGIN
3818: SELECT PERIOD.period_name,PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status
3819: INTO l_accr_gl_period_name, l_accr_gl_period_st_dt,l_accr_gl_period_end_dt,l_period_status
3820: FROM GL_PERIOD_STATUSES PERIOD
3821: WHERE PERIOD.application_id = p_application_id
3822: AND PERIOD.set_of_books_id = p_set_of_books_id
3823: AND PERIOD.adjustment_period_flag = 'N'
3824: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

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

5015: l_gl_period_name pa_draft_revenues_all.gl_period_name%TYPE := NULL;
5016: l_gl_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5017: l_gl_period_st_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5018: l_gl_period_end_dt pa_draft_revenues_all.gl_date%TYPE := NULL;
5019: l_period_status gl_period_statuses.closing_status%TYPE := NULL;
5020:
5021: l_set_of_books_id pa_implementations_all.set_of_books_id%TYPE;
5022:
5023: l_gl_app_id NUMBER := 101;

Line 5082: FROM GL_PERIOD_STATUSES PERIOD

5078: BEGIN
5079:
5080: SELECT PERIOD.period_name,PERIOD.start_date,PERIOD.end_date,PERIOD.closing_status
5081: INTO l_gl_period_name, l_gl_period_st_dt,l_gl_period_end_dt,l_period_status
5082: FROM GL_PERIOD_STATUSES PERIOD
5083: WHERE PERIOD.application_id = l_application_id
5084: AND PERIOD.set_of_books_id = l_set_of_books_id
5085: AND PERIOD.adjustment_period_flag = 'N'
5086: AND trunc(p_reference_date) BETWEEN PERIOD.start_date and PERIOD.end_date;

Line 5127: FROM GL_PERIOD_STATUSES PERIOD

5123: INTO l_gl_period_st_dt,
5124: l_gl_period_end_dt,
5125: l_gl_dt,
5126: l_gl_period_name
5127: FROM GL_PERIOD_STATUSES PERIOD
5128: WHERE PERIOD.application_id = l_application_id
5129: AND PERIOD.set_of_books_id = l_set_of_books_id
5130: AND PERIOD.effective_period_num =
5131: (SELECT min(PERIOD1.effective_period_num)

Line 5132: FROM GL_PERIOD_STATUSES PERIOD1

5128: WHERE PERIOD.application_id = l_application_id
5129: AND PERIOD.set_of_books_id = l_set_of_books_id
5130: AND PERIOD.effective_period_num =
5131: (SELECT min(PERIOD1.effective_period_num)
5132: FROM GL_PERIOD_STATUSES PERIOD1
5133: WHERE PERIOD1.application_id = l_application_id
5134: AND PERIOD1.set_of_books_id = l_set_of_books_id
5135: AND PERIOD1.closing_status||'' IN ('O','F')
5136: AND PERIOD1.adjustment_period_flag = 'N'

Line 5139: FROM GL_PERIOD_STATUSES PERIOD2,

5135: AND PERIOD1.closing_status||'' IN ('O','F')
5136: AND PERIOD1.adjustment_period_flag = 'N'
5137: AND PERIOD1.effective_period_num >=
5138: (SELECT PERIOD2.effective_period_num
5139: FROM GL_PERIOD_STATUSES PERIOD2,
5140: GL_DATE_PERIOD_MAP DPM,
5141: GL_SETS_OF_BOOKS SOB
5142: WHERE SOB.set_of_books_id = l_set_of_books_id
5143: AND DPM.period_set_name = SOB.period_set_name

Line 5166: FROM GL_PERIOD_STATUSES PERIOD

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

Line 5171: FROM GL_PERIOD_STATUSES PERIOD1

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

Line 5178: FROM GL_PERIOD_STATUSES PERIOD2,

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