DBA Data[Home] [Help]

APPS.JTF_RS_CONC_WF_PUB dependencies on FND_NEW_MESSAGES

Line 133: log_msg_hdr4 fnd_new_messages.message_text%type := NULL;

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;

Line 134: log_message12 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;

Line 135: log_message13 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:

Line 136: log_message14 fnd_new_messages.message_text%type := NULL;

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

Line 137: log_message36 fnd_new_messages.message_text%type := NULL;

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:

Line 138: log_message37 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:
142: log_msg_hdr4 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR4');

Line 486: log_msg_hdr1 fnd_new_messages.message_text%type := NULL;

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;

Line 487: log_message1 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;

Line 488: log_message2 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:

Line 489: log_message3 fnd_new_messages.message_text%type := NULL;

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

Line 490: log_message38 fnd_new_messages.message_text%type := NULL;

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:

Line 491: log_message39 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:
495: log_msg_hdr1 := fnd_message.get_string ('JTF','JTF_RS_WF_ROLE_SYNC_LOG_HDR1');

Line 784: log_msg_hdr2 fnd_new_messages.message_text%type := NULL;

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:

Line 785: log_message40 fnd_new_messages.message_text%type := NULL;

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');

Line 1137: log_msg_hdr3 fnd_new_messages.message_text%type := NULL;

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;

Line 1138: log_message8 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:

Line 1139: log_message9 fnd_new_messages.message_text%type := NULL;

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;

Line 1140: log_message10 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;

Line 1141: log_message11 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;

Line 1143: log_message19 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;

Line 1144: log_message20 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;

Line 1145: log_message21 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:

Line 1147: log_message30 fnd_new_messages.message_text%type := NULL;

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;

Line 1148: log_message31 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;
1152: m_start_date_active DATE;

Line 1398: log_msg_hdr5 fnd_new_messages.message_text%type := NULL;

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;

Line 1399: log_message15 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:

Line 1400: log_message16 fnd_new_messages.message_text%type := NULL;

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;

Line 1401: log_message17 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;

Line 1402: log_message18 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;

Line 1404: log_message22 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:

Line 1405: log_message23 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:
1409: log_message32 fnd_new_messages.message_text%type := NULL;

Line 1406: log_message24 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;

Line 1407: log_message25 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;

Line 1409: log_message32 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:

Line 1410: log_message33 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:
1414: l_end_date_active DATE;

Line 1411: log_message34 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;
1415: m_end_date_active DATE;

Line 1412: log_message35 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;
1416: m_start_date_active DATE;