129: WHERE wlr.orig_system_id = team.team_id
130: AND wlr.orig_system = l_team_orig_system
131: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
132:
133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
130: AND wlr.orig_system = l_team_orig_system
131: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
132:
133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
138: log_message37 fnd_new_messages.message_text%type := NULL;
131: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
132:
133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
138: log_message37 fnd_new_messages.message_text%type := NULL;
139:
132:
133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
138: log_message37 fnd_new_messages.message_text%type := NULL;
139:
140: BEGIN
133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
138: log_message37 fnd_new_messages.message_text%type := NULL;
139:
140: BEGIN
141:
134: log_message12 fnd_new_messages.message_text%type := NULL;
135: log_message13 fnd_new_messages.message_text%type := NULL;
136: log_message14 fnd_new_messages.message_text%type := NULL;
137: log_message36 fnd_new_messages.message_text%type := NULL;
138: log_message37 fnd_new_messages.message_text%type := NULL;
139:
140: BEGIN
141:
142: log_msg_hdr4 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR4');
482: WHERE wlr.orig_system = l_grp_orig_system
483: AND wlr.orig_system_id = grp.group_id
484: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
485:
486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
483: AND wlr.orig_system_id = grp.group_id
484: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
485:
486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
491: log_message39 fnd_new_messages.message_text%type := NULL;
484: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
485:
486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
491: log_message39 fnd_new_messages.message_text%type := NULL;
492:
485:
486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
491: log_message39 fnd_new_messages.message_text%type := NULL;
492:
493: BEGIN
486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
491: log_message39 fnd_new_messages.message_text%type := NULL;
492:
493: BEGIN
494:
487: log_message1 fnd_new_messages.message_text%type := NULL;
488: log_message2 fnd_new_messages.message_text%type := NULL;
489: log_message3 fnd_new_messages.message_text%type := NULL;
490: log_message38 fnd_new_messages.message_text%type := NULL;
491: log_message39 fnd_new_messages.message_text%type := NULL;
492:
493: BEGIN
494:
495: log_msg_hdr1 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR1');
780: l_display_name wf_local_roles.display_name%TYPE;
781: l_email_address wf_local_roles.email_address%TYPE;
782: l_expiration_date wf_local_roles.expiration_date%TYPE;
783:
784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
785: log_message40 fnd_new_messages.message_text%type := NULL;
786:
787: BEGIN
788:
781: l_email_address wf_local_roles.email_address%TYPE;
782: l_expiration_date wf_local_roles.expiration_date%TYPE;
783:
784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
785: log_message40 fnd_new_messages.message_text%type := NULL;
786:
787: BEGIN
788:
789: log_msg_hdr2 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR2');
1133: AND wlur.user_orig_system = l_hz_orig_system
1134: AND wlur.role_orig_system = l_grp_orig_system);
1135:
1136:
1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1138: log_message8 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1134: AND wlur.role_orig_system = l_grp_orig_system);
1135:
1136:
1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1138: log_message8 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1135:
1136:
1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1138: log_message8 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1136:
1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1138: log_message8 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1138: log_message8 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1139: log_message9 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1146:
1147: log_message30 fnd_new_messages.message_text%type := NULL;
1140: log_message10 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1146:
1147: log_message30 fnd_new_messages.message_text%type := NULL;
1148: log_message31 fnd_new_messages.message_text%type := NULL;
1141: log_message11 fnd_new_messages.message_text%type := NULL;
1142:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1146:
1147: log_message30 fnd_new_messages.message_text%type := NULL;
1148: log_message31 fnd_new_messages.message_text%type := NULL;
1149:
1143: log_message19 fnd_new_messages.message_text%type := NULL;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1146:
1147: log_message30 fnd_new_messages.message_text%type := NULL;
1148: log_message31 fnd_new_messages.message_text%type := NULL;
1149:
1150: l_end_date_active DATE;
1151: m_end_date_active DATE;
1144: log_message20 fnd_new_messages.message_text%type := NULL;
1145: log_message21 fnd_new_messages.message_text%type := NULL;
1146:
1147: log_message30 fnd_new_messages.message_text%type := NULL;
1148: log_message31 fnd_new_messages.message_text%type := NULL;
1149:
1150: l_end_date_active DATE;
1151: m_end_date_active DATE;
1152: m_start_date_active DATE;
1394: AND wlur.role_orig_system_id = mem.team_id
1395: AND wlur.role_orig_system = l_team_orig_system);
1396:
1397:
1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1399: log_message15 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1395: AND wlur.role_orig_system = l_team_orig_system);
1396:
1397:
1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1399: log_message15 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1396:
1397:
1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1399: log_message15 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1397:
1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1399: log_message15 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1399: log_message15 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1400: log_message16 fnd_new_messages.message_text%type := NULL;
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1401: log_message17 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1402: log_message18 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1403:
1404: log_message22 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1411: log_message34 fnd_new_messages.message_text%type := NULL;
1405: log_message23 fnd_new_messages.message_text%type := NULL;
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1411: log_message34 fnd_new_messages.message_text%type := NULL;
1412: log_message35 fnd_new_messages.message_text%type := NULL;
1413:
1406: log_message24 fnd_new_messages.message_text%type := NULL;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1411: log_message34 fnd_new_messages.message_text%type := NULL;
1412: log_message35 fnd_new_messages.message_text%type := NULL;
1413:
1414: l_end_date_active DATE;
1407: log_message25 fnd_new_messages.message_text%type := NULL;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1411: log_message34 fnd_new_messages.message_text%type := NULL;
1412: log_message35 fnd_new_messages.message_text%type := NULL;
1413:
1414: l_end_date_active DATE;
1415: m_end_date_active DATE;
1408:
1409: log_message32 fnd_new_messages.message_text%type := NULL;
1410: log_message33 fnd_new_messages.message_text%type := NULL;
1411: log_message34 fnd_new_messages.message_text%type := NULL;
1412: log_message35 fnd_new_messages.message_text%type := NULL;
1413:
1414: l_end_date_active DATE;
1415: m_end_date_active DATE;
1416: m_start_date_active DATE;