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 3241: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');

3237: p_cancellable_flag := 'Y';
3238:
3239: l_progress := '000';
3240:
3241: l_retropricing := fnd_profile.value('PO_ALLOW_RETROPRICING_OF_PO');
3242:
3243: SELECT
3244: prla.purchase_basis,
3245: prla.line_location_id,

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

6125: BEGIN
6126: -- read the profile POR: Sync up Need by date on IR with OM
6127: -- if yes then update the req table
6128: -- else by pass this and return success
6129: l_sync_need_by := nvl(fnd_profile.value('POR_SYNC_NEEDBYDATE_OM'), 'NO');
6130:
6131: IF ( l_sync_need_by = 'YES' ) THEN
6132:
6133: po_reqchangerequestwf_pvt.update_req_line_date_changes(p_req_line_id=>p_req_line_id,