APPS.AP_PERIOD_CLOSE_PKG dependencies on GL_PERIOD_STATUSES

Line 4: 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.9.12010000.4 2008/12/01 13:23:28 skyadav noship $ */
3:
4: cursor c_get_period_dates (cp_period_name gl_period_statuses.period_name%type default g_period_name
5: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
6: )
7: is
8: SELECT start_date, end_date, closing_status

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

1: package body ap_period_close_pkg as
2: /* $Header: apprdclb.pls 120.9.12010000.4 2008/12/01 13:23:28 skyadav noship $ */
3:
4: cursor c_get_period_dates (cp_period_name gl_period_statuses.period_name%type default g_period_name
5: ,cp_include_adj_period gl_period_statuses.adjustment_period_flag%type default null
6: )
7: is
8: SELECT start_date, end_date, closing_status
9: FROM gl_period_statuses

Line 9: FROM gl_period_statuses

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

Line 1101: lv_closing_status gl_period_statuses.closing_status%type;

1097: select set_of_books_id ledger_id
1098: from ap_system_parameters_all
1099: where org_id = g_org_id;
1100:
1101: lv_closing_status gl_period_statuses.closing_status%type;
1102: ld_period_start_date gl_period_statuses.start_date%type;
1103: ld_period_end_date gl_period_statuses.end_date%type;
1104: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1105:

Line 1102: ld_period_start_date gl_period_statuses.start_date%type;

1098: from ap_system_parameters_all
1099: where org_id = g_org_id;
1100:
1101: lv_closing_status gl_period_statuses.closing_status%type;
1102: ld_period_start_date gl_period_statuses.start_date%type;
1103: ld_period_end_date gl_period_statuses.end_date%type;
1104: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1105:
1106: begin

Line 1103: ld_period_end_date gl_period_statuses.end_date%type;

1099: where org_id = g_org_id;
1100:
1101: lv_closing_status gl_period_statuses.closing_status%type;
1102: ld_period_start_date gl_period_statuses.start_date%type;
1103: ld_period_end_date gl_period_statuses.end_date%type;
1104: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1105:
1106: begin
1107:

Line 1104: ld_sweep_to_end_date gl_period_statuses.end_date%type;

1100:
1101: lv_closing_status gl_period_statuses.closing_status%type;
1102: ld_period_start_date gl_period_statuses.start_date%type;
1103: ld_period_end_date gl_period_statuses.end_date%type;
1104: ld_sweep_to_end_date gl_period_statuses.end_date%type;
1105:
1106: begin
1107:
1108: if g_ledger_id is null

Line 2209: lv_closing_status gl_period_statuses.closing_status%type;

2205: )
2206: is
2207:
2208: lv_dummy varchar2(3);
2209: lv_closing_status gl_period_statuses.closing_status%type;
2210: ld_sweep_to_end_date gl_period_statuses.end_date%type;
2211:
2212: begin
2213:

Line 2210: ld_sweep_to_end_date gl_period_statuses.end_date%type;

2206: is
2207:
2208: lv_dummy varchar2(3);
2209: lv_closing_status gl_period_statuses.closing_status%type;
2210: ld_sweep_to_end_date gl_period_statuses.end_date%type;
2211:
2212: begin
2213:
2214: g_debug := nvl(p_debug,'N');