APPS.PO_RCO_VALIDATION_PVT dependencies on FND_PROFILE

Line 15: g_fnd_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');

11: g_debug_stmt CONSTANT BOOLEAN := po_debug.is_debug_stmt_on;
12: g_debug_unexp CONSTANT BOOLEAN := po_debug.is_debug_unexp_on;
13:
14: g_module_prefix CONSTANT VARCHAR2(50) := 'po.plsql.' || g_pkg_name || '.';
15: g_fnd_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');
16:
17:
18: -- Initializing Private Functions/Procedures
19: TYPE number_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;

Line 142: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');

138: AND prla.requisition_line_id = pcr.document_line_id
139: AND prla.blanket_po_header_id IS NOT NULL;
140:
141: BEGIN
142: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');
143:
144: l_req_user_id := fnd_global.user_id;
145:
146: OPEN l_linepricebreak_csr(p_chn_grp_id);

Line 3306: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');

3302: p_cancellable_flag := 'Y';
3303:
3304: l_progress := '000';
3305:
3306: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');
3307:
3308: SELECT
3309: prla.purchase_basis,
3310: prla.line_location_id,

Line 3475: l_price_updateable := fnd_profile.value('POR_ALLOW_PRICE_UPDATE');

3471: --In the following validation,
3472: --#1-#6 are shared by different type of requisition lines: GOODS, TEMP LABOR, SERVICES
3473: --#7-#11 are only for GOODS
3474: -- bug 13983258: able to edit price for catalog items based on profile
3475: l_price_updateable := fnd_profile.value('POR_ALLOW_PRICE_UPDATE');
3476: --Is there an internal order associated with line?(Validation #2 in DLD)
3477: IF (l_source_type_code = 'INVENTORY') THEN
3478: l_line_changeable_flag := 'N';
3479:

Line 4517: AND (( (nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'Y'

4513: AND GL_PS.period_name = PO_PS.period_name
4514: -- GL period conditions:
4515: AND GL_PS.application_id = 101
4516: -- bug 5206339 <11.5.10 GL PERIOD VALIDATION>
4517: AND (( (nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'Y'
4518: and GL_PS.closing_status IN ('O', 'F'))
4519: OR
4520: ((nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'N'))
4521: -- AND GL_PS.closing_status IN ('O', 'F')

Line 4520: ((nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'N'))

4516: -- bug 5206339 <11.5.10 GL PERIOD VALIDATION>
4517: AND (( (nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'Y'
4518: and GL_PS.closing_status IN ('O', 'F'))
4519: OR
4520: ((nvl(FND_PROFILE.VALUE('PO_VALIDATE_GL_PERIOD'),'Y')) = 'N'))
4521: -- AND GL_PS.closing_status IN ('O', 'F')
4522: AND GL_PS.adjustment_period_flag = 'N'
4523: AND GL_PS.period_year <= GL_SOB.latest_encumbrance_year
4524: -- PO period conditions:

Line 6180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');

6176: BEGIN
6177: -- read the profile POR: Sync up Need by date on IR with OM
6178: -- if yes then update the req table
6179: -- else by pass this and return success
6180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
6181:
6182: IF ( l_sync_need_by = 'YES' ) THEN
6183:
6184: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,

Line 7180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');

7176: BEGIN
7177: -- read the profile POR: Sync up Need by date on IR with OM
7178: -- if yes then update the req table
7179: -- else by pass this and return success
7180: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
7181:
7182: IF ( l_sync_need_by = 'YES' ) THEN
7183:
7184: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,