APPS.PSA_UTILS dependencies on GL_PERIOD_STATUSES

Line 714: l_gl_period_status gl_period_statuses.closing_status%TYPE;

710: p_mode in varchar2
711: )
712: IS
713: l_path_name VARCHAR2(500);
714: l_gl_period_status gl_period_statuses.closing_status%TYPE;
715: l_gl_period_name gl_period_statuses.period_name%TYPE;
716: l_event_source_info xla_events_pub_pkg.t_event_source_info;
717: l_security_context xla_events_pub_pkg.t_security;
718: l_counter NUMBER;

Line 715: l_gl_period_name gl_period_statuses.period_name%TYPE;

711: )
712: IS
713: l_path_name VARCHAR2(500);
714: l_gl_period_status gl_period_statuses.closing_status%TYPE;
715: l_gl_period_name gl_period_statuses.period_name%TYPE;
716: l_event_source_info xla_events_pub_pkg.t_event_source_info;
717: l_security_context xla_events_pub_pkg.t_security;
718: l_counter NUMBER;
719: l_old_event_id NUMBER;

Line 876: FROM gl_period_statuses p

872: IF (events_rec.accounting_date IS NOT NULL) THEN
873: BEGIN
874: SELECT p.closing_status
875: INTO l_gl_period_status
876: FROM gl_period_statuses p
877: WHERE p.application_id = 101
878: AND p.set_of_books_id = l_entity_rec.ledger_id
879: AND p.adjustment_period_flag = 'N'
880: AND events_rec.accounting_date BETWEEN p.start_date AND p.end_date;

Line 1187: FROM gl_period_statuses gps

1183: IF (l_events_tab(l_counter).budgetary_flag = 'N') THEN
1184: debug_other_string(g_state_level,l_path_name, 'Updating period_name for accounting events' );
1185: UPDATE ap_invoice_distributions_all aid
1186: SET period_name = (SELECT DISTINCT gps.period_name
1187: FROM gl_period_statuses gps
1188: WHERE gps.application_id = 200
1189: AND gps.set_of_books_id = l_events_tab(l_counter).ledger_id
1190: AND nvl(gps.adjustment_period_flag, 'N') = 'N'
1191: AND l_events_tab(l_counter).gl_date BETWEEN TRUNC(gps.start_date) AND TRUNC(gps.end_date))

Line 1931: l_gl_period_status gl_period_statuses.closing_status%TYPE;

1927: p_gl_date IN DATE,
1928: p_ledger_id IN NUMBER
1929: )
1930: IS
1931: l_gl_period_status gl_period_statuses.closing_status%TYPE;
1932: l_gl_period_name gl_period_statuses.period_name%TYPE;
1933: BEGIN
1934: IF p_gl_date IS NULL THEN
1935: undo_error ('GL Date is not entered');

Line 1932: l_gl_period_name gl_period_statuses.period_name%TYPE;

1928: p_ledger_id IN NUMBER
1929: )
1930: IS
1931: l_gl_period_status gl_period_statuses.closing_status%TYPE;
1932: l_gl_period_name gl_period_statuses.period_name%TYPE;
1933: BEGIN
1934: IF p_gl_date IS NULL THEN
1935: undo_error ('GL Date is not entered');
1936: app_exception.raise_exception;

Line 1943: FROM gl_period_statuses p

1939: SELECT p.closing_status,
1940: p.period_name
1941: INTO l_gl_period_status,
1942: l_gl_period_name
1943: FROM gl_period_statuses p
1944: WHERE p.application_id = 101
1945: AND p.set_of_books_id = p_ledger_id
1946: AND p_gl_date BETWEEN p.start_date AND p.end_date
1947: AND p.adjustment_period_flag = 'N';