DBA Data[Home] [Help]

APPS.PO_CORE_S dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1930: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

1926: POH.currency_code
1927: INTO x_base_currency,
1928: x_po_currency
1929: FROM PO_HEADERS_ALL POH,
1930: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
1931: GL_SETS_OF_BOOKS GSB,
1932: PO_RELEASES_ALL POR
1933: WHERE POR.po_release_id = x_object_id
1934: AND POH.po_header_id = POR.po_header_id

Line 2633: FINANCIALS_SYSTEM_PARAMS_ALL FSP,

2629: POH.currency_code
2630: INTO l_base_currency,
2631: l_po_currency
2632: FROM PO_HEADERS_ALL POH,
2633: FINANCIALS_SYSTEM_PARAMS_ALL FSP,
2634: GL_SETS_OF_BOOKS GSB,
2635: PO_RELEASES_ALL POR
2636: WHERE POR.po_release_id = p_object_id
2637: AND POH.po_header_id = POR.po_header_id

Line 5423: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;

5419:
5420: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'IS_ENCUMBRANCE_ON';
5421: l_progress VARCHAR2(3) := '000';
5422:
5423: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
5424: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
5425:
5426: l_req_encumbrance_on BOOLEAN;
5427: l_po_encumbrance_on BOOLEAN;

Line 5424: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;

5420: l_log_head CONSTANT VARCHAR2(100) := g_log_head||'IS_ENCUMBRANCE_ON';
5421: l_progress VARCHAR2(3) := '000';
5422:
5423: l_req_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.req_encumbrance_flag%TYPE;
5424: l_purch_enc_flag FINANCIALS_SYSTEM_PARAMS_ALL.purch_encumbrance_flag%TYPE;
5425:
5426: l_req_encumbrance_on BOOLEAN;
5427: l_po_encumbrance_on BOOLEAN;
5428:

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

5459: ELSE
5460:
5461: l_progress := '040';
5462: IF g_debug_stmt THEN
5463: PO_DEBUG.debug_stmt(l_log_head,l_progress,'using FINANCIALS_SYSTEM_PARAMS_ALL');
5464: END IF;
5465:
5466: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5467: INTO l_req_enc_flag, l_purch_enc_flag

Line 5468: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP

5464: END IF;
5465:
5466: SELECT FSP.req_encumbrance_flag, FSP.purch_encumbrance_flag
5467: INTO l_req_enc_flag, l_purch_enc_flag
5468: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP
5469: WHERE FSP.org_id = p_org_id
5470: ;
5471:
5472: l_progress := '050';