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

Line 38: l_prd_name gl_periods.period_name%TYPE;

34: x_msg_count OUT NOCOPY NUMBER,
35: x_msg_data OUT NOCOPY VARCHAR2)
36:
37: IS
38: l_prd_name gl_periods.period_name%TYPE;
39: l_quarter_num gl_periods.quarter_num%TYPE;
40: l_prd_yr gl_periods.period_year%TYPE;
41: l_meaning gl_lookups.meaning%TYPE;
42: l_name_desc VARCHAR2(120);

Line 39: l_quarter_num gl_periods.quarter_num%TYPE;

35: x_msg_data OUT NOCOPY VARCHAR2)
36:
37: IS
38: l_prd_name gl_periods.period_name%TYPE;
39: l_quarter_num gl_periods.quarter_num%TYPE;
40: l_prd_yr gl_periods.period_year%TYPE;
41: l_meaning gl_lookups.meaning%TYPE;
42: l_name_desc VARCHAR2(120);
43:

Line 40: l_prd_yr gl_periods.period_year%TYPE;

36:
37: IS
38: l_prd_name gl_periods.period_name%TYPE;
39: l_quarter_num gl_periods.quarter_num%TYPE;
40: l_prd_yr gl_periods.period_year%TYPE;
41: l_meaning gl_lookups.meaning%TYPE;
42: l_name_desc VARCHAR2(120);
43:
44: l_period_type gl_periods.period_type%TYPE;

Line 44: l_period_type gl_periods.period_type%TYPE;

40: l_prd_yr gl_periods.period_year%TYPE;
41: l_meaning gl_lookups.meaning%TYPE;
42: l_name_desc VARCHAR2(120);
43:
44: l_period_type gl_periods.period_type%TYPE;
45: l_week_ending_date DATE;
46: l_init_msg_list VARCHAR2(20) := FND_API.G_TRUE;
47: l_msg_index_out INTEGER:=1;
48: l_forecast_thru_date DATE;

Line 406: gl_periods glper,

402: SELECT glper.period_name,glper.period_year,gllkups.meaning
403: INTO l_prd_name,l_prd_yr,l_meaning
404: FROM pa_implementations imp,
405: gl_sets_of_books gl,
406: gl_periods glper,
407: gl_period_statuses glst,
408: gl_lookups gllkups
409: WHERE imp.set_of_books_id = gl.set_of_books_id
410: AND gl.period_set_name = glper.period_set_name

Line 518: gl_periods glper,

514: SELECT glper.quarter_num
515: INTO l_quarter_num
516: FROM pa_implementations imp,
517: gl_sets_of_books gl,
518: gl_periods glper,
519: gl_period_statuses glst
520: WHERE imp.set_of_books_id = gl.set_of_books_id
521: AND gl.period_set_name = glper.period_set_name
522: AND gl.accounted_period_type = glper.period_type

Line 1012: gl_periods glper,

1008:
1009: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
1010: FROM pa_implementations imp,
1011: gl_sets_of_books gl,
1012: gl_periods glper,
1013: gl_period_statuses glst
1014: WHERE imp.set_of_books_id = gl.set_of_books_id
1015: AND gl.period_set_name = glper.period_set_name
1016: AND imp.pa_period_type = glper.period_type

Line 1055: gl_periods glper,

1051: ,glst.effective_period_num
1052: ,gllkups.meaning
1053: FROM pa_implementations imp,
1054: gl_sets_of_books gl,
1055: gl_periods glper,
1056: gl_period_statuses glst,
1057: gl_lookups gllkups
1058: WHERE imp.set_of_books_id = gl.set_of_books_id
1059: AND gl.period_set_name = glper.period_set_name

Line 1079: l_prd_name gl_periods.period_name%TYPE;

1075:
1076: l_default_date DATE := SYSDATE;
1077: l_forecast_thru_date DATE;
1078:
1079: l_prd_name gl_periods.period_name%TYPE;
1080: l_prd_yr gl_periods.period_year%TYPE;
1081: l_sts gl_period_statuses.closing_status%TYPE;
1082: l_mon_qtr gl_periods.quarter_num%TYPE;
1083:

Line 1080: l_prd_yr gl_periods.period_year%TYPE;

1076: l_default_date DATE := SYSDATE;
1077: l_forecast_thru_date DATE;
1078:
1079: l_prd_name gl_periods.period_name%TYPE;
1080: l_prd_yr gl_periods.period_year%TYPE;
1081: l_sts gl_period_statuses.closing_status%TYPE;
1082: l_mon_qtr gl_periods.quarter_num%TYPE;
1083:
1084: l_mon NUMBER;

Line 1082: l_mon_qtr gl_periods.quarter_num%TYPE;

1078:
1079: l_prd_name gl_periods.period_name%TYPE;
1080: l_prd_yr gl_periods.period_year%TYPE;
1081: l_sts gl_period_statuses.closing_status%TYPE;
1082: l_mon_qtr gl_periods.quarter_num%TYPE;
1083:
1084: l_mon NUMBER;
1085:
1086: l_period_type gl_periods.period_type%TYPE;

Line 1086: l_period_type gl_periods.period_type%TYPE;

1082: l_mon_qtr gl_periods.quarter_num%TYPE;
1083:
1084: l_mon NUMBER;
1085:
1086: l_period_type gl_periods.period_type%TYPE;
1087: l_week_ending_date DATE;
1088:
1089: l_period_num gl_period_statuses.effective_period_num%TYPE;
1090: l_sts_meaning gl_lookups.meaning%TYPE;

Line 1379: gl_periods glper,

1375: ,gllkups.meaning
1376: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1377: FROM pa_implementations imp,
1378: gl_sets_of_books gl,
1379: gl_periods glper,
1380: gl_period_statuses glst,
1381: gl_lookups gllkups
1382: WHERE imp.set_of_books_id = gl.set_of_books_id
1383: AND gl.period_set_name = glper.period_set_name

Line 1553: gl_periods glper,

1549: ,gllkups.meaning
1550: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1551: FROM pa_implementations imp,
1552: gl_sets_of_books gl,
1553: gl_periods glper,
1554: gl_period_statuses glst,
1555: gl_lookups gllkups
1556: WHERE imp.set_of_books_id = gl.set_of_books_id
1557: AND gl.period_set_name = glper.period_set_name