DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on WF_LOCAL_SYNCH

Line 160: Wf_local_synch.propagate_user_role(

156:
157: -- Inactivate Workflow User Roles (Self and Member) for corresponding Inactive Resource Teams
158: FOR i IN c_team_wf_ur_del LOOP
159: BEGIN
160: Wf_local_synch.propagate_user_role(
161: p_user_orig_system => l_team_orig_system,
162: p_user_orig_system_id => i.team_id,
163: p_role_orig_system => l_team_orig_system,
164: p_role_orig_system_id => i.team_id,

Line 196: Wf_local_synch.propagate_role(

192: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
193: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
194: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
195:
196: Wf_local_synch.propagate_role(
197: p_orig_system => l_team_orig_system,
198: p_orig_system_id => i.team_id,
199: p_attributes => l_list,
200: p_start_date => i.start_date_active,

Line 235: Wf_local_synch.propagate_role(

231: -- Passing the parameter for 'Status' as 'ACTIVE' always, for Update.
232: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
233: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
234:
235: Wf_local_synch.propagate_role(
236: p_orig_system => l_team_orig_system,
237: p_orig_system_id => i.team_id,
238: p_attributes => l_list,
239: p_start_date => i.start_date_active,

Line 262: Wf_local_synch.propagate_user_role(

258: (i.end_date_active IS NOT NULL AND i.wlr_exp_date IS NULL) OR
259: i.end_date_active <> i.wlr_exp_date) THEN
260:
261: BEGIN
262: Wf_local_synch.propagate_user_role(
263: p_user_orig_system => l_team_orig_system,
264: p_user_orig_system_id => i.team_id,
265: p_role_orig_system => l_team_orig_system,
266: p_role_orig_system_id => i.team_id,

Line 293: Wf_local_synch.propagate_user_role(

289:
290: -- Update Workflow User Roles (Self and Member Records) for corresponding Updated/Active Resource Teams
291: FOR i IN c_team_wf_ur_upd LOOP
292: BEGIN
293: Wf_local_synch.propagate_user_role(
294: p_user_orig_system => l_team_orig_system,
295: p_user_orig_system_id => i.team_id,
296: p_role_orig_system => l_team_orig_system,
297: p_role_orig_system_id => i.team_id,

Line 328: Wf_local_synch.propagate_role(

324: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.email_address,l_list);
325: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
326: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
327:
328: Wf_local_synch.propagate_role(
329: p_orig_system => l_team_orig_system,
330: p_orig_system_id => i.team_id,
331: p_attributes => l_list,
332: p_start_date => i.start_date_active,

Line 350: Wf_local_synch.propagate_user_role(

346: END;
347:
348: -- Create Self-Record in wf_local_user_roles for the above record
349: BEGIN
350: Wf_local_synch.propagate_user_role(
351: p_user_orig_system => l_team_orig_system,
352: p_user_orig_system_id => i.team_id,
353: p_role_orig_system => l_team_orig_system,
354: p_role_orig_system_id => i.team_id,

Line 513: Wf_local_synch.propagate_user_role(

509:
510: -- Inactivate Workflow User Roles (Self-Records) for corresponding Inactive Resource Groups
511: FOR i IN c_grp_wf_ur_del LOOP
512: BEGIN
513: Wf_local_synch.propagate_user_role(
514: p_user_orig_system => l_grp_orig_system,
515: p_user_orig_system_id => i.group_id,
516: p_role_orig_system => l_grp_orig_system,
517: p_role_orig_system_id => i.group_id,

Line 549: Wf_local_synch.propagate_role(

545: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
546: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
547: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
548:
549: Wf_local_synch.propagate_role(
550: p_orig_system => l_grp_orig_system,
551: p_orig_system_id => i.group_id,
552: p_attributes => l_list,
553: p_start_date => i.start_date_active,

Line 588: Wf_local_synch.propagate_role(

584: -- Passing the parameter for 'Status' as 'ACITVE' always, for Update.
585: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
586: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
587:
588: Wf_local_synch.propagate_role(
589: p_orig_system => l_grp_orig_system,
590: p_orig_system_id => i.group_id,
591: p_attributes => l_list,
592: p_start_date => i.start_date_active,

Line 615: Wf_local_synch.propagate_user_role(

611: (i.end_date_active IS NOT NULL AND i.wlr_exp_date IS NULL) OR
612: i.end_date_active <> i.wlr_exp_date) THEN
613:
614: BEGIN
615: Wf_local_synch.propagate_user_role(
616: p_user_orig_system => l_grp_orig_system,
617: p_user_orig_system_id => i.group_id,
618: p_role_orig_system => l_grp_orig_system,
619: p_role_orig_system_id => i.group_id,

Line 646: Wf_local_synch.propagate_user_role(

642:
643: -- Update Workflow User Roles (Self and Member Records) for correspoding Updated/Active Resource Groups
644: FOR i IN c_grp_wf_ur_upd LOOP
645: BEGIN
646: Wf_local_synch.propagate_user_role(
647: p_user_orig_system => l_grp_orig_system,
648: p_user_orig_system_id => i.group_id,
649: p_role_orig_system => l_grp_orig_system,
650: p_role_orig_system_id => i.group_id,

Line 680: Wf_local_synch.propagate_role(

676: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('DISPLAYNAME',i.group_name,l_list);
677: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.email_address,l_list);
678: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
679:
680: Wf_local_synch.propagate_role(
681: p_orig_system => l_grp_orig_system,
682: p_orig_system_id => i.group_id,
683: p_attributes => l_list,
684: p_start_date => i.start_date_active,

Line 702: Wf_local_synch.propagate_user_role(

698: END;
699:
700: -- Create Self-Record in wf_local_user_roles for the above record
701: BEGIN
702: Wf_local_synch.propagate_user_role(
703: p_user_orig_system => l_grp_orig_system,
704: p_user_orig_system_id => i.group_id,
705: p_role_orig_system => l_grp_orig_system,
706: p_role_orig_system_id => i.group_id,

Line 803: Wf_local_synch.propagate_user_role(

799: IF (i.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')) THEN
800: FOR j IN c_wf_ur_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP
801: -- Inactivate the wf user roles
802: BEGIN
803: Wf_local_synch.propagate_user_role(
804: p_user_orig_system => l_ind_orig_system,
805: p_user_orig_system_id => i.resource_id,
806: p_role_orig_system => l_ind_orig_system,
807: p_role_orig_system_id => i.resource_id,

Line 834: Wf_local_synch.propagate_role(

830: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
831: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
832: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
833:
834: Wf_local_synch.propagate_role(
835: p_orig_system => l_ind_orig_system,
836: p_orig_system_id => i.resource_id,
837: p_attributes => l_list,
838: p_start_date => l_sysdate-2,

Line 858: Wf_local_synch.propagate_user_role(

854: ELSIF (i.category IN ('OTHER','TBH') AND NVL (i.end_date_active, l_sysdate) < l_sysdate) THEN
855: -- Inactivate corresponding wf user roles with resource dates
856: FOR k IN c_wf_ur_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP
857: BEGIN
858: Wf_local_synch.propagate_user_role(
859: p_user_orig_system => l_ind_orig_system,
860: p_user_orig_system_id => i.resource_id,
861: p_role_orig_system => l_ind_orig_system,
862: p_role_orig_system_id => i.resource_id,

Line 889: Wf_local_synch.propagate_role(

885: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
886: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
887: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
888:
889: Wf_local_synch.propagate_role(
890: p_orig_system => l_ind_orig_system,
891: p_orig_system_id => i.resource_id,
892: p_attributes => l_list,
893: p_start_date => i.start_date_active,

Line 939: Wf_local_synch.propagate_user_role(

935: IF l_end_date = l_fnd_date THEN
936: l_end_date := NULL;
937: END IF;
938: BEGIN
939: Wf_local_synch.propagate_user_role(
940: p_user_orig_system => l_user_orig_system,
941: p_user_orig_system_id => l_user_orig_system_id,
942: p_role_orig_system => c.role_orig_system,
943: p_role_orig_system_id => c.role_orig_system_id,

Line 986: Wf_local_synch.propagate_role(

982: -- Passing the parameter for 'Status' as 'ACTIVE' always, for Update.
983: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
984: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
985:
986: Wf_local_synch.propagate_role(
987: p_orig_system => l_ind_orig_system,
988: p_orig_system_id => i.resource_id,
989: p_attributes => l_list,
990: p_start_date => i.start_date_active,

Line 1017: Wf_local_synch.propagate_role(

1013: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('DISPLAYNAME',i.resource_name,l_list);
1014: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.source_email,l_list);
1015: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
1016:
1017: Wf_local_synch.propagate_role(
1018: p_orig_system => l_ind_orig_system,
1019: p_orig_system_id => i.resource_id,
1020: p_attributes => l_list,
1021: p_start_date => i.start_date_active,

Line 1036: Wf_local_synch.propagate_user_role(

1032: wf_core.clear;
1033: END;
1034: -- Create Self-Record in wf_local_user_roles for the above record
1035: BEGIN
1036: Wf_local_synch.propagate_user_role(
1037: p_user_orig_system => l_ind_orig_system,
1038: p_user_orig_system_id => i.resource_id,
1039: p_role_orig_system => l_ind_orig_system,
1040: p_role_orig_system_id => i.resource_id,

Line 1184: Wf_local_synch.propagate_user_role (

1180: --Inactivate all wf user roles which are still active and whose corresponding records
1181: -- in resource group members table have been deleted (delete_flag Y).
1182: FOR i IN c_wlur_grp_mem_del LOOP
1183: BEGIN
1184: Wf_local_synch.propagate_user_role (
1185: p_user_orig_system => i.user_orig_system,
1186: p_user_orig_system_id => i.user_orig_system_id,
1187: p_role_orig_system => l_grp_orig_system,
1188: p_role_orig_system_id => i.group_id,

Line 1219: Wf_local_synch.propagate_user_role (

1215: l_end_date_active := NULL;
1216: ELSE
1217: l_end_date_active := i.m_end_date_active;
1218: END IF;
1219: Wf_local_synch.propagate_user_role (
1220: p_user_orig_system => l_ind_orig_system,
1221: p_user_orig_system_id => i.resource_id,
1222: p_role_orig_system => l_grp_orig_system,
1223: p_role_orig_system_id => i.group_id,

Line 1264: Wf_local_synch.propagate_user_role (

1260: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1261: Category - '||i.category||', because there was no corresponding User defined in wf_local_roles table');
1262: ELSE
1263: BEGIN
1264: Wf_local_synch.propagate_user_role (
1265: p_user_orig_system => l_user_orig_system,
1266: p_user_orig_system_id => l_user_orig_system_id,
1267: p_role_orig_system => l_grp_orig_system,
1268: p_role_orig_system_id => i.group_id,

Line 1448: Wf_local_synch.propagate_user_role (

1444: --Inactivate all wf user roles which are still active and whose corresponding records
1445: -- in resource team members table have been deleted (delete_flag Y).
1446: FOR i IN c_wlur_team_mem_del LOOP
1447: BEGIN
1448: Wf_local_synch.propagate_user_role (
1449: p_user_orig_system => i.user_orig_system,
1450: p_user_orig_system_id => i.user_orig_system_id,
1451: p_role_orig_system => l_team_orig_system,
1452: p_role_orig_system_id => i.team_id,

Line 1483: Wf_local_synch.propagate_user_role(

1479: ELSE
1480: l_end_date_active := i.m_end_date_active;
1481: END IF;
1482: BEGIN
1483: Wf_local_synch.propagate_user_role(
1484: p_user_orig_system => l_ind_orig_system,
1485: p_user_orig_system_id => i.resource_id,
1486: p_role_orig_system => l_team_orig_system,
1487: p_role_orig_system_id => i.team_id,

Line 1528: Wf_local_synch.propagate_user_role(

1524: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1525: Category - '||i.category||', because there was no corresponding User defined wf_local_roles table');
1526: ELSE
1527: BEGIN
1528: Wf_local_synch.propagate_user_role(
1529: p_user_orig_system => l_user_orig_system,
1530: p_user_orig_system_id => l_user_orig_system_id,
1531: p_role_orig_system => l_team_orig_system,
1532: p_role_orig_system_id => i.team_id,

Line 1562: Wf_local_synch.propagate_user_role(

1558: ELSE
1559: l_end_date_active := i.m_end_date_active;
1560: END IF;
1561: BEGIN
1562: Wf_local_synch.propagate_user_role(
1563: p_user_orig_system => l_grp_orig_system,
1564: p_user_orig_system_id => i.group_id,
1565: p_role_orig_system => l_team_orig_system,
1566: p_role_orig_system_id => i.team_id,