969: -- All orgs should be non process
970: /* ANTHIYAG Bug#5460153 14-Aug-2006 Start */
971: /*
972: BEGIN
973: SELECT 1 INTO l_count FROM MTL_PARAMETERS
974: WHERE ORGANIZATION_ID=P_ORGANIZATION_IDS(l_index)
975: AND PROCESS_ENABLED_FLAG='Y';
976: -- if a record is found then its a failure condition
977: -- process enabled orgs are not supported for global procuring transaction
989: ELSE
990: -- Old accounting All orgs should be either process or discrete
991: BEGIN
992: -- get process org
993: SELECT 1 INTO l_count FROM MTL_PARAMETERS
994: WHERE ORGANIZATION_ID=P_ORGANIZATION_IDS(l_index)
995: AND PROCESS_ENABLED_FLAG='Y';
996: -- get discrete org
997: SELECT 1 INTO l_count_disc FROM MTL_PARAMETERS
993: SELECT 1 INTO l_count FROM MTL_PARAMETERS
994: WHERE ORGANIZATION_ID=P_ORGANIZATION_IDS(l_index)
995: AND PROCESS_ENABLED_FLAG='Y';
996: -- get discrete org
997: SELECT 1 INTO l_count_disc FROM MTL_PARAMETERS
998: WHERE ORGANIZATION_ID=P_ORGANIZATION_IDS(l_index)
999: AND PROCESS_ENABLED_FLAG<>'Y';
1000: IF l_count=1 and l_count_disc=1 THEN
1001: -- failure condition
1012: END IF;
1013: ELSIF p_flow_type=2 THEN-- procuring
1014: /** INVCONV remove the check for process org
1015: BEGIN
1016: SELECT 1 INTO l_count FROM MTL_PARAMETERS
1017: WHERE ORGANIZATION_ID=P_ORGANIZATION_IDS(l_index)
1018: AND PROCESS_ENABLED_FLAG='Y';
1019: -- if a record is found then its a failure condition
1020: -- process enabled orgs are not supported for global procuring transaction