DBA Data[Home] [Help]

APPS.CE_BASIG_WF dependencies on FND_PROFILE

Line 43: FND_PROFILE.get('ORG_ID',l_org_id);

39: IS
40: ameappid number;
41: l_org_id number(15);
42: BEGIN
43: FND_PROFILE.get('ORG_ID',l_org_id);
44: FND_CLIENT_INFO.set_org_context(l_org_id);
45: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
46: fnd_profile.value('RESP_ID'),
47: fnd_profile.value('RESP_APPL_ID'));

Line 45: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),

41: l_org_id number(15);
42: BEGIN
43: FND_PROFILE.get('ORG_ID',l_org_id);
44: FND_CLIENT_INFO.set_org_context(l_org_id);
45: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
46: fnd_profile.value('RESP_ID'),
47: fnd_profile.value('RESP_APPL_ID'));
48:
49: ame_api.clearAllApprovals(applicationIdIn => fndApplicationIdIn,

Line 46: fnd_profile.value('RESP_ID'),

42: BEGIN
43: FND_PROFILE.get('ORG_ID',l_org_id);
44: FND_CLIENT_INFO.set_org_context(l_org_id);
45: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
46: fnd_profile.value('RESP_ID'),
47: fnd_profile.value('RESP_APPL_ID'));
48:
49: ame_api.clearAllApprovals(applicationIdIn => fndApplicationIdIn,
50: transactionIdIn => transactionidin,

Line 47: fnd_profile.value('RESP_APPL_ID'));

43: FND_PROFILE.get('ORG_ID',l_org_id);
44: FND_CLIENT_INFO.set_org_context(l_org_id);
45: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
46: fnd_profile.value('RESP_ID'),
47: fnd_profile.value('RESP_APPL_ID'));
48:
49: ame_api.clearAllApprovals(applicationIdIn => fndApplicationIdIn,
50: transactionIdIn => transactionidin,
51: transactionTypeIn => transactionTypeIn);

Line 449: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),

445: id number := itemkey;
446: BEGIN
447: IF command='RUN' THEN
448: initialize(260,id,'CEBASIG');
449: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
450: fnd_profile.value('RESP_ID'),
451: fnd_profile.value('RESP_APPL_ID'));
452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);

Line 450: fnd_profile.value('RESP_ID'),

446: BEGIN
447: IF command='RUN' THEN
448: initialize(260,id,'CEBASIG');
449: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
450: fnd_profile.value('RESP_ID'),
451: fnd_profile.value('RESP_APPL_ID'));
452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);
454:

Line 451: fnd_profile.value('RESP_APPL_ID'));

447: IF command='RUN' THEN
448: initialize(260,id,'CEBASIG');
449: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
450: fnd_profile.value('RESP_ID'),
451: fnd_profile.value('RESP_APPL_ID'));
452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);
454:
455: FND_PROFILE.get('ORG_ID',l_org_id);

Line 452: FND_PROFILE.get('ORG_ID',l_org_id);

448: initialize(260,id,'CEBASIG');
449: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
450: fnd_profile.value('RESP_ID'),
451: fnd_profile.value('RESP_APPL_ID'));
452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);
454:
455: FND_PROFILE.get('ORG_ID',l_org_id);
456: l_user_id := fnd_profile.value('USER_ID');

Line 455: FND_PROFILE.get('ORG_ID',l_org_id);

451: fnd_profile.value('RESP_APPL_ID'));
452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);
454:
455: FND_PROFILE.get('ORG_ID',l_org_id);
456: l_user_id := fnd_profile.value('USER_ID');
457: l_resp_id := fnd_profile.value('RESP_ID');
458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
459:

Line 456: l_user_id := fnd_profile.value('USER_ID');

452: FND_PROFILE.get('ORG_ID',l_org_id);
453: fnd_client_info.set_org_context(l_org_id);
454:
455: FND_PROFILE.get('ORG_ID',l_org_id);
456: l_user_id := fnd_profile.value('USER_ID');
457: l_resp_id := fnd_profile.value('RESP_ID');
458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
459:
460: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));

Line 457: l_resp_id := fnd_profile.value('RESP_ID');

453: fnd_client_info.set_org_context(l_org_id);
454:
455: FND_PROFILE.get('ORG_ID',l_org_id);
456: l_user_id := fnd_profile.value('USER_ID');
457: l_resp_id := fnd_profile.value('RESP_ID');
458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
459:
460: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));
461: WF_ENGINE.setItemAttrText('CEBASIG',id,'USER_ID',to_char(l_user_id));

Line 458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

454:
455: FND_PROFILE.get('ORG_ID',l_org_id);
456: l_user_id := fnd_profile.value('USER_ID');
457: l_resp_id := fnd_profile.value('RESP_ID');
458: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
459:
460: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));
461: WF_ENGINE.setItemAttrText('CEBASIG',id,'USER_ID',to_char(l_user_id));
462: WF_ENGINE.setItemAttrText('CEBASIG',id,'RESPONSIBILITY_ID',to_char(l_resp_id));

Line 620: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),

616: WF_ENGINE.CREATEPROCESS('CEBASIG',
617: id,
618: 'CEBASIG');
619:
620: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
621: fnd_profile.value('RESP_ID'),
622: fnd_profile.value('RESP_APPL_ID'));
623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);

Line 621: fnd_profile.value('RESP_ID'),

617: id,
618: 'CEBASIG');
619:
620: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
621: fnd_profile.value('RESP_ID'),
622: fnd_profile.value('RESP_APPL_ID'));
623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);
625:

Line 622: fnd_profile.value('RESP_APPL_ID'));

618: 'CEBASIG');
619:
620: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
621: fnd_profile.value('RESP_ID'),
622: fnd_profile.value('RESP_APPL_ID'));
623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);
625:
626: FND_PROFILE.get('ORG_ID',l_org_id);

Line 623: FND_PROFILE.get('ORG_ID',l_org_id);

619:
620: fnd_global.apps_initialize(fnd_profile.value('USER_ID'),
621: fnd_profile.value('RESP_ID'),
622: fnd_profile.value('RESP_APPL_ID'));
623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);
625:
626: FND_PROFILE.get('ORG_ID',l_org_id);
627: l_user_id := fnd_profile.value('USER_ID');

Line 626: FND_PROFILE.get('ORG_ID',l_org_id);

622: fnd_profile.value('RESP_APPL_ID'));
623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);
625:
626: FND_PROFILE.get('ORG_ID',l_org_id);
627: l_user_id := fnd_profile.value('USER_ID');
628: l_resp_id := fnd_profile.value('RESP_ID');
629: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
630:

Line 627: l_user_id := fnd_profile.value('USER_ID');

623: FND_PROFILE.get('ORG_ID',l_org_id);
624: fnd_client_info.set_org_context(l_org_id);
625:
626: FND_PROFILE.get('ORG_ID',l_org_id);
627: l_user_id := fnd_profile.value('USER_ID');
628: l_resp_id := fnd_profile.value('RESP_ID');
629: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
630:
631: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));

Line 628: l_resp_id := fnd_profile.value('RESP_ID');

624: fnd_client_info.set_org_context(l_org_id);
625:
626: FND_PROFILE.get('ORG_ID',l_org_id);
627: l_user_id := fnd_profile.value('USER_ID');
628: l_resp_id := fnd_profile.value('RESP_ID');
629: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
630:
631: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));
632: WF_ENGINE.setItemAttrText('CEBASIG',id,'USER_ID',to_char(l_user_id));

Line 629: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');

625:
626: FND_PROFILE.get('ORG_ID',l_org_id);
627: l_user_id := fnd_profile.value('USER_ID');
628: l_resp_id := fnd_profile.value('RESP_ID');
629: l_resp_appl_id := fnd_profile.value('RESP_APPL_ID');
630:
631: WF_ENGINE.setItemAttrText('CEBASIG',id,'ORG_ID',to_char(l_org_id));
632: WF_ENGINE.setItemAttrText('CEBASIG',id,'USER_ID',to_char(l_user_id));
633: WF_ENGINE.setItemAttrText('CEBASIG',id,'RESPONSIBILITY_ID',to_char(l_resp_id));