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 373: gl_periods glper,

369: SELECT glper.period_name,glper.period_year,gllkups.meaning
370: INTO l_prd_name,l_prd_yr,l_meaning
371: FROM pa_implementations imp,
372: gl_sets_of_books gl,
373: gl_periods glper,
374: gl_period_statuses glst,
375: gl_lookups gllkups
376: WHERE imp.set_of_books_id = gl.set_of_books_id
377: AND gl.period_set_name = glper.period_set_name

Line 485: gl_periods glper,

481: SELECT glper.quarter_num
482: INTO l_quarter_num
483: FROM pa_implementations imp,
484: gl_sets_of_books gl,
485: gl_periods glper,
486: gl_period_statuses glst
487: WHERE imp.set_of_books_id = gl.set_of_books_id
488: AND gl.period_set_name = glper.period_set_name
489: AND gl.accounted_period_type = glper.period_type

Line 979: gl_periods glper,

975:
976: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
977: FROM pa_implementations imp,
978: gl_sets_of_books gl,
979: gl_periods glper,
980: gl_period_statuses glst
981: WHERE imp.set_of_books_id = gl.set_of_books_id
982: AND gl.period_set_name = glper.period_set_name
983: AND imp.pa_period_type = glper.period_type

Line 1019: gl_periods glper,

1015: ,glst.effective_period_num
1016: ,gllkups.meaning
1017: FROM pa_implementations imp,
1018: gl_sets_of_books gl,
1019: gl_periods glper,
1020: gl_period_statuses glst,
1021: gl_lookups gllkups
1022: WHERE imp.set_of_books_id = gl.set_of_books_id
1023: AND gl.period_set_name = glper.period_set_name

Line 1043: l_prd_name gl_periods.period_name%TYPE;

1039:
1040: l_default_date DATE := SYSDATE;
1041: l_forecast_thru_date DATE;
1042:
1043: l_prd_name gl_periods.period_name%TYPE;
1044: l_prd_yr gl_periods.period_year%TYPE;
1045: l_sts gl_period_statuses.closing_status%TYPE;
1046: l_mon_qtr gl_periods.quarter_num%TYPE;
1047:

Line 1044: l_prd_yr gl_periods.period_year%TYPE;

1040: l_default_date DATE := SYSDATE;
1041: l_forecast_thru_date DATE;
1042:
1043: l_prd_name gl_periods.period_name%TYPE;
1044: l_prd_yr gl_periods.period_year%TYPE;
1045: l_sts gl_period_statuses.closing_status%TYPE;
1046: l_mon_qtr gl_periods.quarter_num%TYPE;
1047:
1048: l_mon NUMBER;

Line 1046: l_mon_qtr gl_periods.quarter_num%TYPE;

1042:
1043: l_prd_name gl_periods.period_name%TYPE;
1044: l_prd_yr gl_periods.period_year%TYPE;
1045: l_sts gl_period_statuses.closing_status%TYPE;
1046: l_mon_qtr gl_periods.quarter_num%TYPE;
1047:
1048: l_mon NUMBER;
1049:
1050: l_period_type gl_periods.period_type%TYPE;

Line 1050: l_period_type gl_periods.period_type%TYPE;

1046: l_mon_qtr gl_periods.quarter_num%TYPE;
1047:
1048: l_mon NUMBER;
1049:
1050: l_period_type gl_periods.period_type%TYPE;
1051: l_week_ending_date DATE;
1052:
1053: l_period_num gl_period_statuses.effective_period_num%TYPE;
1054: l_sts_meaning gl_lookups.meaning%TYPE;

Line 1331: gl_periods glper,

1327: ,gllkups.meaning
1328: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1329: FROM pa_implementations imp,
1330: gl_sets_of_books gl,
1331: gl_periods glper,
1332: gl_period_statuses glst,
1333: gl_lookups gllkups
1334: WHERE imp.set_of_books_id = gl.set_of_books_id
1335: AND gl.period_set_name = glper.period_set_name

Line 1490: gl_periods glper,

1486: ,gllkups.meaning
1487: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1488: FROM pa_implementations imp,
1489: gl_sets_of_books gl,
1490: gl_periods glper,
1491: gl_period_statuses glst,
1492: gl_lookups gllkups
1493: WHERE imp.set_of_books_id = gl.set_of_books_id
1494: AND gl.period_set_name = glper.period_set_name