185: WHERE wlr.orig_system_id = team.team_id
186: AND wlr.orig_system = l_team_orig_system
187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
186: AND wlr.orig_system = l_team_orig_system
187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
187: AND wlr.name = l_team_orig_system||':'||to_char(team.team_id));
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
188:
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN
189: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN
197:
190: log_message12 fnd_new_messages.message_text%type := NULL;
191: log_message13 fnd_new_messages.message_text%type := NULL;
192: log_message14 fnd_new_messages.message_text%type := NULL;
193: log_message36 fnd_new_messages.message_text%type := NULL;
194: log_message37 fnd_new_messages.message_text%type := NULL;
195:
196: BEGIN
197:
198: log_msg_hdr4 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR4');
538: WHERE wlr.orig_system = l_grp_orig_system
539: AND wlr.orig_system_id = grp.group_id
540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
539: AND wlr.orig_system_id = grp.group_id
540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
540: AND wlr.name = l_grp_orig_system||':'||to_char(group_id));
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
541:
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN
542: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN
550:
543: log_message1 fnd_new_messages.message_text%type := NULL;
544: log_message2 fnd_new_messages.message_text%type := NULL;
545: log_message3 fnd_new_messages.message_text%type := NULL;
546: log_message38 fnd_new_messages.message_text%type := NULL;
547: log_message39 fnd_new_messages.message_text%type := NULL;
548:
549: BEGIN
550:
551: log_msg_hdr1 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR1');
836: l_display_name wf_local_roles.display_name%TYPE;
837: l_email_address wf_local_roles.email_address%TYPE;
838: l_expiration_date wf_local_roles.expiration_date%TYPE;
839:
840: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
841: log_message40 fnd_new_messages.message_text%type := NULL;
842:
843: BEGIN
844:
837: l_email_address wf_local_roles.email_address%TYPE;
838: l_expiration_date wf_local_roles.expiration_date%TYPE;
839:
840: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;
841: log_message40 fnd_new_messages.message_text%type := NULL;
842:
843: BEGIN
844:
845: log_msg_hdr2 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR2');
1190: AND wlur.user_orig_system = l_hz_orig_system
1191: AND wlur.role_orig_system = l_grp_orig_system);
1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1191: AND wlur.role_orig_system = l_grp_orig_system);
1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1192:
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1193:
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1194: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;
1195: log_message8 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1196: log_message9 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1197: log_message10 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1198: log_message11 fnd_new_messages.message_text%type := NULL;
1199:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:
1200: log_message19 fnd_new_messages.message_text%type := NULL;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:
1207: l_end_date_active DATE;
1208: m_end_date_active DATE;
1201: log_message20 fnd_new_messages.message_text%type := NULL;
1202: log_message21 fnd_new_messages.message_text%type := NULL;
1203:
1204: log_message30 fnd_new_messages.message_text%type := NULL;
1205: log_message31 fnd_new_messages.message_text%type := NULL;
1206:
1207: l_end_date_active DATE;
1208: m_end_date_active DATE;
1209: m_start_date_active DATE;
1492: AND wlur.role_orig_system_id = mem.team_id
1493: AND wlur.role_orig_system = l_team_orig_system);
1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1493: AND wlur.role_orig_system = l_team_orig_system);
1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1494:
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1495:
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1496: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;
1497: log_message15 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1498: log_message16 fnd_new_messages.message_text%type := NULL;
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1499: log_message17 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1500: log_message18 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1501:
1502: log_message22 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1503: log_message23 fnd_new_messages.message_text%type := NULL;
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1504: log_message24 fnd_new_messages.message_text%type := NULL;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;
1505: log_message25 fnd_new_messages.message_text%type := NULL;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;
1513: m_end_date_active DATE;
1506:
1507: log_message32 fnd_new_messages.message_text%type := NULL;
1508: log_message33 fnd_new_messages.message_text%type := NULL;
1509: log_message34 fnd_new_messages.message_text%type := NULL;
1510: log_message35 fnd_new_messages.message_text%type := NULL;
1511:
1512: l_end_date_active DATE;
1513: m_end_date_active DATE;
1514: m_start_date_active DATE;