156: from HR_ORGANIZATION_INFORMATION
157: where ORGANIZATION_ID = p_organization_id
158: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
159:
160: FND_REQUEST.SET_ORG_ID (l_ou_id);
161:
162: wip_osp_shp_i_wf.StartWFProcess(
163: p_itemtype => 'WIPISHPW',
164: p_itemkey => l_itemkey,
275: from HR_ORGANIZATION_INFORMATION
276: where ORGANIZATION_ID = p_organization_id
277: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
278:
279: FND_REQUEST.SET_ORG_ID (l_ou_id);
280:
281: wip_osp_shp_i_wf.StartWFProcess(
282: p_itemtype => 'WIPISHPW',
283: p_itemkey => l_itemkey,
337: select to_number(ORG_INFORMATION3) into l_ou_id
338: from HR_ORGANIZATION_INFORMATION
339: where ORGANIZATION_ID = p_organization_id
340: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
341: FND_REQUEST.SET_ORG_ID (l_ou_id);
342:
343: l_success := fnd_request.submit_request(
344: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'WIP', NULL, 'ITEM',
345: NULL ,'N', 'Y' , chr(0), NULL, NULL, NULL,
339: where ORGANIZATION_ID = p_organization_id
340: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
341: FND_REQUEST.SET_ORG_ID (l_ou_id);
342:
343: l_success := fnd_request.submit_request(
344: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'WIP', NULL, 'ITEM',
345: NULL ,'N', 'Y' , chr(0), NULL, NULL, NULL,
346: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
347: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
839: select to_number(ORG_INFORMATION3) into l_ou_id
840: from HR_ORGANIZATION_INFORMATION
841: where ORGANIZATION_ID = p_organization_id
842: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
843: FND_REQUEST.SET_ORG_ID (l_ou_id);
844:
845: l_success := fnd_request.submit_request(
846: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'WIP', NULL, 'ITEM',
847: NULL ,'N', 'Y' , chr(0), NULL, NULL, NULL,
841: where ORGANIZATION_ID = p_organization_id
842: and ORG_INFORMATION_CONTEXT = l_org_acct_ctxt;
843: FND_REQUEST.SET_ORG_ID (l_ou_id);
844:
845: l_success := fnd_request.submit_request(
846: 'PO', 'REQIMPORT', NULL, NULL, FALSE,'WIP', NULL, 'ITEM',
847: NULL ,'N', 'Y' , chr(0), NULL, NULL, NULL,
848: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
849: NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,