[Home] [Help]
332: RAISE fnd_api.g_exc_error;
333:
334: END IF;
335:
336: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
337:
338: IF ( (p_owner_type <> 'RS_GROUP')
339: AND (p_owner_type <> 'RS_TEAM') )
340: THEN
338: IF ( (p_owner_type <> 'RS_GROUP')
339: AND (p_owner_type <> 'RS_TEAM') )
340: THEN
341:
342: l_owner_type:= 'RS_INDIVIDUAL';
343: l_owner_type_actual := p_owner_type;
344:
345: else
346:
352: IF ( (p_assignee_type <> 'RS_GROUP')
353: AND (p_assignee_type <> 'RS_TEAM') )
354: THEN
355:
356: l_assignee_type := 'RS_INDIVIDUAL';
357: l_assignee_type_actual := p_assignee_type;
358:
359: else
360:
551:
552: RAISE fnd_api.g_exc_error;
553: END;
554: l_dist_from := 'GROUP_OWNED';
555: l_dist_to := 'INDIVIDUAL_ASSIGNED';
556:
557: else
558: l_dist_from := 'GROUP_OWNED';
559: l_dist_to := 'INDIVIDUAL_ASSIGNED';
555: l_dist_to := 'INDIVIDUAL_ASSIGNED';
556:
557: else
558: l_dist_from := 'GROUP_OWNED';
559: l_dist_to := 'INDIVIDUAL_ASSIGNED';
560:
561: l_curr_ws_id := l_ws_id1;
562: /*
563: BEGIN
636: l_distribution_status_id := 0;
637:
638: else
639: if (l_dist_from = 'GROUP_OWNED') and
640: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
641: then
642:
643: if (l_owner_type = 'RS_GROUP') and
644: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
640: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
641: then
642:
643: if (l_owner_type = 'RS_GROUP') and
644: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
645: then
646: l_distribution_status_id := 1;
647: elsif (l_assignee_type = 'RS_INDIVIDUAL')
648: then
643: if (l_owner_type = 'RS_GROUP') and
644: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
645: then
646: l_distribution_status_id := 1;
647: elsif (l_assignee_type = 'RS_INDIVIDUAL')
648: then
649: l_distribution_status_id := 3;
650: else
651: l_distribution_status_id := 0;
652: end if;
653: end if;
654: /*
655: if (l_dist_from = 'GROUP_OWNED') and
656: (l_dist_to = 'INDIVIDUAL_OWNED')
657: then
658:
659: if (l_owner_type = 'RS_GROUP')
660: then
658:
659: if (l_owner_type = 'RS_GROUP')
660: then
661: l_distribution_status_id := 1;
662: elsif (l_owner_type = 'RS_INDIVIDUAL')
663: then
664: l_distribution_status_id := 3;
665: else
666: l_distribution_status_id := 0;
666: l_distribution_status_id := 0;
667: end if;
668:
669: elsif (l_dist_from = 'GROUP_OWNED') and
670: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
671: then
672:
673: if (l_owner_type = 'RS_GROUP') and
674: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
670: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
671: then
672:
673: if (l_owner_type = 'RS_GROUP') and
674: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
675: then
676: l_distribution_status_id := 1;
677: elsif (l_assignee_type = 'RS_INDIVIDUAL')
678: then
673: if (l_owner_type = 'RS_GROUP') and
674: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
675: then
676: l_distribution_status_id := 1;
677: elsif (l_assignee_type = 'RS_INDIVIDUAL')
678: then
679: l_distribution_status_id := 3;
680: else
681: l_distribution_status_id := 0;
681: l_distribution_status_id := 0;
682: end if;
683:
684: elsif (l_dist_from = 'GROUP_ASSIGNED') and
685: (l_dist_to = 'INDIVIDUAL_OWNED')
686: then
687:
688: if (l_assignee_type = 'RS_GROUP') and
689: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
685: (l_dist_to = 'INDIVIDUAL_OWNED')
686: then
687:
688: if (l_assignee_type = 'RS_GROUP') and
689: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
690: then
691: l_distribution_status_id := 1;
692: elsif (l_owner_type = 'RS_INDIVIDUAL')
693: then
688: if (l_assignee_type = 'RS_GROUP') and
689: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
690: then
691: l_distribution_status_id := 1;
692: elsif (l_owner_type = 'RS_INDIVIDUAL')
693: then
694: l_distribution_status_id := 3;
695: else
696: l_distribution_status_id := 0;
696: l_distribution_status_id := 0;
697: end if;
698:
699: elsif (l_dist_from = 'GROUP_ASSIGNED') and
700: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
701: then
702:
703: if (l_assignee_type = 'RS_GROUP')
704: then
702:
703: if (l_assignee_type = 'RS_GROUP')
704: then
705: l_distribution_status_id := 1;
706: elsif (l_assignee_type = 'RS_INDIVIDUAL')
707: then
708: l_distribution_status_id := 3;
709: else
710: l_distribution_status_id := 0;
1352: RAISE fnd_api.g_exc_error;
1353:
1354: END IF;
1355:
1356: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
1357:
1358: IF ( (m_owner_type <> 'RS_GROUP')
1359: AND (m_owner_type <> 'RS_TEAM') )
1360: THEN
1358: IF ( (m_owner_type <> 'RS_GROUP')
1359: AND (m_owner_type <> 'RS_TEAM') )
1360: THEN
1361:
1362: l_owner_type:= 'RS_INDIVIDUAL';
1363: l_owner_type_actual := m_owner_type;
1364:
1365: else
1366:
1372: IF ( (m_assignee_type <> 'RS_GROUP')
1373: AND (m_assignee_type <> 'RS_TEAM') )
1374: THEN
1375:
1376: l_assignee_type := 'RS_INDIVIDUAL';
1377: l_assignee_type_actual := m_assignee_type;
1378:
1379: else
1380:
1569:
1570: RAISE fnd_api.g_exc_error;
1571: END;
1572: l_dist_from := 'GROUP_OWNED';
1573: l_dist_to := 'INDIVIDUAL_ASSIGNED';
1574: else
1575: l_dist_from := 'GROUP_OWNED';
1576: l_dist_to := 'INDIVIDUAL_ASSIGNED';
1577:
1572: l_dist_from := 'GROUP_OWNED';
1573: l_dist_to := 'INDIVIDUAL_ASSIGNED';
1574: else
1575: l_dist_from := 'GROUP_OWNED';
1576: l_dist_to := 'INDIVIDUAL_ASSIGNED';
1577:
1578: l_curr_ws_id := l_ws_id1;
1579: /*
1580: BEGIN
1653: l_distribution_status_id := 0;
1654:
1655: else
1656: if (l_dist_from = 'GROUP_OWNED') and
1657: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
1658: then
1659: if (l_owner_type = 'RS_GROUP') and
1660: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1661: then
1656: if (l_dist_from = 'GROUP_OWNED') and
1657: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
1658: then
1659: if (l_owner_type = 'RS_GROUP') and
1660: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1661: then
1662: l_distribution_status_id := 1;
1663: elsif (l_assignee_type = 'RS_INDIVIDUAL')
1664: then
1659: if (l_owner_type = 'RS_GROUP') and
1660: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1661: then
1662: l_distribution_status_id := 1;
1663: elsif (l_assignee_type = 'RS_INDIVIDUAL')
1664: then
1665: l_distribution_status_id := 3;
1666: else
1667: l_distribution_status_id := 0;
1668: end if;
1669: end if;
1670:
1671: /* if (l_dist_from = 'GROUP_OWNED') and
1672: (l_dist_to = 'INDIVIDUAL_OWNED')
1673: then
1674:
1675: if (l_owner_type = 'RS_GROUP')
1676: then
1674:
1675: if (l_owner_type = 'RS_GROUP')
1676: then
1677: l_distribution_status_id := 1;
1678: elsif (l_owner_type = 'RS_INDIVIDUAL')
1679: then
1680: l_distribution_status_id := 3;
1681: else
1682: l_distribution_status_id := 0;
1682: l_distribution_status_id := 0;
1683: end if;
1684:
1685: elsif (l_dist_from = 'GROUP_OWNED') and
1686: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
1687: then
1688:
1689: if (l_owner_type = 'RS_GROUP') and
1690: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1686: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
1687: then
1688:
1689: if (l_owner_type = 'RS_GROUP') and
1690: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1691: then
1692: l_distribution_status_id := 1;
1693: elsif (l_assignee_type = 'RS_INDIVIDUAL')
1694: then
1689: if (l_owner_type = 'RS_GROUP') and
1690: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
1691: then
1692: l_distribution_status_id := 1;
1693: elsif (l_assignee_type = 'RS_INDIVIDUAL')
1694: then
1695: l_distribution_status_id := 3;
1696: else
1697: l_distribution_status_id := 0;
1697: l_distribution_status_id := 0;
1698: end if;
1699:
1700: elsif (l_dist_from = 'GROUP_ASSIGNED') and
1701: (l_dist_to = 'INDIVIDUAL_OWNED')
1702: then
1703:
1704: if (l_assignee_type = 'RS_GROUP') and
1705: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
1701: (l_dist_to = 'INDIVIDUAL_OWNED')
1702: then
1703:
1704: if (l_assignee_type = 'RS_GROUP') and
1705: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
1706: then
1707: l_distribution_status_id := 1;
1708: elsif (l_owner_type = 'RS_INDIVIDUAL')
1709: then
1704: if (l_assignee_type = 'RS_GROUP') and
1705: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
1706: then
1707: l_distribution_status_id := 1;
1708: elsif (l_owner_type = 'RS_INDIVIDUAL')
1709: then
1710: l_distribution_status_id := 3;
1711: else
1712: l_distribution_status_id := 0;
1712: l_distribution_status_id := 0;
1713: end if;
1714:
1715: elsif (l_dist_from = 'GROUP_ASSIGNED') and
1716: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
1717: then
1718:
1719: if (l_assignee_type = 'RS_GROUP')
1720: then
1718:
1719: if (l_assignee_type = 'RS_GROUP')
1720: then
1721: l_distribution_status_id := 1;
1722: elsif (l_assignee_type = 'RS_INDIVIDUAL')
1723: then
1724: l_distribution_status_id := 3;
1725: else
1726: l_distribution_status_id := 0;
2028:
2029: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2030: l_token_str := '';
2031: l_dist_from := 'GROUP_OWNED';
2032: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2033: l_priority_code := 'LOW';
2034: l_array_size := 2000;
2035:
2036: SAVEPOINT sync_ws_details_sp;
2203: for cur_rec in c_pry_ws(l_obj_code)
2204: loop
2205:
2206: if (l_dist_from = 'GROUP_OWNED') and
2207: (l_dist_to = 'INDIVIDUAL_OWNED')
2208: then
2209:
2210: if (cur_rec.owner_type = 'RS_GROUP')
2211: then
2209:
2210: if (cur_rec.owner_type = 'RS_GROUP')
2211: then
2212: l_distribution_status_id := 1;
2213: elsif (cur_rec.owner_type = 'RS_INDIVIDUAL')
2214: then
2215: l_distribution_status_id := 3;
2216: else
2217: l_distribution_status_id := 0;
2217: l_distribution_status_id := 0;
2218: end if;
2219:
2220: elsif (l_dist_from = 'GROUP_OWNED') and
2221: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
2222: then
2223:
2224: if (cur_rec.owner_type = 'RS_GROUP') and
2225: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2221: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
2222: then
2223:
2224: if (cur_rec.owner_type = 'RS_GROUP') and
2225: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2226: then
2227: l_distribution_status_id := 1;
2228: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
2229: then
2224: if (cur_rec.owner_type = 'RS_GROUP') and
2225: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2226: then
2227: l_distribution_status_id := 1;
2228: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
2229: then
2230: l_distribution_status_id := 3;
2231: else
2232: l_distribution_status_id := 0;
2232: l_distribution_status_id := 0;
2233: end if;
2234:
2235: elsif (l_dist_from = 'GROUP_ASSIGNED') and
2236: (l_dist_to = 'INDIVIDUAL_OWNED')
2237: then
2238:
2239: if (cur_rec.assignee_type = 'RS_GROUP') and
2240: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
2236: (l_dist_to = 'INDIVIDUAL_OWNED')
2237: then
2238:
2239: if (cur_rec.assignee_type = 'RS_GROUP') and
2240: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
2241: then
2242: l_distribution_status_id := 1;
2243: elsif (cur_rec.owner_type= 'RS_INDIVIDUAL')
2244: then
2239: if (cur_rec.assignee_type = 'RS_GROUP') and
2240: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
2241: then
2242: l_distribution_status_id := 1;
2243: elsif (cur_rec.owner_type= 'RS_INDIVIDUAL')
2244: then
2245: l_distribution_status_id := 3;
2246: else
2247: l_distribution_status_id := 0;
2247: l_distribution_status_id := 0;
2248: end if;
2249:
2250: elsif (l_dist_from = 'GROUP_ASSIGNED') and
2251: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
2252: then
2253:
2254: if (cur_rec.assignee_type = 'RS_GROUP')
2255: then
2253:
2254: if (cur_rec.assignee_type = 'RS_GROUP')
2255: then
2256: l_distribution_status_id := 1;
2257: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
2258: then
2259: l_distribution_status_id := 3;
2260: else
2261: l_distribution_status_id := 0;
2490: if (l_set_dist_id_flag = 'T')
2491: then
2492:
2493: if (l_dist_from = 'GROUP_OWNED') and
2494: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
2495: then
2496: if (cur_rec.owner_type = 'RS_GROUP') and
2497: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2498: then
2493: if (l_dist_from = 'GROUP_OWNED') and
2494: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
2495: then
2496: if (cur_rec.owner_type = 'RS_GROUP') and
2497: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2498: then
2499: l_distribution_status_id := 1;
2500: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
2501: then
2496: if (cur_rec.owner_type = 'RS_GROUP') and
2497: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
2498: then
2499: l_distribution_status_id := 1;
2500: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
2501: then
2502: l_distribution_status_id := 3;
2503: else
2504: l_distribution_status_id := 0;
2657:
2658: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2659: l_token_str := '';
2660: l_dist_from := 'GROUP_OWNED';
2661: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2662: SAVEPOINT next_work_for_apps;
2663:
2664: x_return_status := fnd_api.g_ret_sts_success;
2665:
2829:
2830: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
2831: l_token_str := '';
2832: l_dist_from := 'GROUP_OWNED';
2833: l_dist_to := 'INDIVIDUAL_ASSIGNED';
2834: SAVEPOINT sync_dependent_wr_items_sp;
2835:
2836: x_return_status := fnd_api.g_ret_sts_success;
2837:
2999: if (l_set_dist_id_flag = 'T')
3000: then
3001:
3002: if (l_dist_from = 'GROUP_OWNED') and
3003: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3004: then
3005: if (l_owner_type = 'RS_GROUP') and
3006: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3007: then
3002: if (l_dist_from = 'GROUP_OWNED') and
3003: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3004: then
3005: if (l_owner_type = 'RS_GROUP') and
3006: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3007: then
3008: l_distribution_status_id := 1;
3009: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3010: then
3005: if (l_owner_type = 'RS_GROUP') and
3006: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3007: then
3008: l_distribution_status_id := 1;
3009: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3010: then
3011: l_distribution_status_id := 3;
3012: else
3013: l_distribution_status_id := 0;
3014: end if;
3015: end if;
3016:
3017: /* if (l_dist_from = 'GROUP_OWNED') and
3018: (l_dist_to = 'INDIVIDUAL_OWNED')
3019: then
3020:
3021: if (l_owner_type = 'RS_GROUP')
3022: then
3020:
3021: if (l_owner_type = 'RS_GROUP')
3022: then
3023: l_distribution_status_id := 1;
3024: elsif (l_owner_type = 'RS_INDIVIDUAL')
3025: then
3026: l_distribution_status_id := 3;
3027: else
3028: l_distribution_status_id := 0;
3028: l_distribution_status_id := 0;
3029: end if;
3030:
3031: elsif (l_dist_from = 'GROUP_OWNED') and
3032: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3033: then
3034:
3035: if (l_owner_type = 'RS_GROUP') and
3036: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3032: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3033: then
3034:
3035: if (l_owner_type = 'RS_GROUP') and
3036: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3037: then
3038: l_distribution_status_id := 1;
3039: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3040: then
3035: if (l_owner_type = 'RS_GROUP') and
3036: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3037: then
3038: l_distribution_status_id := 1;
3039: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3040: then
3041: l_distribution_status_id := 3;
3042: else
3043: l_distribution_status_id := 0;
3043: l_distribution_status_id := 0;
3044: end if;
3045:
3046: elsif (l_dist_from = 'GROUP_ASSIGNED') and
3047: (l_dist_to = 'INDIVIDUAL_OWNED')
3048: then
3049:
3050: if (l_assignee_type = 'RS_GROUP') and
3051: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3047: (l_dist_to = 'INDIVIDUAL_OWNED')
3048: then
3049:
3050: if (l_assignee_type = 'RS_GROUP') and
3051: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3052: then
3053: l_distribution_status_id := 1;
3054: elsif (l_owner_type = 'RS_INDIVIDUAL')
3055: then
3050: if (l_assignee_type = 'RS_GROUP') and
3051: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3052: then
3053: l_distribution_status_id := 1;
3054: elsif (l_owner_type = 'RS_INDIVIDUAL')
3055: then
3056: l_distribution_status_id := 3;
3057: else
3058: l_distribution_status_id := 0;
3058: l_distribution_status_id := 0;
3059: end if;
3060:
3061: elsif (l_dist_from = 'GROUP_ASSIGNED') and
3062: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3063: then
3064:
3065: if (l_assignee_type = 'RS_GROUP')
3066: then
3064:
3065: if (l_assignee_type = 'RS_GROUP')
3066: then
3067: l_distribution_status_id := 1;
3068: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3069: then
3070: l_distribution_status_id := 3;
3071: else
3072: l_distribution_status_id := 0;
3489: RAISE fnd_api.g_exc_error;
3490:
3491: END IF;
3492:
3493: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
3494:
3495: IF ( (p_owner_type <> 'RS_GROUP')
3496: AND (p_owner_type <> 'RS_TEAM') )
3497: THEN
3495: IF ( (p_owner_type <> 'RS_GROUP')
3496: AND (p_owner_type <> 'RS_TEAM') )
3497: THEN
3498:
3499: l_owner_type:= 'RS_INDIVIDUAL';
3500: l_owner_type_actual := p_owner_type;
3501:
3502: else
3503:
3509: IF ( (p_assignee_type <> 'RS_GROUP')
3510: AND (p_assignee_type <> 'RS_TEAM') )
3511: THEN
3512:
3513: l_assignee_type := 'RS_INDIVIDUAL';
3514: l_assignee_type_actual := p_assignee_type;
3515:
3516: else
3517:
3710:
3711: RAISE fnd_api.g_exc_error;
3712: END;
3713: l_dist_from := 'GROUP_OWNED';
3714: l_dist_to := 'INDIVIDUAL_ASSIGNED';
3715:
3716: else
3717: l_dist_from := 'GROUP_OWNED';
3718: l_dist_to := 'INDIVIDUAL_ASSIGNED';
3714: l_dist_to := 'INDIVIDUAL_ASSIGNED';
3715:
3716: else
3717: l_dist_from := 'GROUP_OWNED';
3718: l_dist_to := 'INDIVIDUAL_ASSIGNED';
3719:
3720: l_curr_ws_id := l_ws_id1;
3721: l_curr_ws_code := l_ws_code1;
3722: /*
3796: l_distribution_status_id := 0;
3797:
3798: else
3799: if (l_dist_from = 'GROUP_OWNED') and
3800: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3801: then
3802:
3803: if (l_owner_type = 'RS_GROUP') and
3804: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3800: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3801: then
3802:
3803: if (l_owner_type = 'RS_GROUP') and
3804: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3805: then
3806: l_distribution_status_id := 1;
3807: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3808: then
3803: if (l_owner_type = 'RS_GROUP') and
3804: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3805: then
3806: l_distribution_status_id := 1;
3807: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3808: then
3809: l_distribution_status_id := 3;
3810: else
3811: l_distribution_status_id := 0;
3812: end if;
3813: end if;
3814: /*
3815: if (l_dist_from = 'GROUP_OWNED') and
3816: (l_dist_to = 'INDIVIDUAL_OWNED')
3817: then
3818:
3819: if (l_owner_type = 'RS_GROUP')
3820: then
3818:
3819: if (l_owner_type = 'RS_GROUP')
3820: then
3821: l_distribution_status_id := 1;
3822: elsif (l_owner_type = 'RS_INDIVIDUAL')
3823: then
3824: l_distribution_status_id := 3;
3825: else
3826: l_distribution_status_id := 0;
3826: l_distribution_status_id := 0;
3827: end if;
3828:
3829: elsif (l_dist_from = 'GROUP_OWNED') and
3830: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3831: then
3832:
3833: if (l_owner_type = 'RS_GROUP') and
3834: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3830: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3831: then
3832:
3833: if (l_owner_type = 'RS_GROUP') and
3834: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3835: then
3836: l_distribution_status_id := 1;
3837: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3838: then
3833: if (l_owner_type = 'RS_GROUP') and
3834: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
3835: then
3836: l_distribution_status_id := 1;
3837: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3838: then
3839: l_distribution_status_id := 3;
3840: else
3841: l_distribution_status_id := 0;
3841: l_distribution_status_id := 0;
3842: end if;
3843:
3844: elsif (l_dist_from = 'GROUP_ASSIGNED') and
3845: (l_dist_to = 'INDIVIDUAL_OWNED')
3846: then
3847:
3848: if (l_assignee_type = 'RS_GROUP') and
3849: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3845: (l_dist_to = 'INDIVIDUAL_OWNED')
3846: then
3847:
3848: if (l_assignee_type = 'RS_GROUP') and
3849: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3850: then
3851: l_distribution_status_id := 1;
3852: elsif (l_owner_type = 'RS_INDIVIDUAL')
3853: then
3848: if (l_assignee_type = 'RS_GROUP') and
3849: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
3850: then
3851: l_distribution_status_id := 1;
3852: elsif (l_owner_type = 'RS_INDIVIDUAL')
3853: then
3854: l_distribution_status_id := 3;
3855: else
3856: l_distribution_status_id := 0;
3856: l_distribution_status_id := 0;
3857: end if;
3858:
3859: elsif (l_dist_from = 'GROUP_ASSIGNED') and
3860: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
3861: then
3862:
3863: if (l_assignee_type = 'RS_GROUP')
3864: then
3862:
3863: if (l_assignee_type = 'RS_GROUP')
3864: then
3865: l_distribution_status_id := 1;
3866: elsif (l_assignee_type = 'RS_INDIVIDUAL')
3867: then
3868: l_distribution_status_id := 3;
3869: else
3870: l_distribution_status_id := 0;
3898: l_ieu_comment_code5 := null;
3899:
3900: /******************************* Used only for Distribute **************************
3901: if (l_log_dist_from = 'GROUP_OWNED') and
3902: (l_log_dist_to = 'INDIVIDUAL_OWNED')
3903: then
3904: l_ieu_comment_code1 := 'GO_IO';
3905: elsif (l_log_dist_from = 'GROUP_OWNED') and
3906: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
3902: (l_log_dist_to = 'INDIVIDUAL_OWNED')
3903: then
3904: l_ieu_comment_code1 := 'GO_IO';
3905: elsif (l_log_dist_from = 'GROUP_OWNED') and
3906: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
3907: then
3908: l_ieu_comment_code1 := 'GO_IA';
3909: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
3910: (l_log_dist_to = 'INDIVIDUAL_OWNED')
3906: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
3907: then
3908: l_ieu_comment_code1 := 'GO_IA';
3909: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
3910: (l_log_dist_to = 'INDIVIDUAL_OWNED')
3911: then
3912: l_ieu_comment_code1 := 'GA_IO';
3913: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
3914: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
3910: (l_log_dist_to = 'INDIVIDUAL_OWNED')
3911: then
3912: l_ieu_comment_code1 := 'GA_IO';
3913: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
3914: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
3915: then
3916: l_ieu_comment_code1 := 'GA_IA';
3917: end if; *******************/ /* ieu comment code1 */
3918:
4979: RAISE fnd_api.g_exc_error;
4980:
4981: END IF;
4982:
4983: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
4984:
4985: IF ( (m_owner_type <> 'RS_GROUP')
4986: AND (m_owner_type <> 'RS_TEAM') )
4987: THEN
4985: IF ( (m_owner_type <> 'RS_GROUP')
4986: AND (m_owner_type <> 'RS_TEAM') )
4987: THEN
4988:
4989: l_owner_type:= 'RS_INDIVIDUAL';
4990: l_owner_type_actual := m_owner_type;
4991:
4992: else
4993:
4999: IF ( (m_assignee_type <> 'RS_GROUP')
5000: AND (m_assignee_type <> 'RS_TEAM') )
5001: THEN
5002:
5003: l_assignee_type := 'RS_INDIVIDUAL';
5004: l_assignee_type_actual := m_assignee_type;
5005:
5006: else
5007:
5197:
5198: RAISE fnd_api.g_exc_error;
5199: END;
5200: l_dist_from := 'GROUP_OWNED';
5201: l_dist_to := 'INDIVIDUAL_ASSIGNED';
5202: else
5203: l_dist_from := 'GROUP_OWNED';
5204: l_dist_to := 'INDIVIDUAL_ASSIGNED';
5205:
5200: l_dist_from := 'GROUP_OWNED';
5201: l_dist_to := 'INDIVIDUAL_ASSIGNED';
5202: else
5203: l_dist_from := 'GROUP_OWNED';
5204: l_dist_to := 'INDIVIDUAL_ASSIGNED';
5205:
5206: l_curr_ws_id := l_ws_id1;
5207: l_curr_ws_code := l_ws_code1;
5208: /*
5282: l_distribution_status_id := 0;
5283:
5284: else
5285: if (l_dist_from = 'GROUP_OWNED') and
5286: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
5287: then
5288: if (l_owner_type = 'RS_GROUP') and
5289: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5290: then
5285: if (l_dist_from = 'GROUP_OWNED') and
5286: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
5287: then
5288: if (l_owner_type = 'RS_GROUP') and
5289: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5290: then
5291: l_distribution_status_id := 1;
5292: elsif (l_assignee_type = 'RS_INDIVIDUAL')
5293: then
5288: if (l_owner_type = 'RS_GROUP') and
5289: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5290: then
5291: l_distribution_status_id := 1;
5292: elsif (l_assignee_type = 'RS_INDIVIDUAL')
5293: then
5294: l_distribution_status_id := 3;
5295: else
5296: l_distribution_status_id := 0;
5297: end if;
5298: end if;
5299:
5300: /* if (l_dist_from = 'GROUP_OWNED') and
5301: (l_dist_to = 'INDIVIDUAL_OWNED')
5302: then
5303:
5304: if (l_owner_type = 'RS_GROUP')
5305: then
5303:
5304: if (l_owner_type = 'RS_GROUP')
5305: then
5306: l_distribution_status_id := 1;
5307: elsif (l_owner_type = 'RS_INDIVIDUAL')
5308: then
5309: l_distribution_status_id := 3;
5310: else
5311: l_distribution_status_id := 0;
5311: l_distribution_status_id := 0;
5312: end if;
5313:
5314: elsif (l_dist_from = 'GROUP_OWNED') and
5315: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
5316: then
5317:
5318: if (l_owner_type = 'RS_GROUP') and
5319: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5315: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
5316: then
5317:
5318: if (l_owner_type = 'RS_GROUP') and
5319: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5320: then
5321: l_distribution_status_id := 1;
5322: elsif (l_assignee_type = 'RS_INDIVIDUAL')
5323: then
5318: if (l_owner_type = 'RS_GROUP') and
5319: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
5320: then
5321: l_distribution_status_id := 1;
5322: elsif (l_assignee_type = 'RS_INDIVIDUAL')
5323: then
5324: l_distribution_status_id := 3;
5325: else
5326: l_distribution_status_id := 0;
5326: l_distribution_status_id := 0;
5327: end if;
5328:
5329: elsif (l_dist_from = 'GROUP_ASSIGNED') and
5330: (l_dist_to = 'INDIVIDUAL_OWNED')
5331: then
5332:
5333: if (l_assignee_type = 'RS_GROUP') and
5334: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
5330: (l_dist_to = 'INDIVIDUAL_OWNED')
5331: then
5332:
5333: if (l_assignee_type = 'RS_GROUP') and
5334: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
5335: then
5336: l_distribution_status_id := 1;
5337: elsif (l_owner_type = 'RS_INDIVIDUAL')
5338: then
5333: if (l_assignee_type = 'RS_GROUP') and
5334: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
5335: then
5336: l_distribution_status_id := 1;
5337: elsif (l_owner_type = 'RS_INDIVIDUAL')
5338: then
5339: l_distribution_status_id := 3;
5340: else
5341: l_distribution_status_id := 0;
5341: l_distribution_status_id := 0;
5342: end if;
5343:
5344: elsif (l_dist_from = 'GROUP_ASSIGNED') and
5345: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
5346: then
5347:
5348: if (l_assignee_type = 'RS_GROUP')
5349: then
5347:
5348: if (l_assignee_type = 'RS_GROUP')
5349: then
5350: l_distribution_status_id := 1;
5351: elsif (l_assignee_type = 'RS_INDIVIDUAL')
5352: then
5353: l_distribution_status_id := 3;
5354: else
5355: l_distribution_status_id := 0;
5406: l_ieu_comment_code4 := null;
5407: l_ieu_comment_code5 := null;
5408:
5409: if (l_log_dist_from = 'GROUP_OWNED') and
5410: (l_log_dist_to = 'INDIVIDUAL_OWNED')
5411: then
5412: l_ieu_comment_code1 := 'GO_IO';
5413: elsif (l_log_dist_from = 'GROUP_OWNED') and
5414: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
5410: (l_log_dist_to = 'INDIVIDUAL_OWNED')
5411: then
5412: l_ieu_comment_code1 := 'GO_IO';
5413: elsif (l_log_dist_from = 'GROUP_OWNED') and
5414: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
5415: then
5416: l_ieu_comment_code1 := 'GO_IA';
5417: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
5418: (l_log_dist_to = 'INDIVIDUAL_OWNED')
5414: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
5415: then
5416: l_ieu_comment_code1 := 'GO_IA';
5417: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
5418: (l_log_dist_to = 'INDIVIDUAL_OWNED')
5419: then
5420: l_ieu_comment_code1 := 'GA_IO';
5421: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
5422: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
5418: (l_log_dist_to = 'INDIVIDUAL_OWNED')
5419: then
5420: l_ieu_comment_code1 := 'GA_IO';
5421: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
5422: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
5423: then
5424: l_ieu_comment_code1 := 'GA_IA';
5425: end if;
5426: **********************************************************************/
5564: end if;
5565: */ end if;
5566: end if; /* requeue */
5567: -- Reassign
5568: if ( (l_prev_assignee_type = 'RS_INDIVIDUAL') and (l_assignee_type = 'RS_INDIVIDUAL') )
5569: then
5570: -- dbms_output.put_line('asg types are ind');
5571: if (l_prev_assignee_id <> m_assignee_id)
5572: then
6866: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
6867: l_priority_code := 'LOW';
6868: l_token_str := '';
6869: l_dist_from := 'GROUP_OWNED';
6870: l_dist_to := 'INDIVIDUAL_ASSIGNED';
6871: l_array_size := 2000;
6872:
6873: SAVEPOINT sync_ws_details_sp;
6874:
7040: for cur_rec in c_pry_ws(l_obj_code)
7041: loop
7042:
7043: if (l_dist_from = 'GROUP_OWNED') and
7044: (l_dist_to = 'INDIVIDUAL_OWNED')
7045: then
7046:
7047: if (cur_rec.owner_type = 'RS_GROUP')
7048: then
7046:
7047: if (cur_rec.owner_type = 'RS_GROUP')
7048: then
7049: l_distribution_status_id := 1;
7050: elsif (cur_rec.owner_type = 'RS_INDIVIDUAL')
7051: then
7052: l_distribution_status_id := 3;
7053: else
7054: l_distribution_status_id := 0;
7054: l_distribution_status_id := 0;
7055: end if;
7056:
7057: elsif (l_dist_from = 'GROUP_OWNED') and
7058: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7059: then
7060:
7061: if (cur_rec.owner_type = 'RS_GROUP') and
7062: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7058: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7059: then
7060:
7061: if (cur_rec.owner_type = 'RS_GROUP') and
7062: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7063: then
7064: l_distribution_status_id := 1;
7065: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7066: then
7061: if (cur_rec.owner_type = 'RS_GROUP') and
7062: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7063: then
7064: l_distribution_status_id := 1;
7065: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7066: then
7067: l_distribution_status_id := 3;
7068: else
7069: l_distribution_status_id := 0;
7069: l_distribution_status_id := 0;
7070: end if;
7071:
7072: elsif (l_dist_from = 'GROUP_ASSIGNED') and
7073: (l_dist_to = 'INDIVIDUAL_OWNED')
7074: then
7075:
7076: if (cur_rec.assignee_type = 'RS_GROUP') and
7077: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7073: (l_dist_to = 'INDIVIDUAL_OWNED')
7074: then
7075:
7076: if (cur_rec.assignee_type = 'RS_GROUP') and
7077: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7078: then
7079: l_distribution_status_id := 1;
7080: elsif (cur_rec.owner_type= 'RS_INDIVIDUAL')
7081: then
7076: if (cur_rec.assignee_type = 'RS_GROUP') and
7077: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7078: then
7079: l_distribution_status_id := 1;
7080: elsif (cur_rec.owner_type= 'RS_INDIVIDUAL')
7081: then
7082: l_distribution_status_id := 3;
7083: else
7084: l_distribution_status_id := 0;
7084: l_distribution_status_id := 0;
7085: end if;
7086:
7087: elsif (l_dist_from = 'GROUP_ASSIGNED') and
7088: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7089: then
7090:
7091: if (cur_rec.assignee_type = 'RS_GROUP')
7092: then
7090:
7091: if (cur_rec.assignee_type = 'RS_GROUP')
7092: then
7093: l_distribution_status_id := 1;
7094: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7095: then
7096: l_distribution_status_id := 3;
7097: else
7098: l_distribution_status_id := 0;
7377: if (l_set_dist_id_flag = 'T')
7378: then
7379:
7380: if (l_dist_from = 'GROUP_OWNED') and
7381: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7382: then
7383: if (cur_rec.owner_type = 'RS_GROUP') and
7384: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7385: then
7380: if (l_dist_from = 'GROUP_OWNED') and
7381: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7382: then
7383: if (cur_rec.owner_type = 'RS_GROUP') and
7384: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7385: then
7386: l_distribution_status_id := 1;
7387: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7388: then
7383: if (cur_rec.owner_type = 'RS_GROUP') and
7384: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7385: then
7386: l_distribution_status_id := 1;
7387: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7388: then
7389: l_distribution_status_id := 3;
7390: else
7391: l_distribution_status_id := 0;
7392: end if;
7393: end if;
7394:
7395: /* if (l_dist_from = 'GROUP_OWNED') and
7396: (l_dist_to = 'INDIVIDUAL_OWNED')
7397: then
7398:
7399: if (cur_rec.owner_type = 'RS_GROUP')
7400: then
7398:
7399: if (cur_rec.owner_type = 'RS_GROUP')
7400: then
7401: l_distribution_status_id := 1;
7402: elsif (cur_rec.owner_type = 'RS_INDIVIDUAL')
7403: then
7404: l_distribution_status_id := 3;
7405: else
7406: l_distribution_status_id := 0;
7406: l_distribution_status_id := 0;
7407: end if;
7408:
7409: elsif (l_dist_from = 'GROUP_OWNED') and
7410: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7411: then
7412:
7413: if (cur_rec.owner_type = 'RS_GROUP') and
7414: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7410: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7411: then
7412:
7413: if (cur_rec.owner_type = 'RS_GROUP') and
7414: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7415: then
7416: l_distribution_status_id := 1;
7417: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7418: then
7413: if (cur_rec.owner_type = 'RS_GROUP') and
7414: ( (cur_rec.assignee_type is null) OR (cur_rec.assignee_type <> 'RS_INDIVIDUAL') )
7415: then
7416: l_distribution_status_id := 1;
7417: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7418: then
7419: l_distribution_status_id := 3;
7420: else
7421: l_distribution_status_id := 0;
7421: l_distribution_status_id := 0;
7422: end if;
7423:
7424: elsif (l_dist_from = 'GROUP_ASSIGNED') and
7425: (l_dist_to = 'INDIVIDUAL_OWNED')
7426: then
7427:
7428: if (cur_rec.assignee_type = 'RS_GROUP') and
7429: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7425: (l_dist_to = 'INDIVIDUAL_OWNED')
7426: then
7427:
7428: if (cur_rec.assignee_type = 'RS_GROUP') and
7429: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7430: then
7431: l_distribution_status_id := 1;
7432: elsif (cur_rec.owner_type = 'RS_INDIVIDUAL')
7433: then
7428: if (cur_rec.assignee_type = 'RS_GROUP') and
7429: ( (cur_rec.owner_type is null) OR (cur_rec.owner_type <> 'RS_INDIVIDUAL') )
7430: then
7431: l_distribution_status_id := 1;
7432: elsif (cur_rec.owner_type = 'RS_INDIVIDUAL')
7433: then
7434: l_distribution_status_id := 3;
7435: else
7436: l_distribution_status_id := 0;
7436: l_distribution_status_id := 0;
7437: end if;
7438:
7439: elsif (l_dist_from = 'GROUP_ASSIGNED') and
7440: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
7441: then
7442:
7443: if (cur_rec.assignee_type = 'RS_GROUP')
7444: then
7442:
7443: if (cur_rec.assignee_type = 'RS_GROUP')
7444: then
7445: l_distribution_status_id := 1;
7446: elsif (cur_rec.assignee_type = 'RS_INDIVIDUAL')
7447: then
7448: l_distribution_status_id := 3;
7449: else
7450: l_distribution_status_id := 0;
7895:
7896: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
7897: l_token_str := '';
7898: l_dist_from := 'GROUP_OWNED';
7899: l_dist_to := 'INDIVIDUAL_ASSIGNED';
7900: SAVEPOINT next_work_for_apps;
7901:
7902: x_return_status := fnd_api.g_ret_sts_success;
7903:
8472:
8473: l_audit_log_val := FND_PROFILE.VALUE('IEU_WR_DIST_AUDIT_LOG');
8474: l_token_str := '';
8475: l_dist_from := 'GROUP_OWNED';
8476: l_dist_to := 'INDIVIDUAL_ASSIGNED';
8477: SAVEPOINT sync_dependent_wr_items_sp;
8478:
8479: x_return_status := fnd_api.g_ret_sts_success;
8480:
8646: if (l_set_dist_id_flag = 'T')
8647: then
8648:
8649: if (l_dist_from = 'GROUP_OWNED') and
8650: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
8651: then
8652: if (l_owner_type = 'RS_GROUP') and
8653: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8654: then
8649: if (l_dist_from = 'GROUP_OWNED') and
8650: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
8651: then
8652: if (l_owner_type = 'RS_GROUP') and
8653: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8654: then
8655: l_distribution_status_id := 1;
8656: elsif (l_assignee_type = 'RS_INDIVIDUAL')
8657: then
8652: if (l_owner_type = 'RS_GROUP') and
8653: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8654: then
8655: l_distribution_status_id := 1;
8656: elsif (l_assignee_type = 'RS_INDIVIDUAL')
8657: then
8658: l_distribution_status_id := 3;
8659: else
8660: l_distribution_status_id := 0;
8661: end if;
8662: end if;
8663:
8664: /* if (l_dist_from = 'GROUP_OWNED') and
8665: (l_dist_to = 'INDIVIDUAL_OWNED')
8666: then
8667:
8668: if (l_owner_type = 'RS_GROUP')
8669: then
8667:
8668: if (l_owner_type = 'RS_GROUP')
8669: then
8670: l_distribution_status_id := 1;
8671: elsif (l_owner_type = 'RS_INDIVIDUAL')
8672: then
8673: l_distribution_status_id := 3;
8674: else
8675: l_distribution_status_id := 0;
8675: l_distribution_status_id := 0;
8676: end if;
8677:
8678: elsif (l_dist_from = 'GROUP_OWNED') and
8679: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
8680: then
8681:
8682: if (l_owner_type = 'RS_GROUP') and
8683: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8679: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
8680: then
8681:
8682: if (l_owner_type = 'RS_GROUP') and
8683: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8684: then
8685: l_distribution_status_id := 1;
8686: elsif (l_assignee_type = 'RS_INDIVIDUAL')
8687: then
8682: if (l_owner_type = 'RS_GROUP') and
8683: ( (l_assignee_type is null) OR (l_assignee_type <> 'RS_INDIVIDUAL') )
8684: then
8685: l_distribution_status_id := 1;
8686: elsif (l_assignee_type = 'RS_INDIVIDUAL')
8687: then
8688: l_distribution_status_id := 3;
8689: else
8690: l_distribution_status_id := 0;
8690: l_distribution_status_id := 0;
8691: end if;
8692:
8693: elsif (l_dist_from = 'GROUP_ASSIGNED') and
8694: (l_dist_to = 'INDIVIDUAL_OWNED')
8695: then
8696:
8697: if (l_assignee_type = 'RS_GROUP') and
8698: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
8694: (l_dist_to = 'INDIVIDUAL_OWNED')
8695: then
8696:
8697: if (l_assignee_type = 'RS_GROUP') and
8698: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
8699: then
8700: l_distribution_status_id := 1;
8701: elsif (l_owner_type = 'RS_INDIVIDUAL')
8702: then
8697: if (l_assignee_type = 'RS_GROUP') and
8698: ( (l_owner_type is null) OR (l_owner_type <> 'RS_INDIVIDUAL') )
8699: then
8700: l_distribution_status_id := 1;
8701: elsif (l_owner_type = 'RS_INDIVIDUAL')
8702: then
8703: l_distribution_status_id := 3;
8704: else
8705: l_distribution_status_id := 0;
8705: l_distribution_status_id := 0;
8706: end if;
8707:
8708: elsif (l_dist_from = 'GROUP_ASSIGNED') and
8709: (l_dist_to = 'INDIVIDUAL_ASSIGNED')
8710: then
8711:
8712: if (l_assignee_type = 'RS_GROUP')
8713: then
8711:
8712: if (l_assignee_type = 'RS_GROUP')
8713: then
8714: l_distribution_status_id := 1;
8715: elsif (l_assignee_type = 'RS_INDIVIDUAL')
8716: then
8717: l_distribution_status_id := 3;
8718: else
8719: l_distribution_status_id := 0;
8749: l_ieu_comment_code5 := null;
8750:
8751: /******************************* Used only for Distribute **************************
8752: if (l_log_dist_from = 'GROUP_OWNED') and
8753: (l_log_dist_to = 'INDIVIDUAL_OWNED')
8754: then
8755: l_ieu_comment_code1 := 'GO_IO';
8756: elsif (l_log_dist_from = 'GROUP_OWNED') and
8757: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
8753: (l_log_dist_to = 'INDIVIDUAL_OWNED')
8754: then
8755: l_ieu_comment_code1 := 'GO_IO';
8756: elsif (l_log_dist_from = 'GROUP_OWNED') and
8757: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
8758: then
8759: l_ieu_comment_code1 := 'GO_IA';
8760: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
8761: (l_log_dist_to = 'INDIVIDUAL_OWNED')
8757: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
8758: then
8759: l_ieu_comment_code1 := 'GO_IA';
8760: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
8761: (l_log_dist_to = 'INDIVIDUAL_OWNED')
8762: then
8763: l_ieu_comment_code1 := 'GA_IO';
8764: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
8765: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
8761: (l_log_dist_to = 'INDIVIDUAL_OWNED')
8762: then
8763: l_ieu_comment_code1 := 'GA_IO';
8764: elsif (l_log_dist_from = 'GROUP_ASSIGNED') and
8765: (l_log_dist_to = 'INDIVIDUAL_ASSIGNED')
8766: then
8767: l_ieu_comment_code1 := 'GA_IA';
8768: end if;
8769: ********************************************************************/
10867: , A.DIST_TO
10868: ) =
10869: (SELECT C.DIST_ST_BASED_ON_PARENT_FLAG
10870: , 'GROUP_OWNED'
10871: , 'INDIVIDUAL_ASSIGNED'
10872: FROM IEU_UWQM_WORK_SOURCES_B B
10873: , IEU_UWQM_WS_ASSCT_PROPS C
10874: WHERE A.ASSOCIATION_WS_ID = B.WS_ID
10875: AND B.WS_ID = C.WS_ID
10902:
10903:
10904: -- All validations are successful and continue to set the required values
10905:
10906: -- If OWNER_TYPE or ASSIGNEE_TYPE is not RS_GROUP then set it to RS_INDIVIDUAL
10907: -- Set Work Item Status Id
10908: -- set PRIORITY_ID and PRIORITY_LEVEL
10909:
10910: UPDATE IEU_UWQM_ITEMS_GTT A
10907: -- Set Work Item Status Id
10908: -- set PRIORITY_ID and PRIORITY_LEVEL
10909:
10910: UPDATE IEU_UWQM_ITEMS_GTT A
10911: SET A.OWNER_TYPE = CASE WHEN (A.OWNER_TYPE_ACTUAL <> 'RS_GROUP' AND A.OWNER_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
10912: ELSE A.OWNER_TYPE_ACTUAL
10913: END
10914: , A.ASSIGNEE_TYPE = CASE WHEN (A.ASSIGNEE_TYPE_ACTUAL <> 'RS_GROUP' AND A.ASSIGNEE_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
10915: ELSE A.ASSIGNEE_TYPE_ACTUAL
10910: UPDATE IEU_UWQM_ITEMS_GTT A
10911: SET A.OWNER_TYPE = CASE WHEN (A.OWNER_TYPE_ACTUAL <> 'RS_GROUP' AND A.OWNER_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
10912: ELSE A.OWNER_TYPE_ACTUAL
10913: END
10914: , A.ASSIGNEE_TYPE = CASE WHEN (A.ASSIGNEE_TYPE_ACTUAL <> 'RS_GROUP' AND A.ASSIGNEE_TYPE_ACTUAL <> 'RS_TEAM') THEN 'RS_INDIVIDUAL'
10915: ELSE A.ASSIGNEE_TYPE_ACTUAL
10916: END
10917: , A.STATUS_ID = DECODE(A.WORKITEM_STATUS, 'OPEN', 0, 'CLOSE', 3, 'DELETE', 4, 'SLEEP', 5, A.STATUS_ID)
10918: , ( A.PRIORITY_ID
10926:
10927:
10928: UPDATE IEU_UWQM_ITEMS_GTT A
10929: SET A.DIST_FROM = 'GROUP_OWNED'
10930: , A.DIST_TO = 'INDIVIDUAL_ASSIGNED'
10931: WHERE A.PROCESSING_SET_ID = P_PROCESSING_SET_ID
10932: AND A.ASSOCIATION_WS_ID IS NULL;
10933:
10934: UPDATE IEU_UWQM_ITEMS_GTT A
10967:
10968: UPDATE IEU_UWQM_ITEMS_GTT
10969: SET DISTRIBUTION_STATUS_ID = CASE WHEN (DIST_ID_FLAG = 'T') THEN
10970: CASE WHEN (PARENT_DIST_STATUS_ID <> 3) THEN 0
10971: ELSE CASE WHEN (DIST_FROM = 'GROUP_OWNED') AND (DIST_TO = 'INDIVIDUAL_ASSIGNED') THEN
10972: CASE WHEN (OWNER_TYPE = 'RS_GROUP') AND ((ASSIGNEE_TYPE IS NULL)
10973: OR (ASSIGNEE_TYPE <> 'RS_INDIVIDUAL')) THEN 1
10974: ELSE CASE WHEN (ASSIGNEE_TYPE = 'RS_INDIVIDUAL') THEN 3
10975: ELSE 0
10969: SET DISTRIBUTION_STATUS_ID = CASE WHEN (DIST_ID_FLAG = 'T') THEN
10970: CASE WHEN (PARENT_DIST_STATUS_ID <> 3) THEN 0
10971: ELSE CASE WHEN (DIST_FROM = 'GROUP_OWNED') AND (DIST_TO = 'INDIVIDUAL_ASSIGNED') THEN
10972: CASE WHEN (OWNER_TYPE = 'RS_GROUP') AND ((ASSIGNEE_TYPE IS NULL)
10973: OR (ASSIGNEE_TYPE <> 'RS_INDIVIDUAL')) THEN 1
10974: ELSE CASE WHEN (ASSIGNEE_TYPE = 'RS_INDIVIDUAL') THEN 3
10975: ELSE 0
10976: END
10977: END
10970: CASE WHEN (PARENT_DIST_STATUS_ID <> 3) THEN 0
10971: ELSE CASE WHEN (DIST_FROM = 'GROUP_OWNED') AND (DIST_TO = 'INDIVIDUAL_ASSIGNED') THEN
10972: CASE WHEN (OWNER_TYPE = 'RS_GROUP') AND ((ASSIGNEE_TYPE IS NULL)
10973: OR (ASSIGNEE_TYPE <> 'RS_INDIVIDUAL')) THEN 1
10974: ELSE CASE WHEN (ASSIGNEE_TYPE = 'RS_INDIVIDUAL') THEN 3
10975: ELSE 0
10976: END
10977: END
10978: ELSE 0
11670:
11671: if (l_ws_type = 'ASSOCIATION')
11672: then
11673:
11674: select IEU_UWQM_ITEMS_GTT_S1.NEXTVAL into l_processing_set_id from dual;
11675:
11676: open c_task(l_parent_obj_code);
11677: loop
11678: