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_FP_WEBADI_PKG dependencies on GL_PERIODS

Line 242: period_name VARCHAR2(50),--gl_periods.period_name%TYPE,

238: /*This Record is used to store the Start Date and End Date of each Period based on the Period Mask associated
239: with the budget version.
240: */
241: TYPE periods_rec IS RECORD(sequence_number NUMBER,
242: period_name VARCHAR2(50),--gl_periods.period_name%TYPE,
243: start_date gl_periods.start_date%TYPE,
244: end_date gl_periods.end_date%TYPE);
245: --PL/SQL table created based on Record periods_rec.
246: TYPE periods_tbl IS TABLE OF periods_rec;

Line 243: start_date gl_periods.start_date%TYPE,

239: with the budget version.
240: */
241: TYPE periods_rec IS RECORD(sequence_number NUMBER,
242: period_name VARCHAR2(50),--gl_periods.period_name%TYPE,
243: start_date gl_periods.start_date%TYPE,
244: end_date gl_periods.end_date%TYPE);
245: --PL/SQL table created based on Record periods_rec.
246: TYPE periods_tbl IS TABLE OF periods_rec;
247:

Line 244: end_date gl_periods.end_date%TYPE);

240: */
241: TYPE periods_rec IS RECORD(sequence_number NUMBER,
242: period_name VARCHAR2(50),--gl_periods.period_name%TYPE,
243: start_date gl_periods.start_date%TYPE,
244: end_date gl_periods.end_date%TYPE);
245: --PL/SQL table created based on Record periods_rec.
246: TYPE periods_tbl IS TABLE OF periods_rec;
247:
248: /* End of Changes done for Bug : 4584865*/

Line 1890: FROM gl_periods gl,

1886: IS
1887: SELECT gl.start_date start_date,
1888: gl.end_date end_date,
1889: gl.period_name period_name
1890: FROM gl_periods gl,
1891: pa_implementations_all pim,
1892: gl_sets_of_books gsb
1893: WHERE gl.end_date < c_first_prd_st_dt
1894: AND gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)

Line 1911: FROM gl_periods gl,

1907: IS
1908: SELECT gl.start_date start_date,
1909: gl.end_date end_date,
1910: gl.period_name period_name
1911: FROM gl_periods gl,
1912: pa_implementations_all pim,
1913: gl_sets_of_books gsb
1914: WHERE gl.end_date > c_last_prd_en_dt
1915: AND gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)

Line 7260: FROM gl_periods gl,

7256: --log1('----- STAGE X3.5------- '|| p_version_info_rec.x_time_phased_code);
7257: --log1('----- STAGE X3.6------- '|| p_planning_end_date_tbl(l_bl_index));
7258: SELECT gl.start_date
7259: INTO l_prd_mask_st_date_tbl(1)
7260: FROM gl_periods gl,
7261: pa_implementations_all pim,
7262: gl_sets_of_books gsb
7263: WHERE pim.org_id = p_version_info_rec.x_org_id
7264: AND gsb.set_of_books_id = pim.set_of_books_id

Line 7275: FROM gl_periods gl,

7271: AND gl.end_date >=p_planning_start_date_tbl(l_bl_index);
7272:
7273: SELECT gl.end_date
7274: INTO l_prd_mask_end_date_tbl(l_prd_mask_end_date_tbl.COUNT)
7275: FROM gl_periods gl,
7276: pa_implementations_all pim,
7277: gl_sets_of_books gsb
7278: WHERE pim.org_id = p_version_info_rec.x_org_id
7279: AND gsb.set_of_books_id = pim.set_of_books_id

Line 10417: FROM gl_periods gl,

10413: gl.end_Date end_date,
10414: gl.period_name period_name,
10415: gl.period_set_name period_set_name,
10416: gl.period_type period_type
10417: FROM gl_periods gl,
10418: pa_implementations_all pim,
10419: gl_sets_of_books gsb
10420: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10421: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)

Line 10432: FROM gl_periods gl,

10428: gl.end_Date end_date,
10429: gl.period_name period_name,
10430: gl.period_set_name period_set_name,
10431: gl.period_type period_type
10432: FROM gl_periods gl,
10433: pa_implementations_all pim,
10434: gl_sets_of_books gsb
10435: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10436: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)

Line 10447: FROM gl_periods gl,

10443: gl.end_Date end_date,
10444: gl.period_name period_name,
10445: gl.period_set_name period_set_name,
10446: gl.period_type period_type
10447: FROM gl_periods gl,
10448: pa_implementations_all pim,
10449: gl_sets_of_books gsb
10450: WHERE gl.period_set_name = DECODE(c_time_phased_code,'P',pim.period_set_name,'G',gsb.period_set_name)
10451: AND gl.period_type = DECODE(c_time_phased_code,'P',pim.pa_period_type,'G',gsb.accounted_period_type)

Line 11834: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,

11830: FROM pa_implementations_all
11831: WHERE org_id = c_org_id;
11832:
11833: --This Cursor is used to get period information based on the Time Phasing of the budget version.
11834: CURSOR period_grouping_cur(c_period_set_name gl_periods.period_set_name%TYPE,
11835: c_set_of_books_id gl_sets_of_books.set_of_books_id%TYPE,
11836: c_org_id pa_implementations_all.org_id%TYPE,
11837: c_pa_period_type pa_implementations_all.pa_period_type%TYPE,
11838: c_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE)

Line 11848: FROM gl_periods gl,

11844: gl.period_type period_type,
11845: gl.period_set_name period_set_name,
11846: gsb.accounted_period_type accounted_period_type,
11847: c_org_id
11848: FROM gl_periods gl,
11849: gl_sets_of_books gsb
11850: WHERE gl.period_set_name=decode(c_time_phased_code,'P',c_period_set_name,'G',gsb.period_set_name)
11851: AND gsb.set_of_books_id=c_set_of_books_id
11852: AND gl.ADJUSTMENT_PERIOD_FLAG ='N'

Line 11873: period_name VARCHAR2(50); --gl_periods.period_name%TYPE;

11869: l_periods_rec periods_rec;
11870: glcp_rownum NUMBER;
11871: glsd_rownum NUMBER;
11872: gled_rownum NUMBER;
11873: period_name VARCHAR2(50); --gl_periods.period_name%TYPE;
11874: start_date gl_periods.start_date%TYPE;
11875: end_date gl_periods.end_date%TYPE;
11876: x NUMBER := 1;
11877: BEGIN

Line 11874: start_date gl_periods.start_date%TYPE;

11870: glcp_rownum NUMBER;
11871: glsd_rownum NUMBER;
11872: gled_rownum NUMBER;
11873: period_name VARCHAR2(50); --gl_periods.period_name%TYPE;
11874: start_date gl_periods.start_date%TYPE;
11875: end_date gl_periods.end_date%TYPE;
11876: x NUMBER := 1;
11877: BEGIN
11878: x_msg_count := 0;

Line 11875: end_date gl_periods.end_date%TYPE;

11871: glsd_rownum NUMBER;
11872: gled_rownum NUMBER;
11873: period_name VARCHAR2(50); --gl_periods.period_name%TYPE;
11874: start_date gl_periods.start_date%TYPE;
11875: end_date gl_periods.end_date%TYPE;
11876: x NUMBER := 1;
11877: BEGIN
11878: x_msg_count := 0;
11879: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 11965: --Period Informations are got from gl_periods table and stored in a pl/sql table.

11961: OPEN pa_impl_cur(p_org_id);
11962: FETCH pa_impl_cur INTO l_pa_impl_rec;
11963: CLOSE pa_impl_cur;
11964:
11965: --Period Informations are got from gl_periods table and stored in a pl/sql table.
11966: FOR rec in period_grouping_cur(l_pa_impl_rec.period_set_name,
11967: l_pa_impl_rec.set_of_books_id,
11968: l_pa_impl_rec.org_id,
11969: l_pa_impl_rec.pa_period_type,