APPS.OE_ORDER_WF_UTIL dependencies on FND_PROFILE

Line 736: l_avaluetext (2) := fnd_profile.VALUE ('OE_NOTIFICATION_APPROVER');

732:
733: l_aname2 (1) := 'ORDER_CATEGORY';
734: l_avaluetext (1) := p_header_rec.order_category_code;
735: l_aname2 (2) := 'NOTIFICATION_APPROVER';
736: l_avaluetext (2) := fnd_profile.VALUE ('OE_NOTIFICATION_APPROVER');
737: l_aname2 (3) := 'NOTIFICATION_FROM_ROLE';
738: l_avaluetext (3) := l_user_name;
739: l_aname2 (4) := 'ORDER_DETAILS_URL';
740: l_avaluetext (4) :=

Line 741: RTRIM (fnd_profile.VALUE ('APPS_FRAMEWORK_AGENT'), '/')

737: l_aname2 (3) := 'NOTIFICATION_FROM_ROLE';
738: l_avaluetext (3) := l_user_name;
739: l_aname2 (4) := 'ORDER_DETAILS_URL';
740: l_avaluetext (4) :=
741: RTRIM (fnd_profile.VALUE ('APPS_FRAMEWORK_AGENT'), '/')
742: || '/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE'
743: || '&'
744: || 'akRegionApplicationId=660'
745: || '&'

Line 966: l_avaluetext (2) := fnd_profile.VALUE ('OE_NOTIFICATION_APPROVER');

962: );
963: l_aname2 (1) := 'LINE_CATEGORY';
964: l_avaluetext (1) := p_line_rec.line_category_code;
965: l_aname2 (2) := 'NOTIFICATION_APPROVER';
966: l_avaluetext (2) := fnd_profile.VALUE ('OE_NOTIFICATION_APPROVER');
967: wf_engine.setitemattrtextarray (oe_globals.g_wfi_lin,
968: p_line_rec.line_id,
969: l_aname2,
970: l_avaluetext

Line 2087: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'), 'N') = 'Y')

2083: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)
2084: AND NVL (end_date_active, SYSDATE);
2085:
2086: IF ( (oe_globals.g_aso_installed = 'Y')
2087: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'), 'N') = 'Y')
2088: )
2089: THEN
2090: oe_line_util.lock_rows (p_line_id => p_line_id,
2091: x_line_tbl => l_old_line_tbl,

Line 2230: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'), 'N') = 'Y')

2226: );
2227: END IF;
2228:
2229: IF ( (oe_globals.g_aso_installed = 'Y')
2230: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'), 'N') = 'Y')
2231: )
2232: THEN
2233: l_line_tbl (1).flow_status_code := p_flow_status_code;
2234: l_line_tbl (1).lock_control := l_line_tbl (1).lock_control + 1;

Line 2393: || NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),

2389: || oe_globals.g_aso_installed
2390: );
2391: oe_debug_pub.ADD
2392: ( ' GENESIS : UPDATE FLOW STATUS - DBI Installed: '
2393: || NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),
2394: 'No.'
2395: )
2396: );
2397: oe_debug_pub.ADD

Line 2416: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),

2412: ----
2413: -- The following call to raise Business Event has been done for bug 13534511
2414: IF ( p_flow_status_code LIKE '%REQ_REQUESTED'
2415: OR NOT ( (oe_globals.g_aso_installed = 'Y')
2416: OR (NVL (fnd_profile.VALUE ('ONT_DBI_INSTALLED'),
2417: 'N'
2418: ) = 'Y'
2419: )
2420: )

Line 2767: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context

2763: 'SOURCE');
2764:
2765: IF l_type = 'PROFILE_APPROVER'
2766: THEN
2767: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2768: IF itemtype = 'OEOH'
2769: THEN
2770: v_value :=
2771: oe_profile.VALUE

Line 4800: RTRIM (fnd_profile.VALUE ('APPS_FRAMEWORK_AGENT'), '/')

4796:
4797: l_document := l_document || '