eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_WF_INTEGRATION_PUB dependencies on WF_LOCAL_SYNCH

Line 300: /* Changed the code to call Wf_local_synch instead of Wf_Directory

296: FETCH partner_party_id_cur INTO l_person_party_id;
297: CLOSE partner_party_id_cur;
298: end if;
299:
300: /* Changed the code to call Wf_local_synch instead of Wf_Directory
301: Fix for bug # 2671368 */
302: AddParameterToList('USER_NAME',l_res_usr_role_name,l_list);
303: AddParameterToList('DISPLAYNAME',p_resource_name,l_list);
304: AddParameterToList('MAIL',p_email_address,l_list);

Line 308: Wf_local_synch.propagate_role(

304: AddParameterToList('MAIL',p_email_address,l_list);
305: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
306: AddParameterToList('PERSON_PARTY_ID',l_person_party_id,l_list);
307:
308: Wf_local_synch.propagate_role(
309: p_orig_system => l_res_usr_orig_system,
310: p_orig_system_id => p_resource_id,
311: p_attributes => l_list,
312: p_start_date => l_start_date_active,

Line 317: Wf_local_synch.propagate_user_role(

313: p_expiration_date => l_end_date_active);
314:
315: l_list.DELETE;
316:
317: Wf_local_synch.propagate_user_role(
318: p_user_orig_system => l_res_usr_orig_system,
319: p_user_orig_system_id => p_resource_id,
320: p_role_orig_system => l_res_usr_orig_system,
321: p_role_orig_system_id => p_resource_id,

Line 429: /* Changed the code to call Wf_local_synch instead of Wf_Directory

425: elsif (ll_category = 'PARTY' OR ll_category = 'PARTNER') then
426: l_person_party_id := ll_source_id;
427: end if;
428:
429: /* Changed the code to call Wf_local_synch instead of Wf_Directory
430: Fix for bug # 2671368 */
431:
432: AddParameterToList('USER_NAME',ll_role_name,l_list);
433: AddParameterToList('DISPLAYNAME',ll_role_display_name,l_list);

Line 438: Wf_local_synch.propagate_role(

434: AddParameterToList('MAIL',ll_email_address,l_list);
435: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
436: AddParameterToList('PERSON_PARTY_ID',l_person_party_id,l_list);
437:
438: Wf_local_synch.propagate_role(
439: p_orig_system => ll_role_orig_system,
440: p_orig_system_id => ll_role_orig_system_id,
441: p_attributes => l_list,
442: p_start_date => ll_start_date_active,

Line 447: Wf_local_synch.propagate_user_role(

443: p_expiration_date => ll_expiration_date);
444:
445: l_list.DELETE;
446:
447: Wf_local_synch.propagate_user_role(
448: p_user_orig_system => ll_role_orig_system,
449: p_user_orig_system_id => ll_role_orig_system_id,
450: p_role_orig_system => ll_role_orig_system,
451: p_role_orig_system_id => ll_role_orig_system_id,

Line 493: /* Changed the code to call Wf_local_synch instead of Wf_Directory

489: elsif (ll_category = 'PARTY' OR ll_category = 'PARTNER') then
490: l_person_party_id := ll_source_id;
491: end if;
492:
493: /* Changed the code to call Wf_local_synch instead of Wf_Directory
494: Fix for bug # 2671368 */
495:
496: if ((nvl(ll_expiration_date,l_sysdate) < l_sysdate)) then
497: Wf_local_synch.propagate_user_role(

Line 497: Wf_local_synch.propagate_user_role(

493: /* Changed the code to call Wf_local_synch instead of Wf_Directory
494: Fix for bug # 2671368 */
495:
496: if ((nvl(ll_expiration_date,l_sysdate) < l_sysdate)) then
497: Wf_local_synch.propagate_user_role(
498: p_user_orig_system => ll_role_orig_system,
499: p_user_orig_system_id => ll_role_orig_system_id,
500: p_role_orig_system => ll_role_orig_system,
501: p_role_orig_system_id => ll_role_orig_system_id,

Line 513: Wf_local_synch.propagate_role(

509: AddParameterToList('ORCLISENABLED',ll_status,l_list);
510: AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
511: AddParameterToList('PERSON_PARTY_ID',l_person_party_id,l_list);
512:
513: Wf_local_synch.propagate_role(
514: p_orig_system => ll_role_orig_system,
515: p_orig_system_id => ll_role_orig_system_id,
516: p_attributes => l_list,
517: p_start_date => ll_start_date_active,

Line 523: Wf_local_synch.propagate_user_role(

519:
520: l_list.DELETE;
521:
522: if ((nvl(ll_expiration_date,l_sysdate) >= l_sysdate)) then
523: Wf_local_synch.propagate_user_role(
524: p_user_orig_system => ll_role_orig_system,
525: p_user_orig_system_id => ll_role_orig_system_id,
526: p_role_orig_system => ll_role_orig_system,
527: p_role_orig_system_id => ll_role_orig_system_id,

Line 593: /* Changed the code to call Wf_local_synch instead of Wf_Directory

589: l_g_miss_date date := trunc(to_date('31-12-4712','DD-MM-YYYY'));
590:
591: BEGIN
592:
593: /* Changed the code to call Wf_local_synch instead of Wf_Directory
594: Fix for bug # 2671368 */
595:
596: l_mem_role_start_date := sysdate;
597: l_mem_role_end_date := l_g_miss_date;

Line 608: Wf_local_synch.propagate_user_role(

604: FETCH grp_wfrole_cur INTO l_grp_role_name;
605: if grp_wfrole_cur%FOUND then /* If the group has a corresponding record in wf_local_user */
606: if ll_old_user_orig_system is NOT NULL then
607: BEGIN
608: Wf_local_synch.propagate_user_role(
609: p_user_orig_system => ll_old_user_orig_system,
610: p_user_orig_system_id => ll_old_user_orig_system_id,
611: p_role_orig_system => g_grp_orig_system,
612: p_role_orig_system_id => l_role_orig_system_id,

Line 638: Wf_local_synch.propagate_user_role(

634: -- p_role_end_date => i.end_date_active,
635: -- x_user_role_start_date => l_mem_role_start_date,
636: -- x_user_role_end_date => l_mem_role_end_date);
637:
638: Wf_local_synch.propagate_user_role(
639: p_user_orig_system => ll_new_user_orig_system,
640: p_user_orig_system_id => ll_new_user_orig_system_id,
641: p_role_orig_system => g_grp_orig_system,
642: p_role_orig_system_id => l_role_orig_system_id,

Line 668: Wf_local_synch.propagate_user_role(

664: if tm_wfrole_cur%FOUND then /* If the team has a corresponding record in wf_local_user */
665: if ll_old_user_orig_system is NOT NULL then
666: BEGIN
667:
668: Wf_local_synch.propagate_user_role(
669: p_user_orig_system => ll_old_user_orig_system,
670: p_user_orig_system_id => ll_old_user_orig_system_id,
671: p_role_orig_system => g_team_orig_system,
672: p_role_orig_system_id => l_role_orig_system_id,

Line 698: Wf_local_synch.propagate_user_role(

694: -- p_role_end_date => i.end_date_active,
695: -- x_user_role_start_date => l_mem_role_start_date,
696: -- x_user_role_end_date => l_mem_role_end_date);
697:
698: Wf_local_synch.propagate_user_role(
699: p_user_orig_system => ll_new_user_orig_system,
700: p_user_orig_system_id => ll_new_user_orig_system_id,
701: p_role_orig_system => g_team_orig_system,
702: p_role_orig_system_id => l_role_orig_system_id,

Line 756: The new Wf_local_synch API accepts start and end date for roles and user roles */

752: end if; /* End of - If the resource has a corresponding record in wf_local_user */
753: CLOSE res_wfrole_cur;
754:
755: /* Commented the below if condition to check the Resource validitiy.
756: The new Wf_local_synch API accepts start and end date for roles and user roles */
757:
758: -- /* If the Resource is VALID within the new date range */
759: -- if ( (l_start_date_active <= l_sysdate) AND
760: -- ((l_end_date_active >= l_sysdate) OR (l_end_date_active is NULL)) ) then

Line 1087: Wf_local_synch.propagate_user_role(

1083: fnd_msg_pub.Initialize;
1084: end if;
1085:
1086: for i in res_user_role_cur LOOP
1087: Wf_local_synch.propagate_user_role(
1088: p_user_orig_system => l_res_usr_orig_system,
1089: p_user_orig_system_id => p_resource_id,
1090: p_role_orig_system => i.role_orig_system,
1091: p_role_orig_system_id => i.role_orig_system_id,

Line 1096: /* Changed the code to call Wf_local_synch instead of Wf_Directory

1092: p_expiration_date => l_sysdate-1);
1093:
1094: END LOOP;
1095:
1096: /* Changed the code to call Wf_local_synch instead of Wf_Directory
1097: Fix for bug # 2671368 */
1098:
1099: AddParameterToList('USER_NAME',l_res_usr_role_name,l_list);
1100: AddParameterToList('RAISEERRORS','TRUE',l_list);

Line 1103: Wf_local_synch.propagate_role(

1099: AddParameterToList('USER_NAME',l_res_usr_role_name,l_list);
1100: AddParameterToList('RAISEERRORS','TRUE',l_list);
1101: AddParameterToList('DELETE','TRUE',l_list);
1102:
1103: Wf_local_synch.propagate_role(
1104: p_orig_system => l_res_usr_orig_system,
1105: p_orig_system_id => p_resource_id,
1106: p_attributes => l_list,
1107: p_expiration_date => l_sysdate-1);

Line 1159: /* Changed the code to call Wf_local_synch instead of Wf_Directory

1155: -- l_end_date_active >= l_sysdate)) THEN
1156: if ((l_end_date_active >= l_sysdate) OR (l_end_date_active is NULL)) then
1157: /* Create role only if the group is currently active or future active*/
1158:
1159: /* Changed the code to call Wf_local_synch instead of Wf_Directory
1160: Fix for bug # 2671368 */
1161:
1162: AddParameterToList('USER_NAME',l_grp_role_name,l_list);
1163: AddParameterToList('DISPLAYNAME',p_group_name,l_list);

Line 1168: Wf_local_synch.propagate_role(

1164: AddParameterToList('MAIL',p_email_address,l_list);
1165: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1166: AddParameterToList('RAISEERRORS','TRUE',l_list);
1167:
1168: Wf_local_synch.propagate_role(
1169: p_orig_system => g_grp_orig_system,
1170: p_orig_system_id => p_group_id,
1171: p_attributes => l_list,
1172: p_start_date => l_start_date_active,

Line 1177: Wf_local_synch.propagate_user_role(

1173: p_expiration_date => l_end_date_active);
1174:
1175: l_list.DELETE;
1176:
1177: Wf_local_synch.propagate_user_role(
1178: p_user_orig_system => g_grp_orig_system,
1179: p_user_orig_system_id => p_group_id,
1180: p_role_orig_system => g_grp_orig_system,
1181: p_role_orig_system_id => p_group_id,

Line 1312: Wf_local_synch.propagate_role(

1308: AddParameterToList('MAIL',p_email_address,l_list);
1309: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1310: AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
1311:
1312: Wf_local_synch.propagate_role(
1313: p_orig_system => g_grp_orig_system,
1314: p_orig_system_id => p_group_id,
1315: p_attributes => l_list,
1316: p_start_date => l_start_date_active,

Line 1321: Wf_local_synch.propagate_user_role(

1317: p_expiration_date => l_end_date_active);
1318:
1319: l_list.DELETE;
1320:
1321: Wf_local_synch.propagate_user_role(
1322: p_user_orig_system => g_grp_orig_system,
1323: p_user_orig_system_id => p_group_id,
1324: p_role_orig_system => g_grp_orig_system,
1325: p_role_orig_system_id => p_group_id,

Line 1347: Wf_local_synch.propagate_user_role(

1343: l_mem_role_end_date := i.grp_mem_end_date;
1344: end if;
1345:
1346: IF l_grp_mem_user_name is not null THEN
1347: Wf_local_synch.propagate_user_role(
1348: p_user_orig_system => l_grp_mem_orig_system,
1349: p_user_orig_system_id => l_grp_mem_orig_system_id,
1350: p_role_orig_system => g_grp_orig_system,
1351: p_role_orig_system_id => p_group_id,

Line 1372: Wf_local_synch.propagate_user_role(

1368: FETCH c_role_exists into l_check_role;
1369: CLOSE c_role_exists;
1370:
1371: IF (l_check_role = 'Y') THEN
1372: Wf_local_synch.propagate_user_role(
1373: p_user_orig_system => g_grp_orig_system,
1374: p_user_orig_system_id => p_group_id,
1375: p_role_orig_system => g_team_orig_system,
1376: p_role_orig_system_id => j.team_id,

Line 1385: Wf_local_synch.propagate_user_role(

1381: END LOOP;
1382: end if;
1383: if ((nvl(l_end_date_active,l_sysdate) < l_sysdate)) then
1384:
1385: Wf_local_synch.propagate_user_role(
1386: p_user_orig_system => g_grp_orig_system,
1387: p_user_orig_system_id => p_group_id,
1388: p_role_orig_system => g_grp_orig_system,
1389: p_role_orig_system_id => p_group_id,

Line 1400: Wf_local_synch.propagate_role(

1396: AddParameterToList('MAIL',p_email_address,l_list);
1397: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1398: AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
1399:
1400: Wf_local_synch.propagate_role(
1401: p_orig_system => g_grp_orig_system,
1402: p_orig_system_id => p_group_id,
1403: p_attributes => l_list,
1404: p_start_date => l_start_date_active,

Line 1542: Wf_local_synch.propagate_user_role(

1538: X_ORIG_SYSTEM_ID => l_orig_system_id);
1539:
1540:
1541: IF l_user_name is not null THEN
1542: Wf_local_synch.propagate_user_role(
1543: p_user_orig_system => l_orig_system,
1544: p_user_orig_system_id => l_orig_system_id,
1545: p_role_orig_system => g_grp_orig_system,
1546: p_role_orig_system_id => p_group_id,

Line 1623: /* Changed the code to call Wf_local_synch instead of Wf_Directory

1619: X_ORIG_SYSTEM_ID => l_orig_system_id);
1620:
1621: IF l_user_name is not null THEN
1622:
1623: /* Changed the code to call Wf_local_synch instead of Wf_Directory
1624: Fix for bug # 2671368 */
1625:
1626: Wf_local_synch.propagate_user_role(
1627: p_user_orig_system => l_orig_system,

Line 1626: Wf_local_synch.propagate_user_role(

1622:
1623: /* Changed the code to call Wf_local_synch instead of Wf_Directory
1624: Fix for bug # 2671368 */
1625:
1626: Wf_local_synch.propagate_user_role(
1627: p_user_orig_system => l_orig_system,
1628: p_user_orig_system_id => l_orig_system_id,
1629: p_role_orig_system => g_grp_orig_system,
1630: p_role_orig_system_id => p_group_id,

Line 1693: /* Changed the code to call Wf_local_synch instead of Wf_Directory

1689: -- l_end_date_active >= l_sysdate)) THEN
1690: if ( (l_end_date_active >= l_sysdate) OR (l_end_date_active is NULL) ) then
1691: /* Create role only if team is active */
1692:
1693: /* Changed the code to call Wf_local_synch instead of Wf_Directory
1694: Fix for bug # 2671368 */
1695:
1696: AddParameterToList('USER_NAME',l_team_role_name,l_list);
1697: AddParameterToList('DISPLAYNAME',p_team_name,l_list);

Line 1701: Wf_local_synch.propagate_role(

1697: AddParameterToList('DISPLAYNAME',p_team_name,l_list);
1698: AddParameterToList('MAIL',p_email_address,l_list);
1699: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1700:
1701: Wf_local_synch.propagate_role(
1702: p_orig_system => g_team_orig_system,
1703: p_orig_system_id => p_team_id,
1704: p_attributes => l_list,
1705: p_start_date => l_start_date_active,

Line 1710: Wf_local_synch.propagate_user_role(

1706: p_expiration_date => l_end_date_active);
1707:
1708: l_list.DELETE;
1709:
1710: Wf_local_synch.propagate_user_role(
1711: p_user_orig_system => g_team_orig_system,
1712: p_user_orig_system_id => p_team_id,
1713: p_role_orig_system => g_team_orig_system,
1714: p_role_orig_system_id => p_team_id,

Line 1842: Wf_local_synch.propagate_role(

1838: AddParameterToList('MAIL',p_email_address,l_list);
1839: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1840: AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
1841:
1842: Wf_local_synch.propagate_role(
1843: p_orig_system => g_team_orig_system,
1844: p_orig_system_id => p_team_id,
1845: p_attributes => l_list,
1846: p_start_date => l_start_date_active,

Line 1851: Wf_local_synch.propagate_user_role(

1847: p_expiration_date => l_end_date_active);
1848:
1849: l_list.DELETE;
1850:
1851: Wf_local_synch.propagate_user_role(
1852: p_user_orig_system => g_team_orig_system,
1853: p_user_orig_system_id => p_team_id,
1854: p_role_orig_system => g_team_orig_system,
1855: p_role_orig_system_id => p_team_id,

Line 1894: Wf_local_synch.propagate_user_role(

1890: if (l_team_mem_end_date = l_g_miss_date) then
1891: l_team_mem_end_date := NULL;
1892: end if;
1893:
1894: Wf_local_synch.propagate_user_role(
1895: p_user_orig_system => l_team_mem_orig_system,
1896: p_user_orig_system_id => l_team_mem_orig_system_id,
1897: p_role_orig_system => g_team_orig_system,
1898: p_role_orig_system_id => p_team_id,

Line 1908: Wf_local_synch.propagate_user_role(

1904: end if;
1905:
1906: if ((nvl(l_end_date_active,l_sysdate) < l_sysdate)) then
1907:
1908: Wf_local_synch.propagate_user_role(
1909: p_user_orig_system => g_team_orig_system,
1910: p_user_orig_system_id => p_team_id,
1911: p_role_orig_system => g_team_orig_system,
1912: p_role_orig_system_id => p_team_id,

Line 1923: Wf_local_synch.propagate_role(

1919: AddParameterToList('MAIL',p_email_address,l_list);
1920: AddParameterToList('ORCLISENABLED','ACTIVE',l_list);
1921: AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
1922:
1923: Wf_local_synch.propagate_role(
1924: p_orig_system => g_team_orig_system,
1925: p_orig_system_id => p_team_id,
1926: p_attributes => l_list,
1927: p_start_date => l_start_date_active,

Line 2076: Wf_local_synch.propagate_user_role(

2072:
2073:
2074: IF l_user_name is not null THEN
2075:
2076: Wf_local_synch.propagate_user_role(
2077: p_user_orig_system => l_orig_system,
2078: p_user_orig_system_id => l_orig_system_id,
2079: p_role_orig_system => g_team_orig_system,
2080: p_role_orig_system_id => p_team_id,

Line 2121: Wf_local_synch.propagate_user_role(

2117: FETCH c_role_exists into l_role_exists;
2118: IF (c_role_exists%FOUND) THEN
2119:
2120: /* Group - role record exists */
2121: Wf_local_synch.propagate_user_role(
2122: p_user_orig_system => g_grp_orig_system,
2123: p_user_orig_system_id => p_group_id,
2124: p_role_orig_system => g_team_orig_system,
2125: p_role_orig_system_id => p_team_id,

Line 2211: /* Changed the code to call Wf_local_synch instead of Wf_Directory

2207: X_ORIG_SYSTEM_ID => l_orig_system_id);
2208:
2209: IF l_user_name is not null THEN
2210:
2211: /* Changed the code to call Wf_local_synch instead of Wf_Directory
2212: Fix for bug # 2671368 */
2213:
2214: Wf_local_synch.propagate_user_role(
2215: p_user_orig_system => l_orig_system,

Line 2214: Wf_local_synch.propagate_user_role(

2210:
2211: /* Changed the code to call Wf_local_synch instead of Wf_Directory
2212: Fix for bug # 2671368 */
2213:
2214: Wf_local_synch.propagate_user_role(
2215: p_user_orig_system => l_orig_system,
2216: p_user_orig_system_id => l_orig_system_id,
2217: p_role_orig_system => g_team_orig_system,
2218: p_role_orig_system_id => p_team_id,

Line 2225: Wf_local_synch.propagate_user_role(

2221: END IF;
2222: ELSIF (P_GROUP_ID is not null) THEN
2223: l_user_name := g_grp_orig_system||':'||to_char(p_group_id);
2224:
2225: Wf_local_synch.propagate_user_role(
2226: p_user_orig_system => g_grp_orig_system,
2227: p_user_orig_system_id => p_group_id,
2228: p_role_orig_system => g_team_orig_system,
2229: p_role_orig_system_id => p_team_id,