APPS.PO_DOCUMENT_CONTROL_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 209: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;

205: l_api_version CONSTANT NUMBER := 1.0;
206: l_msg_count NUMBER;
207: l_msg_data VARCHAR2(2000);
208:
209: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
210: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
211: l_cancel_reqs_flag VARCHAR2(1) := p_cancel_reqs_flag;
212:
213: -- Apps context should be initialized, so we can get the employee id directly

Line 210: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;

206: l_msg_count NUMBER;
207: l_msg_data VARCHAR2(2000);
208:
209: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
210: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
211: l_cancel_reqs_flag VARCHAR2(1) := p_cancel_reqs_flag;
212:
213: -- Apps context should be initialized, so we can get the employee id directly
214: l_agent_id PO_HEADERS.agent_id%TYPE := FND_GLOBAL.employee_id;

Line 354: -- SQL What: Query encumbrance flags from FINANCIALS_SYSTEM_PARAMETERS

350: -- called from the HTML Document Control Page. The parameters are
351: -- already validated before calling the procedure
352: IF nvl(p_source,'NULL') <> 'HTML_CONTROL_ACTION' THEN
353:
354: -- SQL What: Query encumbrance flags from FINANCIALS_SYSTEM_PARAMETERS
355: -- SQL Why: Need to process control action with encumbrance if necessary
356: SELECT NVL(fsp.purch_encumbrance_flag, 'N'),
357: NVL(fsp.req_encumbrance_flag, 'N')
358: INTO l_po_encumbrance_flag, l_req_encumbrance_flag

Line 359: FROM financials_system_parameters fsp;

355: -- SQL Why: Need to process control action with encumbrance if necessary
356: SELECT NVL(fsp.purch_encumbrance_flag, 'N'),
357: NVL(fsp.req_encumbrance_flag, 'N')
358: INTO l_po_encumbrance_flag, l_req_encumbrance_flag
359: FROM financials_system_parameters fsp;
360:
361: -- Initialize the action date
362: init_action_date(p_api_version => 1.0,
363: p_init_msg_list => FND_API.G_FALSE,

Line 3780: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS

3776: RETURN BOOLEAN
3777: IS
3778:
3779: CURSOR l_gl_period_csr IS
3780: -- SQL What: Querying GL_PERIOD_STATUSES and FINANCIALS_SYSTEM_PARAMETERS
3781: -- SQL Why: Check if p_date is in an open GL period
3782: -- SQL Join: set_of_books_id, period_name
3783: SELECT 'In open GL period'
3784: FROM gl_period_statuses gl_ps,

Line 3786: financials_system_parameters fsp

3782: -- SQL Join: set_of_books_id, period_name
3783: SELECT 'In open GL period'
3784: FROM gl_period_statuses gl_ps,
3785: gl_period_statuses po_ps,
3786: financials_system_parameters fsp
3787: WHERE gl_ps.application_id = 101 AND
3788: gl_ps.set_of_books_id = fsp.set_of_books_id AND
3789: gl_ps.closing_status IN ('O','F') AND
3790: gl_ps.period_name = po_ps.period_name AND