APPS.PO_RELGEN_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 81: l_req_enc_flag financials_system_parameters.req_encumbrance_flag%TYPE;

77: l_api_name CONSTANT varchar2(40) := 'CREATE_RELEASES';
78:
79: --bug2880298 start
80:
81: l_req_enc_flag financials_system_parameters.req_encumbrance_flag%TYPE;
82: l_enf_vendor_hold_flag po_system_parameters.enforce_vendor_hold_flag%TYPE;
83:
84: -- bug2880298 end
85:

Line 111: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,

107: INTO x_inventory_org_id,
108: x_expense_accrual_code,
109: l_req_enc_flag, --bug2880298
110: l_enf_vendor_hold_flag --bug2880298
111: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,
112: PO_SYSTEM_PARAMETERS POSP;
113:
114: IF SQL%NOTFOUND THEN
115: RAISE NO_DATA_FOUND;

Line 127: FINANCIALS_SYSTEM_PARAMETERS FSP

123:
124: SELECT GPS.PERIOD_NAME
125: INTO x_period_name
126: FROM GL_PERIOD_STATUSES GPS,
127: FINANCIALS_SYSTEM_PARAMETERS FSP
128: WHERE GPS.APPLICATION_ID = 101
129: AND GPS.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
130: AND GPS.ADJUSTMENT_PERIOD_FLAG = 'N'
131: AND TRUNC(SYSDATE) BETWEEN TRUNC(GPS.START_DATE)

Line 709: FROM FINANCIALS_SYSTEM_PARAMETERS;

705: BEGIN
706:
707: SELECT NVL(PURCH_ENCUMBRANCE_FLAG,'N')
708: INTO x_purch_encumbrance_flag
709: FROM FINANCIALS_SYSTEM_PARAMETERS;
710:
711: /*Bug7668178: Get the default Acceptance Required Flag value from PO System Parameters */
712:
713: SELECT Decode(acceptance_required_flag,'D','Y','Y','Y','S','Y','N')

Line 1908: FROM financials_system_parameters fsp;

1904: if(x_invoice_match_option is NULL) then
1905: /* Retrieve Invoice Match Option from Financial System Parameters */
1906: SELECT fsp.match_option
1907: INTO x_invoice_match_option
1908: FROM financials_system_parameters fsp;
1909: end if;
1910:
1911: EXCEPTION
1912: WHEN OTHERS THEN

Line 2696: FINANCIALS_SYSTEM_PARAMETERS FSP

2692: NVL(POSP.price_change_allowance/100,-1))
2693: INTO l_price_tolerance_allowed
2694: FROM MTL_SYSTEM_ITEMS MSI,
2695: PO_SYSTEM_PARAMETERS POSP,
2696: FINANCIALS_SYSTEM_PARAMETERS FSP
2697: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
2698: AND MSI.organization_id(+) = FSP.inventory_organization_id;
2699:
2700: l_progress := '008';

Line 3014: FROM FINANCIALS_SYSTEM_PARAMETERS;

3010: -- for set_of_books_id
3011:
3012: SELECT NVL(purch_encumbrance_flag,'N'), set_of_books_id
3013: INTO l_purch_enc_flag, l_sob_id
3014: FROM FINANCIALS_SYSTEM_PARAMETERS;
3015:
3016: IF l_purch_enc_flag = 'Y' THEN
3017:
3018: -- bug 3296181

Line 3131: FINANCIALS_SYSTEM_PARAMETERS FSP

3127: g_delim||l_textline,1,240)
3128: BULK COLLECT INTO l_error_messages
3129: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3130: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3131: FINANCIALS_SYSTEM_PARAMETERS FSP
3132: WHERE POR.po_release_id = x_po_release_id
3133: AND POR.po_header_id = POH.po_header_id
3134: AND POR.po_header_id = POL.po_header_id
3135: AND POL.po_line_id = PLL.po_line_id

Line 3205: FINANCIALS_SYSTEM_PARAMETERS FSP

3201: g_delim||l_textline,1,240)
3202: BULK COLLECT INTO l_error_messages
3203: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3204: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3205: FINANCIALS_SYSTEM_PARAMETERS FSP
3206: WHERE POR.po_release_id = x_po_release_id
3207: AND POR.po_header_id = POH.po_header_id
3208: AND POR.po_header_id = POL.po_header_id
3209: AND POL.po_line_id = PLL.po_line_id