APPS.AP_WEB_RECEIPTS_WF dependencies on FND_GLOBAL

Line 2114: fnd_global.set_nls_context(p_nls_language => l_new_language);

2110: into l_new_language
2111: from fnd_languages
2112: where language_code = l_new_language_code;
2113:
2114: fnd_global.set_nls_context(p_nls_language => l_new_language);
2115:
2116: ------------------------------------------------------------
2117: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
2118: ------------------------------------------------------------

Line 2157: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES

2153: l_message_name := 'OIE_NOTES_PREPARER_RESPONSE';
2154:
2155: begin
2156: -------------------------------------------------------------------
2157: -- fnd_global.set_nls_context() seems to work for WF but not FND_MESSAGES
2158: -------------------------------------------------------------------
2159: select message_text
2160: into l_note_prefix
2161: from fnd_new_messages

Line 2231: p_entered_by => nvl(l_created_by,fnd_global.user_id) -- bug 6361555

2227: p_report_header_id => l_report_header_id,
2228: p_note => l_note_prefix||' '||l_code_display_name||'
2229: '||l_response,
2230: p_lang => l_new_language_code,
2231: p_entered_by => nvl(l_created_by,fnd_global.user_id) -- bug 6361555
2232: );
2233:
2234: ----------------------------------------------------------
2235: l_debug_info := 'clear Item Attribute PREPARER_RESPONSE';

Line 2312: fnd_global.set_nls_context(p_nls_language => l_orig_language);

2308:
2309: -------------------------------------------------------------------
2310: l_debug_info := 'Restore nls context to original language';
2311: -------------------------------------------------------------------
2312: fnd_global.set_nls_context(p_nls_language => l_orig_language);
2313:
2314: p_result := 'COMPLETE:Y';
2315:
2316: END IF;

Line 2452: SET OVERDUE_REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

2448: end if;
2449:
2450: -- Supervisor Notifications
2451: UPDATE AP_EXPENSE_REPORT_HEADERS_ALL
2452: SET OVERDUE_REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2453: WHERE REPORT_HEADER_ID = p_expense_report_id;
2454:
2455: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'end RaiseOverdueEvent');
2456:

Line 2574: l_item_key VARCHAR2(100) := to_char(FND_GLOBAL.CONC_REQUEST_ID);

2570: l_original_overdue BOOLEAN := FALSE;
2571: l_image_overdue BOOLEAN := FALSE;
2572: l_original_missing BOOLEAN := FALSE;
2573: l_image_missing BOOLEAN := FALSE;
2574: l_item_key VARCHAR2(100) := to_char(FND_GLOBAL.CONC_REQUEST_ID);
2575: l_item_type VARCHAR2(10) := C_APWRECPT;
2576: l_supervisor_id ap_expense_report_headers.employee_id%TYPE;
2577: l_temp_emp_id ap_expense_report_headers.employee_id%TYPE;
2578: l_supName wf_users.name%type;

Line 2753: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)

2749: (SELECT emp.supervisor_id
2750: FROM per_employees_x emp
2751: WHERE emp.employee_id in (select distinct employee_id
2752: from ap_expense_report_headers_all
2753: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2754: AND NOT AP_WEB_DB_HR_INT_PKG.ispersoncwk(emp.employee_id)='Y'
2755: UNION ALL
2756: SELECT emp.supervisor_id
2757: FROM per_cont_workers_current_x emp

Line 2760: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)

2756: SELECT emp.supervisor_id
2757: FROM per_cont_workers_current_x emp
2758: WHERE emp.person_id in (select distinct employee_id
2759: from ap_expense_report_headers_all
2760: where overdue_request_id = FND_GLOBAL.CONC_REQUEST_ID)
2761: );
2762:
2763:
2764:

Line 2954: FND_GLOBAL.CONC_REQUEST_ID);

2950: l_supervisor_id);
2951: WF_ENGINE.SetItemAttrNumber(l_item_type,
2952: l_item_key,
2953: 'OVERDUE_REQUEST_ID',
2954: FND_GLOBAL.CONC_REQUEST_ID);
2955: WF_ENGINE.StartProcess(l_item_type, l_item_key);
2956: fnd_file.put_line(fnd_file.log, 'Start Process ' || l_item_key);
2957: END IF;
2958: end loop;