APPS.AP_WFAPPROVAL_PKG dependencies on FND_PROFILE

Line 438: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);

434: transactionTypeIn => 'APINV');
435: END IF;
436:
437: --Bug 2674037 set to -1 if responding to email notification
438: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
439: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
440:
441: IF l_result = 'APPROVED' THEN
442: l_result := 'WFAPPROVED';

Line 439: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);

435: END IF;
436:
437: --Bug 2674037 set to -1 if responding to email notification
438: l_user_id := nvl(to_number(fnd_profile.value('USER_ID')),-1);
439: l_login_id := nvl(to_number(fnd_profile.value('LOGIN_ID')),-1);
440:
441: IF l_result = 'APPROVED' THEN
442: l_result := 'WFAPPROVED';
443: END IF;

Line 549: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

545: l_iteration,
546: 'PENDING',
547: l_approver_id,
548: l_approver,
549: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
550: sysdate,
551: sysdate,
552: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
553: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1),

Line 552: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),

548: l_approver,
549: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
550: sysdate,
551: sysdate,
552: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
553: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1),
554: l_org_id,
555: l_amount);
556:

Line 553: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1),

549: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
550: sysdate,
551: sysdate,
552: nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1),
553: nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),-1),
554: l_org_id,
555: l_amount);
556:
557: WF_ENGINE.SetItemAttrNumber(itemtype,

Line 607: FND_PROFILE.VALUE('USERNAME'),

603: p_invoice_id,
604: p_iteration,
605: p_status,
606: NULL,
607: FND_PROFILE.VALUE('USERNAME'),
608: l_amount,
609: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
610: sysdate,
611: sysdate,

Line 609: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

605: p_status,
606: NULL,
607: FND_PROFILE.VALUE('USERNAME'),
608: l_amount,
609: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
610: sysdate,
611: sysdate,
612: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
613: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

Line 612: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),

608: l_amount,
609: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
610: sysdate,
611: sysdate,
612: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
613: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
614: p_org_id);
615:
616: commit;

Line 613: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),

609: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
610: sysdate,
611: sysdate,
612: TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),
613: TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')),
614: p_org_id);
615:
616: commit;
617: