APPS.OE_ORDER_WF_UTIL dependencies on FND_PROFILE

Line 638: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');

634:
635: l_aname2(1) := 'ORDER_CATEGORY';
636: l_avaluetext(1) := p_header_rec.order_category_code;
637: l_aname2(2) := 'NOTIFICATION_APPROVER';
638: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
639: l_aname2(3) := 'NOTIFICATION_FROM_ROLE';
640: l_avaluetext(3) := l_user_name;
641: l_aname2(4) := 'ORDER_DETAILS_URL';
642: l_avaluetext(4) := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||

Line 642: l_avaluetext(4) := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||

638: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
639: l_aname2(3) := 'NOTIFICATION_FROM_ROLE';
640: l_avaluetext(3) := l_user_name;
641: l_aname2(4) := 'ORDER_DETAILS_URL';
642: l_avaluetext(4) := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||
643: '/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' ||
644: 'akRegionApplicationId=660' || '&' || 'HeaderId=' || to_char(p_header_rec.header_id);
645:
646:

Line 850: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');

846:
847: l_aname2(1) := 'LINE_CATEGORY';
848: l_avaluetext(1) := p_line_rec.line_category_code;
849: l_aname2(2) := 'NOTIFICATION_APPROVER';
850: l_avaluetext(2) := FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
851:
852: wf_engine.SetItemAttrTextArray( OE_GLOBALS.G_WFI_LIN
853: , p_line_rec.line_id
854: , l_aname2

Line 1747: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN

1743: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1744: AND NVL(END_DATE_ACTIVE, SYSDATE);
1745:
1746: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1747: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1748:
1749: OE_Line_Util.Lock_Rows
1750: (p_line_id=>p_line_id
1751: , x_line_tbl=>l_old_line_tbl

Line 1869: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN

1865: LOCK_CONTROL = LOCK_CONTROL + 1
1866: WHERE LINE_ID = p_line_id;
1867:
1868: IF ( (OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1869: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') ) THEN
1870:
1871:
1872: l_line_tbl(1).flow_status_code := p_flow_status_code;
1873: l_line_tbl(1).lock_control := l_line_tbl(1).lock_control + 1;

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

2186: --
2187: IF (funcmode = 'RUN') THEN
2188: l_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid, 'SOURCE');
2189: IF l_type = 'PROFILE_APPROVER' THEN
2190: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
2191: IF itemtype = 'OEOH' THEN
2192: v_value := oe_profile.value(p_header_id => to_number(itemkey),
2193: p_line_id => null,
2194: p_profile_option_name => 'OE_NOTIFICATION_APPROVER');

Line 3683: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || p_item_key;

3679:
3680: l_document := l_document || '