DBA Data[Home] [Help]

APPS.PO_INTERFACE_S dependencies on GL_PERIOD_STATUSES

Line 132: period_name gl_period_statuses.period_name%type,

128: po_system_parameters.user_defined_rfq_num_code%type,
129: manual_rfq_num_type po_system_parameters.manual_rfq_num_type%type,
130: ship_via_lookup_code financials_system_parameters.ship_via_lookup_code%type,
131: qty_rcv_tolerance number,
132: period_name gl_period_statuses.period_name%type,
133: acceptance_required_flag po_system_parameters.acceptance_required_flag%type); /* Bug 7518967 : Default Acceptance Required Check ER */
134:
135: --
136: TYPE po_line_id_tbl IS TABLE OF PO_LINES_ALL.po_line_id%TYPE INDEX BY PLS_INTEGER;

Line 7246: FROM GL_PERIOD_STATUSES PS1

7242:
7243: l_progress := '080';
7244: SELECT PS1.period_name
7245: INTO params.period_name
7246: FROM GL_PERIOD_STATUSES PS1
7247: , GL_PERIOD_STATUSES PS2
7248: , GL_SETS_OF_BOOKS GSOB
7249: WHERE PS1.application_id = x_gl_appl_id
7250: AND PS1.set_of_books_id = params.sob_id

Line 7247: , GL_PERIOD_STATUSES PS2

7243: l_progress := '080';
7244: SELECT PS1.period_name
7245: INTO params.period_name
7246: FROM GL_PERIOD_STATUSES PS1
7247: , GL_PERIOD_STATUSES PS2
7248: , GL_SETS_OF_BOOKS GSOB
7249: WHERE PS1.application_id = x_gl_appl_id
7250: AND PS1.set_of_books_id = params.sob_id
7251: AND PS1.adjustment_period_flag = 'N'