DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on WF_LOCAL_SYNCH

Line 216: Wf_local_synch.propagate_user_role(

212:
213: -- Inactivate Workflow User Roles (Self and Member) for corresponding Inactive Resource Teams
214: FOR i IN c_team_wf_ur_del LOOP
215: BEGIN
216: Wf_local_synch.propagate_user_role(
217: p_user_orig_system => l_team_orig_system,
218: p_user_orig_system_id => i.team_id,
219: p_role_orig_system => l_team_orig_system,
220: p_role_orig_system_id => i.team_id,

Line 252: Wf_local_synch.propagate_role(

248: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
249: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
250: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
251:
252: Wf_local_synch.propagate_role(
253: p_orig_system => l_team_orig_system,
254: p_orig_system_id => i.team_id,
255: p_attributes => l_list,
256: p_start_date => i.start_date_active,

Line 291: Wf_local_synch.propagate_role(

287: -- Passing the parameter for 'Status' as 'ACTIVE' always, for Update.
288: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
289: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
290:
291: Wf_local_synch.propagate_role(
292: p_orig_system => l_team_orig_system,
293: p_orig_system_id => i.team_id,
294: p_attributes => l_list,
295: p_start_date => i.start_date_active,

Line 318: Wf_local_synch.propagate_user_role(

314: (i.end_date_active IS NOT NULL AND i.wlr_exp_date IS NULL) OR
315: i.end_date_active <> i.wlr_exp_date) THEN
316:
317: BEGIN
318: Wf_local_synch.propagate_user_role(
319: p_user_orig_system => l_team_orig_system,
320: p_user_orig_system_id => i.team_id,
321: p_role_orig_system => l_team_orig_system,
322: p_role_orig_system_id => i.team_id,

Line 349: Wf_local_synch.propagate_user_role(

345:
346: -- Update Workflow User Roles (Self and Member Records) for corresponding Updated/Active Resource Teams
347: FOR i IN c_team_wf_ur_upd LOOP
348: BEGIN
349: Wf_local_synch.propagate_user_role(
350: p_user_orig_system => l_team_orig_system,
351: p_user_orig_system_id => i.team_id,
352: p_role_orig_system => l_team_orig_system,
353: p_role_orig_system_id => i.team_id,

Line 384: Wf_local_synch.propagate_role(

380: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.email_address,l_list);
381: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
382: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
383:
384: Wf_local_synch.propagate_role(
385: p_orig_system => l_team_orig_system,
386: p_orig_system_id => i.team_id,
387: p_attributes => l_list,
388: p_start_date => i.start_date_active,

Line 406: Wf_local_synch.propagate_user_role(

402: END;
403:
404: -- Create Self-Record in wf_local_user_roles for the above record
405: BEGIN
406: Wf_local_synch.propagate_user_role(
407: p_user_orig_system => l_team_orig_system,
408: p_user_orig_system_id => i.team_id,
409: p_role_orig_system => l_team_orig_system,
410: p_role_orig_system_id => i.team_id,

Line 569: Wf_local_synch.propagate_user_role(

565:
566: -- Inactivate Workflow User Roles (Self-Records) for corresponding Inactive Resource Groups
567: FOR i IN c_grp_wf_ur_del LOOP
568: BEGIN
569: Wf_local_synch.propagate_user_role(
570: p_user_orig_system => l_grp_orig_system,
571: p_user_orig_system_id => i.group_id,
572: p_role_orig_system => l_grp_orig_system,
573: p_role_orig_system_id => i.group_id,

Line 605: Wf_local_synch.propagate_role(

601: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
602: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
603: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
604:
605: Wf_local_synch.propagate_role(
606: p_orig_system => l_grp_orig_system,
607: p_orig_system_id => i.group_id,
608: p_attributes => l_list,
609: p_start_date => i.start_date_active,

Line 644: Wf_local_synch.propagate_role(

640: -- Passing the parameter for 'Status' as 'ACITVE' always, for Update.
641: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
642: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
643:
644: Wf_local_synch.propagate_role(
645: p_orig_system => l_grp_orig_system,
646: p_orig_system_id => i.group_id,
647: p_attributes => l_list,
648: p_start_date => i.start_date_active,

Line 671: Wf_local_synch.propagate_user_role(

667: (i.end_date_active IS NOT NULL AND i.wlr_exp_date IS NULL) OR
668: i.end_date_active <> i.wlr_exp_date) THEN
669:
670: BEGIN
671: Wf_local_synch.propagate_user_role(
672: p_user_orig_system => l_grp_orig_system,
673: p_user_orig_system_id => i.group_id,
674: p_role_orig_system => l_grp_orig_system,
675: p_role_orig_system_id => i.group_id,

Line 702: Wf_local_synch.propagate_user_role(

698:
699: -- Update Workflow User Roles (Self and Member Records) for correspoding Updated/Active Resource Groups
700: FOR i IN c_grp_wf_ur_upd LOOP
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 736: Wf_local_synch.propagate_role(

732: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('DISPLAYNAME',i.group_name,l_list);
733: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.email_address,l_list);
734: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
735:
736: Wf_local_synch.propagate_role(
737: p_orig_system => l_grp_orig_system,
738: p_orig_system_id => i.group_id,
739: p_attributes => l_list,
740: p_start_date => i.start_date_active,

Line 758: Wf_local_synch.propagate_user_role(

754: END;
755:
756: -- Create Self-Record in wf_local_user_roles for the above record
757: BEGIN
758: Wf_local_synch.propagate_user_role(
759: p_user_orig_system => l_grp_orig_system,
760: p_user_orig_system_id => i.group_id,
761: p_role_orig_system => l_grp_orig_system,
762: p_role_orig_system_id => i.group_id,

Line 859: Wf_local_synch.propagate_user_role(

855: IF (i.category IN ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')) THEN
856: FOR j IN c_wf_ur_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP
857: -- Inactivate the wf user roles
858: BEGIN
859: Wf_local_synch.propagate_user_role(
860: p_user_orig_system => l_ind_orig_system,
861: p_user_orig_system_id => i.resource_id,
862: p_role_orig_system => l_ind_orig_system,
863: p_role_orig_system_id => i.resource_id,

Line 890: Wf_local_synch.propagate_role(

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

Line 914: Wf_local_synch.propagate_user_role(

910: ELSIF (i.category IN ('OTHER','TBH') AND NVL (i.end_date_active, l_sysdate) < l_sysdate) THEN
911: -- Inactivate corresponding wf user roles with resource dates
912: FOR k IN c_wf_ur_details (i.resource_id, l_ind_orig_system, l_ind_user_name) LOOP
913: BEGIN
914: Wf_local_synch.propagate_user_role(
915: p_user_orig_system => l_ind_orig_system,
916: p_user_orig_system_id => i.resource_id,
917: p_role_orig_system => l_ind_orig_system,
918: p_role_orig_system_id => i.resource_id,

Line 945: Wf_local_synch.propagate_role(

941: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_inactive,l_list);
942: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('WFSYNCH_OVERWRITE','TRUE',l_list);
943: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
944:
945: Wf_local_synch.propagate_role(
946: p_orig_system => l_ind_orig_system,
947: p_orig_system_id => i.resource_id,
948: p_attributes => l_list,
949: p_start_date => i.start_date_active,

Line 995: Wf_local_synch.propagate_user_role(

991: IF l_end_date = l_fnd_date THEN
992: l_end_date := NULL;
993: END IF;
994: BEGIN
995: Wf_local_synch.propagate_user_role(
996: p_user_orig_system => l_user_orig_system,
997: p_user_orig_system_id => l_user_orig_system_id,
998: p_role_orig_system => c.role_orig_system,
999: p_role_orig_system_id => c.role_orig_system_id,

Line 1042: Wf_local_synch.propagate_role(

1038: -- Passing the parameter for 'Status' as 'ACTIVE' always, for Update.
1039: -- The status will be set to 'INACTIVE' if dates are inactive by WF APIs.
1040: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('ORCLISENABLED',l_active,l_list);
1041:
1042: Wf_local_synch.propagate_role(
1043: p_orig_system => l_ind_orig_system,
1044: p_orig_system_id => i.resource_id,
1045: p_attributes => l_list,
1046: p_start_date => i.start_date_active,

Line 1073: Wf_local_synch.propagate_role(

1069: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('DISPLAYNAME',i.resource_name,l_list);
1070: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('MAIL',i.source_email,l_list);
1071: JTF_RS_WF_INTEGRATION_PUB.AddParameterToList('RAISEERRORS','TRUE',l_list);
1072:
1073: Wf_local_synch.propagate_role(
1074: p_orig_system => l_ind_orig_system,
1075: p_orig_system_id => i.resource_id,
1076: p_attributes => l_list,
1077: p_start_date => i.start_date_active,

Line 1092: Wf_local_synch.propagate_user_role(

1088: wf_core.clear;
1089: END;
1090: -- Create Self-Record in wf_local_user_roles for the above record
1091: BEGIN
1092: Wf_local_synch.propagate_user_role(
1093: p_user_orig_system => l_ind_orig_system,
1094: p_user_orig_system_id => i.resource_id,
1095: p_role_orig_system => l_ind_orig_system,
1096: p_role_orig_system_id => i.resource_id,

Line 1275: Wf_local_synch.propagate_user_role (

1271: p_msg_level=>fnd_log.level_statement);
1272: END IF;
1273:
1274: BEGIN
1275: Wf_local_synch.propagate_user_role (
1276: p_user_orig_system => l_user_orig_system,
1277: p_user_orig_system_id => l_user_orig_system_id,
1278: p_role_orig_system => l_grp_orig_system,
1279: p_role_orig_system_id => i.group_id,

Line 1312: Wf_local_synch.propagate_user_role (

1308: l_end_date_active := NULL;
1309: ELSE
1310: l_end_date_active := i.m_end_date_active;
1311: END IF;
1312: Wf_local_synch.propagate_user_role (
1313: p_user_orig_system => l_ind_orig_system,
1314: p_user_orig_system_id => i.resource_id,
1315: p_role_orig_system => l_grp_orig_system,
1316: p_role_orig_system_id => i.group_id,

Line 1357: Wf_local_synch.propagate_user_role (

1353: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1354: Category - '||i.category||', because there was no corresponding User defined in wf_local_roles table');
1355: ELSE
1356: BEGIN
1357: Wf_local_synch.propagate_user_role (
1358: p_user_orig_system => l_user_orig_system,
1359: p_user_orig_system_id => l_user_orig_system_id,
1360: p_role_orig_system => l_grp_orig_system,
1361: p_role_orig_system_id => i.group_id,

Line 1546: Wf_local_synch.propagate_user_role (

1542: --Inactivate all wf user roles which are still active and whose corresponding records
1543: -- in resource team members table have been deleted (delete_flag Y).
1544: FOR i IN c_wlur_team_mem_del LOOP
1545: BEGIN
1546: Wf_local_synch.propagate_user_role (
1547: p_user_orig_system => i.user_orig_system,
1548: p_user_orig_system_id => i.user_orig_system_id,
1549: p_role_orig_system => l_team_orig_system,
1550: p_role_orig_system_id => i.team_id,

Line 1581: Wf_local_synch.propagate_user_role(

1577: ELSE
1578: l_end_date_active := i.m_end_date_active;
1579: END IF;
1580: BEGIN
1581: Wf_local_synch.propagate_user_role(
1582: p_user_orig_system => l_ind_orig_system,
1583: p_user_orig_system_id => i.resource_id,
1584: p_role_orig_system => l_team_orig_system,
1585: p_role_orig_system_id => i.team_id,

Line 1626: Wf_local_synch.propagate_user_role(

1622: Resource is Resource ID - '||i.resource_id||', Resource Name - '||i.resource_name||' and Resource
1623: Category - '||i.category||', because there was no corresponding User defined wf_local_roles table');
1624: ELSE
1625: BEGIN
1626: Wf_local_synch.propagate_user_role(
1627: p_user_orig_system => l_user_orig_system,
1628: p_user_orig_system_id => l_user_orig_system_id,
1629: p_role_orig_system => l_team_orig_system,
1630: p_role_orig_system_id => i.team_id,

Line 1660: Wf_local_synch.propagate_user_role(

1656: ELSE
1657: l_end_date_active := i.m_end_date_active;
1658: END IF;
1659: BEGIN
1660: Wf_local_synch.propagate_user_role(
1661: p_user_orig_system => l_grp_orig_system,
1662: p_user_orig_system_id => i.group_id,
1663: p_role_orig_system => l_team_orig_system,
1664: p_role_orig_system_id => i.team_id,