DBA Data[Home] [Help]

APPS.PO_RELGEN_PKG dependencies on FINANCIALS_SYSTEM_PARAMETERS

Line 80: l_req_enc_flag financials_system_parameters.req_encumbrance_flag%TYPE;

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

Line 110: FROM FINANCIALS_SYSTEM_PARAMETERS FSP,

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

Line 126: FINANCIALS_SYSTEM_PARAMETERS FSP

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

Line 707: FROM FINANCIALS_SYSTEM_PARAMETERS;

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

Line 1883: FROM financials_system_parameters fsp;

1879: if(x_invoice_match_option is NULL) then
1880: /* Retrieve Invoice Match Option from Financial System Parameters */
1881: SELECT fsp.match_option
1882: INTO x_invoice_match_option
1883: FROM financials_system_parameters fsp;
1884: end if;
1885:
1886: EXCEPTION
1887: WHEN OTHERS THEN

Line 2671: FINANCIALS_SYSTEM_PARAMETERS FSP

2667: NVL(POSP.price_change_allowance/100,-1))
2668: INTO l_price_tolerance_allowed
2669: FROM MTL_SYSTEM_ITEMS MSI,
2670: PO_SYSTEM_PARAMETERS POSP,
2671: FINANCIALS_SYSTEM_PARAMETERS FSP
2672: WHERE msi.inventory_item_id(+) = l_item_id(shipment_line)
2673: AND MSI.organization_id(+) = FSP.inventory_organization_id;
2674:
2675: l_progress := '008';

Line 2960: FROM FINANCIALS_SYSTEM_PARAMETERS;

2956: -- for set_of_books_id
2957:
2958: SELECT NVL(purch_encumbrance_flag,'N'), set_of_books_id
2959: INTO l_purch_enc_flag, l_sob_id
2960: FROM FINANCIALS_SYSTEM_PARAMETERS;
2961:
2962: IF l_purch_enc_flag = 'Y' THEN
2963:
2964: -- bug 3296181

Line 3077: FINANCIALS_SYSTEM_PARAMETERS FSP

3073: g_delim||l_textline,1,240)
3074: BULK COLLECT INTO l_error_messages
3075: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3076: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3077: FINANCIALS_SYSTEM_PARAMETERS FSP
3078: WHERE POR.po_release_id = x_po_release_id
3079: AND POR.po_header_id = POH.po_header_id
3080: AND POR.po_header_id = POL.po_header_id
3081: AND POL.po_line_id = PLL.po_line_id

Line 3151: FINANCIALS_SYSTEM_PARAMETERS FSP

3147: g_delim||l_textline,1,240)
3148: BULK COLLECT INTO l_error_messages
3149: FROM MTL_SYSTEM_ITEMS MSI, PO_LINE_LOCATIONS PLL,
3150: PO_RELEASES POR,PO_LINES POL, PO_HEADERS POH,
3151: FINANCIALS_SYSTEM_PARAMETERS FSP
3152: WHERE POR.po_release_id = x_po_release_id
3153: AND POR.po_header_id = POH.po_header_id
3154: AND POR.po_header_id = POL.po_header_id
3155: AND POL.po_line_id = PLL.po_line_id