DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_WF dependencies on FND_PROFILE

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

296: l_credit_total_dsp := to_char(l_credit_total,
297: FND_CURRENCY.Get_Format_Mask(p_reimb_curr,22));
298: AP_WEB_PROJECT_PKG.IsSessionProjectEnabled(
299: p_employee_id,
300: FND_PROFILE.VALUE('USER_ID'),
301: l_employee_project_enabled);
302:
303: l_ResubmitReport := AP_WEB_DB_EXPRPT_PKG.ResubmitExpenseReport(
304: p_workflow_flag);

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

344: --------------------------------------------------------------
345:
346: /* Bug 2945379 : The org_id retrieved from the table will
347: always be the correct one */
348: -- FND_PROFILE.GET('ORG_ID' , l_n_org_id );
349:
350: SELECT org_id
351: INTO l_n_org_id
352: FROM ap_expense_report_headers_all

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

389: --------------------------------------------------------------
390: WF_ENGINE.SetItemAttrNumber(l_item_type,
391: l_item_key,
392: 'USER_ID',
393: FND_PROFILE.VALUE('USER_ID'));
394:
395: --------------------------------------------------------------
396: l_debug_info := 'Set Resp_ID value ';
397: --------------------------------------------------------------

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

397: --------------------------------------------------------------
398: WF_ENGINE.SetItemAttrNumber(l_item_type,
399: l_item_key,
400: 'RESPONSIBILITY_ID',
401: FND_PROFILE.VALUE('RESP_ID'));
402:
403: --------------------------------------------------------------
404: l_debug_info := 'Set Resp_Appl_ID value ';
405: --------------------------------------------------------------

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

405: --------------------------------------------------------------
406: WF_ENGINE.SetItemAttrNumber(l_item_type,
407: l_item_key,
408: 'APPLICATION_ID',
409: FND_PROFILE.VALUE('RESP_APPL_ID'));
410:
411: ------------------------------------------------------------
412: l_debug_info := 'Get responsibility id';
413: ------------------------------------------------------------

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

426:
427: ----------------------------------------------------
428: l_debug_info := 'Retrieve profile option AME Enabled?';
429: ----------------------------------------------------
430: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_n_resp_id, 200, l_AMEEnabled, l_bAMEProfileDefined);
431:
432: if l_bAMEProfileDefined then
433: l_AMEEnabled := NVL(l_AMEENABLED,'N'); -- Default to 'N' if null
434: else

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

744:
745: ------------------------------------------------------------
746: l_debug_info := 'Retrieve policy profile option';
747: ------------------------------------------------------------
748: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', l_userid,
749: l_n_resp_id, 200, l_policy_violation_value, l_policy_violation_defined);
750:
751: if l_policy_violation_defined then
752: l_policy_violation_value := NVL(l_policy_violation_value, C_ALLOW_NO_WARNINGS);

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

5237: raise;
5238: end if;
5239: end;
5240:
5241: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
5242:
5243: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(l_report_header_id);
5244: END IF;
5245:

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

8388:
8389: ----------------------------------------------------
8390: l_debug_info := 'Retrieve profile option AME Enabled';
8391: ----------------------------------------------------
8392: FND_PROFILE.GET_SPECIFIC('AME_INSTALLED_FLAG', null, l_nRespId, 200, l_AMEEnabled, l_bAMEProfileDefined);
8393:
8394: if l_bAMEProfileDefined then
8395: -----------------------------------------------
8396: -- for bug 3344280, check the profile option value if it's defined

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

9691:
9692: /* Bug 4319321 : Need to check the values of user_id, resp_id
9693: * and resp_appl_id as well.
9694: */
9695: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
9696: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
9697: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
9698: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
9699:

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

9692: /* Bug 4319321 : Need to check the values of user_id, resp_id
9693: * and resp_appl_id as well.
9694: */
9695: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
9696: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
9697: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
9698: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
9699:
9700: /* Bug 4711393 : Should return NOTSET instead of FALSE in test_ctx mode

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

9693: * and resp_appl_id as well.
9694: */
9695: l_current_user_id := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
9696: l_current_resp_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_ID'));
9697: l_current_resp_appl_id := TO_NUMBER(FND_PROFILE.VALUE('RESP_APPL_ID'));
9698: l_current_org_id := nvl(mo_global.get_current_org_id, -99);
9699:
9700: /* Bug 4711393 : Should return NOTSET instead of FALSE in test_ctx mode
9701: * so that the actual context can get set via call in

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

10418: raise;
10419: end if;
10420: end;
10421:
10422: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
10423:
10424: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(l_report_header_id);
10425: END IF;
10426:

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

11030: raise;
11031: end if;
11032: end;
11033:
11034: IF FND_PROFILE.VALUE_SPECIFIC('OIE_ENABLE_ADVANCES',NULL,l_n_resp_id,200) = 'PAYABLES' THEN
11035:
11036: AP_WEB_DB_EXPLINE_PKG.resetApplyAdvances(p_rep_header_id);
11037: END IF;
11038:

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

11337:
11338: ------------------------------------------------------------
11339: l_debug_info := 'Check line level accounting enabled';
11340: ------------------------------------------------------------
11341: FND_PROFILE.get_specific('OIE_ENABLE_LINE_LEVEL_ACCOUNTING', null,
11342: l_n_resp_id, 200, l_line_accounting_enabled, l_line_accounting_defined);
11343:
11344:
11345: if l_line_accounting_defined then

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

11350:
11351: ------------------------------------------------------------
11352: l_debug_info := 'Get policy profile option';
11353: ------------------------------------------------------------
11354: FND_PROFILE.get_specific('AP_WEB_POLICY_VIOLATION_SUBMIT', null,
11355: l_n_resp_id, 200, l_policy_violation_value, l_policy_violation_defined);
11356:
11357: if l_policy_violation_defined then
11358: l_policy_violation_value := NVL(l_policy_violation_value, C_ALLOW_NO_WARNINGS);

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

14901:
14902: ----------------------------------------------------------
14903: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
14904: ----------------------------------------------------------
14905: l_user_id := FND_PROFILE.VALUE('USER_ID');
14906: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
14907: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
14908:
14909: ----------------------------------------------------------

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

14902: ----------------------------------------------------------
14903: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
14904: ----------------------------------------------------------
14905: l_user_id := FND_PROFILE.VALUE('USER_ID');
14906: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
14907: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
14908:
14909: ----------------------------------------------------------
14910: l_debug_info := 'Add to event param list USER_ID/RESP_ID/RESP_APPL_ID';

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

14903: l_debug_info := 'Get USER_ID/RESP_ID/RESP_APPL_ID';
14904: ----------------------------------------------------------
14905: l_user_id := FND_PROFILE.VALUE('USER_ID');
14906: l_resp_id := FND_PROFILE.VALUE('RESP_ID');
14907: l_resp_appl_id := FND_PROFILE.VALUE('RESP_APPL_ID');
14908:
14909: ----------------------------------------------------------
14910: l_debug_info := 'Add to event param list USER_ID/RESP_ID/RESP_APPL_ID';
14911: ----------------------------------------------------------