DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 2062: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

2058: POH.currency_code
2059: INTO x_base_currency,
2060: x_po_currency
2061: FROM PO_HEADERS_ALL POH,
2062: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2063: GL_SETS_OF_BOOKS GSB,
2064: PO_RELEASES_ALL POR
2065: WHERE POR.po_release_id = x_object_id
2066: AND POH.po_header_id = POR.po_header_id

Line 2765: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

2761: POH.currency_code
2762: INTO l_base_currency,
2763: l_po_currency
2764: FROM PO_HEADERS_ALL POH,
2765: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2766: GL_SETS_OF_BOOKS GSB,
2767: PO_RELEASES_ALL POR
2768: WHERE POR.po_release_id = p_object_id
2769: AND POH.po_header_id = POR.po_header_id

Line 5631: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;

5627:
5628: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'IS_ENCUMBRANCE_ON';
5629: l_progress VARCHAR2(3) := '000';
5630:
5631: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
5632: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
5633:
5634: l_req_encumbrance_on BOOLEAN;
5635: l_po_encumbrance_on BOOLEAN;

Line 5632: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

5628: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'IS_ENCUMBRANCE_ON';
5629: l_progress VARCHAR2(3) := '000';
5630:
5631: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
5632: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
5633:
5634: l_req_encumbrance_on BOOLEAN;
5635: l_po_encumbrance_on BOOLEAN;
5636:

Line 5671: PO_DEBUG.debug_stmt(l_log_head,l_progress,'using FINANCIALS_SYSTEM_PARAMS_ALL');

5667: ELSE
5668:
5669: l_progress := '040';
5670: IF g_debug_stmt THEN
5671: PO_DEBUG.debug_stmt(l_log_head,l_progress,'using FINANCIALS_SYSTEM_PARAMS_ALL');
5672: END IF;
5673:
5674: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5675: INTO l_req_enc_flag, l_purch_enc_flag

Line 5676: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP

5672: END IF;
5673:
5674: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5675: INTO l_req_enc_flag, l_purch_enc_flag
5676: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP
5677: WHERE FSP.org_id = p_org_id
5678: ;
5679:
5680: l_progress := '050';