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.AP_PERIOD_CLOSE_PKG dependencies on GL_PERIOD_STATUSES

Line 5: cursor c_get_period_dates (cp_period_name gl_period_statuses.period_name%type default g_period_name

1: package body ap_period_close_pkg as
2: /* $Header: apprdclb.pls 120.30.12020000.3 2012/10/30 21:44:58 vinaik ship $ */
3:
4:
5: cursor c_get_period_dates (cp_period_name gl_period_statuses.period_name%type default g_period_name
6: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
7: )
8: is
9: SELECT start_date, end_date, closing_status

Line 6: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null

2: /* $Header: apprdclb.pls 120.30.12020000.3 2012/10/30 21:44:58 vinaik ship $ */
3:
4:
5: cursor c_get_period_dates (cp_period_name gl_period_statuses.period_name%type default g_period_name
6: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
7: )
8: is
9: SELECT start_date, end_date, closing_status
10: FROM gl_period_statuses

Line 10: FROM gl_period_statuses

6: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
7: )
8: is
9: SELECT start_date, end_date, closing_status
10: FROM gl_period_statuses
11: WHERE period_name = cp_period_name
12: AND application_id = G_AP_APPLICATION_ID
13: AND set_of_books_id = g_ledger_id
14: and (cp_include_adj_period is null or (nvl(adjustment_period_flag,'N') = cp_include_adj_period));

Line 90: FROM gl_period_statuses

86: g_period_status VARCHAR2(1);
87: BEGIN
88: SELECT closing_status
89: INTO g_period_status
90: FROM gl_period_statuses
91: WHERE g_period_start_date BETWEEN start_date AND end_date
92: AND g_period_end_date BETWEEN start_date AND end_date
93: AND application_id = G_AP_APPLICATION_ID
94: AND set_of_books_id = g_ledger_id;

Line 1329: lv_closing_status gl_period_statuses.closing_status%type;

1325: select set_of_books_id ledger_id
1326: from ap_system_parameters_all
1327: where org_id = g_org_id;
1328:
1329: lv_closing_status gl_period_statuses.closing_status%type;
1330: ld_period_start_date gl_period_statuses.start_date%type;
1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:

Line 1330: ld_period_start_date gl_period_statuses.start_date%type;

1326: from ap_system_parameters_all
1327: where org_id = g_org_id;
1328:
1329: lv_closing_status gl_period_statuses.closing_status%type;
1330: ld_period_start_date gl_period_statuses.start_date%type;
1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:
1334: l_min_date gl_period_statuses.start_date%type;

Line 1331: ld_period_end_date gl_period_statuses.end_date%type;

1327: where org_id = g_org_id;
1328:
1329: lv_closing_status gl_period_statuses.closing_status%type;
1330: ld_period_start_date gl_period_statuses.start_date%type;
1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:
1334: l_min_date gl_period_statuses.start_date%type;
1335: l_max_date gl_period_statuses.end_date%type;

Line 1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;

1328:
1329: lv_closing_status gl_period_statuses.closing_status%type;
1330: ld_period_start_date gl_period_statuses.start_date%type;
1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:
1334: l_min_date gl_period_statuses.start_date%type;
1335: l_max_date gl_period_statuses.end_date%type;
1336:

Line 1334: l_min_date gl_period_statuses.start_date%type;

1330: ld_period_start_date gl_period_statuses.start_date%type;
1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:
1334: l_min_date gl_period_statuses.start_date%type;
1335: l_max_date gl_period_statuses.end_date%type;
1336:
1337: begin
1338:

Line 1335: l_max_date gl_period_statuses.end_date%type;

1331: ld_period_end_date gl_period_statuses.end_date%type;
1332: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1333:
1334: l_min_date gl_period_statuses.start_date%type;
1335: l_max_date gl_period_statuses.end_date%type;
1336:
1337: begin
1338:
1339: if g_ledger_id is null

Line 1381: FROM gl_period_statuses

1377: if g_action = G_ACTION_UTR then
1378:
1379: SELECT min(start_date), max(end_date)
1380: INTO l_min_date,l_max_date
1381: FROM gl_period_statuses
1382: WHERE application_id = G_AP_APPLICATION_ID
1383: AND set_of_books_id = g_ledger_id
1384: AND closing_status in ('C','O','F');
1385:

Line 2352: lv_closing_status gl_period_statuses.closing_status%type;

2348: )
2349: is
2350:
2351: lv_dummy varchar2(3);
2352: lv_closing_status gl_period_statuses.closing_status%type;
2353: ld_sweep_to_end_date gl_period_statuses.end_date%type;
2354:
2355: l_msg_count NUMBER;
2356:

Line 2353: ld_sweep_to_end_date gl_period_statuses.end_date%type;

2349: is
2350:
2351: lv_dummy varchar2(3);
2352: lv_closing_status gl_period_statuses.closing_status%type;
2353: ld_sweep_to_end_date gl_period_statuses.end_date%type;
2354:
2355: l_msg_count NUMBER;
2356:
2357: begin