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'));
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,
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,
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);
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);
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:
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);
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');
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:
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));
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));
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));
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);
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:
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);
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');
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:
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));
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));
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));