DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_PROFILE

Line 304: FND_PROFILE.VALUE('USER_ID'),

300: l_credit_total_dsp := to_char(l_credit_total,
301: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
302: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(
303: p_employee_id,
304: FND_PROFILE.VALUE('USER_ID'),
305: l_employee_project_enabled);
306:
307: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(
308: p_workflow_flag);

Line 365: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );

361: --------------------------------------------------------------
362:
363: /* Bug 2945379 : The org_id retrieved from the table will
364: always be the correct one */
365: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );
366:
367: SELECT org_id
368: INTO l_n_org_id
369: FROM ap_expense_report_headers_all

Line 410: FND_PROFILE.VALUE('USER_ID'));

406: --------------------------------------------------------------
407: WF_ENGINE.SetItemAttrNumber(l_item_type,
408: l_item_key,
409: 'USER_ID',
410: FND_PROFILE.VALUE('USER_ID'));
411:
412: --------------------------------------------------------------
413: l_debug_info := 'Set Resp_ID value ';
414: --------------------------------------------------------------

Line 418: FND_PROFILE.VALUE('RESP_ID'));

414: --------------------------------------------------------------
415: WF_ENGINE.SetItemAttrNumber(l_item_type,
416: l_item_key,
417: 'RESPONSIBILITY_ID',
418: FND_PROFILE.VALUE('RESP_ID'));
419:
420: --------------------------------------------------------------
421: l_debug_info := 'Set Resp_Appl_ID value ';
422: --------------------------------------------------------------

Line 426: FND_PROFILE.VALUE('RESP_APPL_ID'));

422: --------------------------------------------------------------
423: WF_ENGINE.SetItemAttrNumber(l_item_type,
424: l_item_key,
425: 'APPLICATION_ID',
426: FND_PROFILE.VALUE('RESP_APPL_ID'));
427:
428: ------------------------------------------------------------
429: l_debug_info := 'Get responsibility id';
430: ------------------------------------------------------------

Line 447: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_n_resp_id, 200, l_AMEEnabled, l_bAMEProfileDefined);

443:
444: ----------------------------------------------------
445: l_debug_info := 'Retrieve profile option AME Enabled?';
446: ----------------------------------------------------
447: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_n_resp_id, 200, l_AMEEnabled, l_bAMEProfileDefined);
448:
449: if l_bAMEProfileDefined then
450: l_AMEEnabled := NVL(l_AMEENABLED,'N'); -- Default to 'N' if null
451: else

Line 765: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', l_userid,

761:
762: ------------------------------------------------------------
763: l_debug_info := 'Retrieve policy profile option';
764: ------------------------------------------------------------
765: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', l_userid,
766: l_n_resp_id, 200, l_policy_violation_value, l_policy_violation_defined);
767:
768: if l_policy_violation_defined then
769: l_policy_violation_value := NVL(l_policy_violation_value, C_ALLOW_NO_WARNINGS);

Line 5599: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN

5595: raise;
5596: end if;
5597: end;
5598:
5599: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
5600:
5601: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(l_report_header_id);
5602: END IF;
5603:

Line 8838: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_nRespId, 200, l_AMEEnabled, l_bAMEProfileDefined);

8834:
8835: ----------------------------------------------------
8836: l_debug_info := 'Retrieve profile option AME Enabled';
8837: ----------------------------------------------------
8838: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_nRespId, 200, l_AMEEnabled, l_bAMEProfileDefined);
8839:
8840: if l_bAMEProfileDefined then
8841: -----------------------------------------------
8842: -- for bug 3344280, check the profile option value if it's defined

Line 10141: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));

10137:
10138: /* Bug 4319321 : Need to check the values of user_id, resp_id
10139: * and resp_appl_id as well.
10140: */
10141: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
10142: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
10143: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
10144: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
10145:

Line 10142: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));

10138: /* Bug 4319321 : Need to check the values of user_id, resp_id
10139: * and resp_appl_id as well.
10140: */
10141: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
10142: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
10143: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
10144: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
10145:
10146: /* Bug 4711393 : Should return NOTSET instead of FALSE in test_ctx mode

Line 10143: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));

10139: * and resp_appl_id as well.
10140: */
10141: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
10142: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
10143: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
10144: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
10145:
10146: /* Bug 4711393 : Should return NOTSET instead of FALSE in test_ctx mode
10147: * so that the actual context can get set via call in

Line 11149: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN

11145: raise;
11146: end if;
11147: end;
11148:
11149: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
11150:
11151: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(l_report_header_id);
11152: END IF;
11153:

Line 11791: l_n_resp_id := FND_PROFILE.VALUE('RESP_ID');

11787: end if;
11788: end;
11789: END IF;
11790: IF (nvl(l_n_resp_id,0) = 0) THEN
11791: l_n_resp_id := FND_PROFILE.VALUE('RESP_ID');
11792: END IF;
11793: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
11794:
11795: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(p_rep_header_id);

Line 11793: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN

11789: END IF;
11790: IF (nvl(l_n_resp_id,0) = 0) THEN
11791: l_n_resp_id := FND_PROFILE.VALUE('RESP_ID');
11792: END IF;
11793: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
11794:
11795: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(p_rep_header_id);
11796: END IF;
11797:

Line 12104: FND_PROFILE.get_specific('OIE_ENABLE_LINE_LEVEL_ACCOUNTING', null,

12100:
12101: ------------------------------------------------------------
12102: l_debug_info := 'Check line level accounting enabled';
12103: ------------------------------------------------------------
12104: FND_PROFILE.get_specific('OIE_ENABLE_LINE_LEVEL_ACCOUNTING', null,
12105: l_n_resp_id, 200, l_line_accounting_enabled, l_line_accounting_defined);
12106:
12107:
12108: if l_line_accounting_defined then

Line 12117: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', null,

12113:
12114: ------------------------------------------------------------
12115: l_debug_info := 'Get policy profile option';
12116: ------------------------------------------------------------
12117: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', null,
12118: l_n_resp_id, 200, l_policy_violation_value, l_policy_violation_defined);
12119:
12120: if l_policy_violation_defined then
12121: l_policy_violation_value := NVL(l_policy_violation_value, C_ALLOW_NO_WARNINGS);

Line 15870: l_user_id := FND_PROFILE.VALUE('USER_ID');

15866:
15867: ----------------------------------------------------------
15868: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
15869: ----------------------------------------------------------
15870: l_user_id := FND_PROFILE.VALUE('USER_ID');
15871: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
15872: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
15873:
15874: ----------------------------------------------------------

Line 15871: l_resp_id := FND_PROFILE.VALUE('RESP_ID');

15867: ----------------------------------------------------------
15868: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
15869: ----------------------------------------------------------
15870: l_user_id := FND_PROFILE.VALUE('USER_ID');
15871: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
15872: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
15873:
15874: ----------------------------------------------------------
15875: l_debug_info := 'Add to event param list USER_ID/RESP_ID/RESP_APPL_ID';

Line 15872: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');

15868: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
15869: ----------------------------------------------------------
15870: l_user_id := FND_PROFILE.VALUE('USER_ID');
15871: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
15872: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
15873:
15874: ----------------------------------------------------------
15875: l_debug_info := 'Add to event param list USER_ID/RESP_ID/RESP_APPL_ID';
15876: ----------------------------------------------------------