DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CANCEL_PVT dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,

5784: p_da_call_rec IN OUT NOCOPY po_document_action_pvt.DOC_ACTION_CALL_TBL_REC_TYPE,
5785: p_key IN po_session_gt.key%TYPE,
5786: p_user_id IN po_lines.last_updated_by%TYPE,
5787: p_login_id IN po_lines.last_update_login%TYPE,
5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
5790: x_return_status OUT NOCOPY VARCHAR2,
5791: x_msg_data OUT NOCOPY VARCHAR2)
5792:

Line 5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,

5785: p_key IN po_session_gt.key%TYPE,
5786: p_user_id IN po_lines.last_updated_by%TYPE,
5787: p_login_id IN po_lines.last_update_login%TYPE,
5788: p_po_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE,
5789: p_req_enc_flag IN FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE,
5790: x_return_status OUT NOCOPY VARCHAR2,
5791: x_msg_data OUT NOCOPY VARCHAR2)
5792:
5793: IS

Line 6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;

6324: l_progress VARCHAR2(3) := '000' ;
6325: l_key po_session_gt.key%TYPE;
6326: l_user_id po_lines.last_updated_by%TYPE := -1;
6327: l_login_id po_lines.last_update_login%TYPE := -1;
6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6330:
6331: BEGIN
6332:

Line 6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;

6325: l_key po_session_gt.key%TYPE;
6326: l_user_id po_lines.last_updated_by%TYPE := -1;
6327: l_login_id po_lines.last_update_login%TYPE := -1;
6328: l_po_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.purch_encumbrance_flag%TYPE;
6329: l_req_encumbrance_flag FINANCIALS_SYSTEM_PARAMETERS.req_encumbrance_flag%TYPE;
6330:
6331: BEGIN
6332:
6333: -- Start standard API initialization

Line 6379: --Query encumbrance flags from FINANCIALS_SYSTEM_PARAMETERS

6375: ELSE
6376: l_login_id := FND_GLOBAL.LOGIN_ID;
6377: END IF;
6378:
6379: --Query encumbrance flags from FINANCIALS_SYSTEM_PARAMETERS
6380: --to validate action_date with encumbrance if necessary
6381: SELECT NVL(fsp.purch_encumbrance_flag, 'N'),
6382: NVL(fsp.req_encumbrance_flag, 'N')
6383: INTO l_po_encumbrance_flag,

Line 6385: FROM financials_system_parameters fsp;

6381: SELECT NVL(fsp.purch_encumbrance_flag, 'N'),
6382: NVL(fsp.req_encumbrance_flag, 'N')
6383: INTO l_po_encumbrance_flag,
6384: l_req_encumbrance_flag
6385: FROM financials_system_parameters fsp;
6386:
6387:
6388: IF g_debug_stmt THEN
6389: PO_DEBUG.debug_var(d_module, l_progress, 'l_po_encumbrance_flag',l_po_encumbrance_flag);