320: l_service_request_rec.external_reference := l_ump_rec.external_reference;
321: l_service_request_rec.system_id := l_ump_rec.system_id;
322: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
323: l_service_request_rec.last_update_program_code := 'PMCON';
324: l_service_request_rec.program_id := fnd_global.conc_program_id;
325: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
326: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
327: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
328:
321: l_service_request_rec.system_id := l_ump_rec.system_id;
322: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
323: l_service_request_rec.last_update_program_code := 'PMCON';
324: l_service_request_rec.program_id := fnd_global.conc_program_id;
325: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
326: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
327: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
328:
329: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
322: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
323: l_service_request_rec.last_update_program_code := 'PMCON';
324: l_service_request_rec.program_id := fnd_global.conc_program_id;
325: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
326: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
327: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
328:
329: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
330: l_service_request_rec.ship_to_party_id := l_ump_rec.shipto_party_id;
323: l_service_request_rec.last_update_program_code := 'PMCON';
324: l_service_request_rec.program_id := fnd_global.conc_program_id;
325: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
326: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
327: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
328:
329: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
330: l_service_request_rec.ship_to_party_id := l_ump_rec.shipto_party_id;
331:
439: p_commit => FND_API.G_FALSE,
440: x_return_status => x_return_status,
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,
443: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
444: p_resp_id => FND_GLOBAL.RESP_ID,
445: p_user_id => fnd_global.user_id,
446: p_login_id => fnd_global.conc_login_id,
447: p_org_id => fnd_profile.value('ORG_ID'),
440: x_return_status => x_return_status,
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,
443: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
444: p_resp_id => FND_GLOBAL.RESP_ID,
445: p_user_id => fnd_global.user_id,
446: p_login_id => fnd_global.conc_login_id,
447: p_org_id => fnd_profile.value('ORG_ID'),
448: p_request_id => null,
441: x_msg_count => x_msg_count,
442: x_msg_data => x_msg_data,
443: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
444: p_resp_id => FND_GLOBAL.RESP_ID,
445: p_user_id => fnd_global.user_id,
446: p_login_id => fnd_global.conc_login_id,
447: p_org_id => fnd_profile.value('ORG_ID'),
448: p_request_id => null,
449: p_request_number => null,
442: x_msg_data => x_msg_data,
443: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
444: p_resp_id => FND_GLOBAL.RESP_ID,
445: p_user_id => fnd_global.user_id,
446: p_login_id => fnd_global.conc_login_id,
447: p_org_id => fnd_profile.value('ORG_ID'),
448: p_request_id => null,
449: p_request_number => null,
450: p_service_request_rec => l_service_request_rec,
468: p_commit => FND_API.G_FALSE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
473: p_resp_id => FND_GLOBAL.RESP_ID,
474: p_user_id => fnd_global.user_id,
475: p_login_id => fnd_global.conc_login_id,
476: p_org_id => fnd_profile.value('ORG_ID'),
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
473: p_resp_id => FND_GLOBAL.RESP_ID,
474: p_user_id => fnd_global.user_id,
475: p_login_id => fnd_global.conc_login_id,
476: p_org_id => fnd_profile.value('ORG_ID'),
477: p_request_id => null,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
473: p_resp_id => FND_GLOBAL.RESP_ID,
474: p_user_id => fnd_global.user_id,
475: p_login_id => fnd_global.conc_login_id,
476: p_org_id => fnd_profile.value('ORG_ID'),
477: p_request_id => null,
478: p_request_number => null,
471: x_msg_data => x_msg_data,
472: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
473: p_resp_id => FND_GLOBAL.RESP_ID,
474: p_user_id => fnd_global.user_id,
475: p_login_id => fnd_global.conc_login_id,
476: p_org_id => fnd_profile.value('ORG_ID'),
477: p_request_id => null,
478: p_request_number => null,
479: p_service_request_rec => l_service_request_rec,
524: x_return_status => x_return_status,
525: x_msg_count => x_msg_count,
526: x_msg_data => x_msg_data,
527: p_request_id => x_request_id,
528: p_last_updated_by => fnd_global.user_id,
529: p_last_update_date => sysdate,
530: p_object_version_number=> x_object_version_number,
531: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
532: p_resp_id => FND_GLOBAL.RESP_ID,
527: p_request_id => x_request_id,
528: p_last_updated_by => fnd_global.user_id,
529: p_last_update_date => sysdate,
530: p_object_version_number=> x_object_version_number,
531: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
532: p_resp_id => FND_GLOBAL.RESP_ID,
533: p_service_request_rec => l_service_request_rec,
534: p_notes => l_no_notes_table,
535: p_contacts => l_contacts_table,
528: p_last_updated_by => fnd_global.user_id,
529: p_last_update_date => sysdate,
530: p_object_version_number=> x_object_version_number,
531: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
532: p_resp_id => FND_GLOBAL.RESP_ID,
533: p_service_request_rec => l_service_request_rec,
534: p_notes => l_no_notes_table,
535: p_contacts => l_contacts_table,
536: x_interaction_id => x_interaction_id,
557: l_link_rec.object_id := l_ump_rec.unit_effectivity_id;
558: l_link_rec.object_number := l_ump_rec.title;
559: l_link_rec.object_type := 'AHL_UMP_EFF';
560: l_link_rec.link_type_id := 6;
561: l_link_rec.request_id := fnd_global.conc_request_id;
562: l_link_rec.program_application_id := fnd_global.prog_appl_id;
563: l_link_rec.program_id := fnd_global.conc_program_id;
564: l_link_rec.program_update_date := sysdate;
565: cs_incidentlinks_pub.create_incidentlink(
558: l_link_rec.object_number := l_ump_rec.title;
559: l_link_rec.object_type := 'AHL_UMP_EFF';
560: l_link_rec.link_type_id := 6;
561: l_link_rec.request_id := fnd_global.conc_request_id;
562: l_link_rec.program_application_id := fnd_global.prog_appl_id;
563: l_link_rec.program_id := fnd_global.conc_program_id;
564: l_link_rec.program_update_date := sysdate;
565: cs_incidentlinks_pub.create_incidentlink(
566: p_api_version => 2.0,
559: l_link_rec.object_type := 'AHL_UMP_EFF';
560: l_link_rec.link_type_id := 6;
561: l_link_rec.request_id := fnd_global.conc_request_id;
562: l_link_rec.program_application_id := fnd_global.prog_appl_id;
563: l_link_rec.program_id := fnd_global.conc_program_id;
564: l_link_rec.program_update_date := sysdate;
565: cs_incidentlinks_pub.create_incidentlink(
566: p_api_version => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
565: cs_incidentlinks_pub.create_incidentlink(
566: p_api_version => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_commit => FND_API.G_FALSE,
569: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
570: p_resp_id => FND_GLOBAL.RESP_ID,
571: p_user_id => FND_GLOBAL.USER_ID,
572: p_login_id => NULL,
573: p_org_id => fnd_profile.value('ORG_ID'),
566: p_api_version => 2.0,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_commit => FND_API.G_FALSE,
569: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
570: p_resp_id => FND_GLOBAL.RESP_ID,
571: p_user_id => FND_GLOBAL.USER_ID,
572: p_login_id => NULL,
573: p_org_id => fnd_profile.value('ORG_ID'),
574: p_link_rec => l_link_rec,
567: p_init_msg_list => FND_API.G_FALSE,
568: p_commit => FND_API.G_FALSE,
569: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
570: p_resp_id => FND_GLOBAL.RESP_ID,
571: p_user_id => FND_GLOBAL.USER_ID,
572: p_login_id => NULL,
573: p_org_id => fnd_profile.value('ORG_ID'),
574: p_link_rec => l_link_rec,
575: x_return_status => x_return_status,
1189: p_commit => FND_API.G_FALSE,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,
1193: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1194: p_resp_id => FND_GLOBAL.RESP_ID,
1195: p_user_id => FND_GLOBAL.USER_ID,
1196: p_login_id => fnd_global.conc_login_id,
1197: p_request_id => incident_rec.subject_id,
1190: x_return_status => x_return_status,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,
1193: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1194: p_resp_id => FND_GLOBAL.RESP_ID,
1195: p_user_id => FND_GLOBAL.USER_ID,
1196: p_login_id => fnd_global.conc_login_id,
1197: p_request_id => incident_rec.subject_id,
1198: p_request_number => NULL,
1191: x_msg_count => x_msg_count,
1192: x_msg_data => x_msg_data,
1193: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1194: p_resp_id => FND_GLOBAL.RESP_ID,
1195: p_user_id => FND_GLOBAL.USER_ID,
1196: p_login_id => fnd_global.conc_login_id,
1197: p_request_id => incident_rec.subject_id,
1198: p_request_number => NULL,
1199: p_object_version_number => incident_rec.object_version_number,
1192: x_msg_data => x_msg_data,
1193: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1194: p_resp_id => FND_GLOBAL.RESP_ID,
1195: p_user_id => FND_GLOBAL.USER_ID,
1196: p_login_id => fnd_global.conc_login_id,
1197: p_request_id => incident_rec.subject_id,
1198: p_request_number => NULL,
1199: p_object_version_number => incident_rec.object_version_number,
1200: -- status code CLOSED seeded in cs_incident_statuses
1214: P_COMMIT => FND_API.G_FALSE,
1215: P_RESP_APPL_ID => NULL,
1216: P_RESP_ID => NULL,
1217: P_USER_ID => NULL,
1218: P_LOGIN_ID => FND_GLOBAL.CONC_LOGIN_ID,
1219: P_ORG_ID => NULL,
1220: P_LINK_ID => incident_rec.link_id,
1221: X_RETURN_STATUS => x_return_status,
1222: X_MSG_COUNT => x_msg_count,