350: l_service_request_rec.external_reference := l_ump_rec.external_reference;
351: l_service_request_rec.system_id := l_ump_rec.system_id;
352: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
353: l_service_request_rec.last_update_program_code := 'PMCON';
354: l_service_request_rec.program_id := fnd_global.conc_program_id;
355: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
356: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
357: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
358:
351: l_service_request_rec.system_id := l_ump_rec.system_id;
352: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
353: l_service_request_rec.last_update_program_code := 'PMCON';
354: l_service_request_rec.program_id := fnd_global.conc_program_id;
355: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
356: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
357: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
358:
359: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
352: l_service_request_rec.creation_program_code := 'PMCON'; -- Preventive Maintenance concurrent program seeded value
353: l_service_request_rec.last_update_program_code := 'PMCON';
354: l_service_request_rec.program_id := fnd_global.conc_program_id;
355: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
356: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
357: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
358:
359: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
360: l_service_request_rec.ship_to_party_id := l_ump_rec.shipto_party_id;
353: l_service_request_rec.last_update_program_code := 'PMCON';
354: l_service_request_rec.program_id := fnd_global.conc_program_id;
355: l_service_request_rec.program_application_id := fnd_global.prog_appl_id;
356: l_service_request_rec.conc_request_id := fnd_global.conc_request_id;
357: l_service_request_rec.program_login_id := fnd_global.conc_login_id;
358:
359: l_service_request_rec.bill_to_party_id := l_ump_rec.billto_party_id;
360: l_service_request_rec.ship_to_party_id := l_ump_rec.shipto_party_id;
361:
475: p_commit => FND_API.G_FALSE,
476: x_return_status => x_return_status,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,
479: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
480: p_resp_id => FND_GLOBAL.RESP_ID,
481: p_user_id => fnd_global.user_id,
482: p_login_id => fnd_global.conc_login_id,
483: p_org_id => l_ump_rec.authoring_org_id,
476: x_return_status => x_return_status,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,
479: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
480: p_resp_id => FND_GLOBAL.RESP_ID,
481: p_user_id => fnd_global.user_id,
482: p_login_id => fnd_global.conc_login_id,
483: p_org_id => l_ump_rec.authoring_org_id,
484: p_request_id => null,
477: x_msg_count => x_msg_count,
478: x_msg_data => x_msg_data,
479: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
480: p_resp_id => FND_GLOBAL.RESP_ID,
481: p_user_id => fnd_global.user_id,
482: p_login_id => fnd_global.conc_login_id,
483: p_org_id => l_ump_rec.authoring_org_id,
484: p_request_id => null,
485: p_request_number => null,
478: x_msg_data => x_msg_data,
479: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
480: p_resp_id => FND_GLOBAL.RESP_ID,
481: p_user_id => fnd_global.user_id,
482: p_login_id => fnd_global.conc_login_id,
483: p_org_id => l_ump_rec.authoring_org_id,
484: p_request_id => null,
485: p_request_number => null,
486: p_service_request_rec => l_service_request_rec,
504: p_commit => FND_API.G_FALSE,
505: x_return_status => x_return_status,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,
508: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
509: p_resp_id => FND_GLOBAL.RESP_ID,
510: p_user_id => fnd_global.user_id,
511: p_login_id => fnd_global.conc_login_id,
512: p_org_id =>l_ump_rec.authoring_org_id,
505: x_return_status => x_return_status,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,
508: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
509: p_resp_id => FND_GLOBAL.RESP_ID,
510: p_user_id => fnd_global.user_id,
511: p_login_id => fnd_global.conc_login_id,
512: p_org_id =>l_ump_rec.authoring_org_id,
513: p_request_id => null,
506: x_msg_count => x_msg_count,
507: x_msg_data => x_msg_data,
508: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
509: p_resp_id => FND_GLOBAL.RESP_ID,
510: p_user_id => fnd_global.user_id,
511: p_login_id => fnd_global.conc_login_id,
512: p_org_id =>l_ump_rec.authoring_org_id,
513: p_request_id => null,
514: p_request_number => null,
507: x_msg_data => x_msg_data,
508: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
509: p_resp_id => FND_GLOBAL.RESP_ID,
510: p_user_id => fnd_global.user_id,
511: p_login_id => fnd_global.conc_login_id,
512: p_org_id =>l_ump_rec.authoring_org_id,
513: p_request_id => null,
514: p_request_number => null,
515: p_service_request_rec => l_service_request_rec,
560: x_return_status => x_return_status,
561: x_msg_count => x_msg_count,
562: x_msg_data => x_msg_data,
563: p_request_id => x_request_id,
564: p_last_updated_by => fnd_global.user_id,
565: p_last_update_date => sysdate,
566: p_object_version_number=> x_object_version_number,
567: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
568: p_resp_id => FND_GLOBAL.RESP_ID,
563: p_request_id => x_request_id,
564: p_last_updated_by => fnd_global.user_id,
565: p_last_update_date => sysdate,
566: p_object_version_number=> x_object_version_number,
567: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
568: p_resp_id => FND_GLOBAL.RESP_ID,
569: p_service_request_rec => l_service_request_rec,
570: p_notes => l_no_notes_table,
571: p_contacts => l_contacts_table,
564: p_last_updated_by => fnd_global.user_id,
565: p_last_update_date => sysdate,
566: p_object_version_number=> x_object_version_number,
567: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
568: p_resp_id => FND_GLOBAL.RESP_ID,
569: p_service_request_rec => l_service_request_rec,
570: p_notes => l_no_notes_table,
571: p_contacts => l_contacts_table,
572: x_interaction_id => x_interaction_id,
593: l_link_rec.object_id := l_ump_rec.unit_effectivity_id;
594: l_link_rec.object_number := l_ump_rec.title;
595: l_link_rec.object_type := 'AHL_UMP_EFF';
596: l_link_rec.link_type_id := 6;
597: l_link_rec.request_id := fnd_global.conc_request_id;
598: l_link_rec.program_application_id := fnd_global.prog_appl_id;
599: l_link_rec.program_id := fnd_global.conc_program_id;
600: l_link_rec.program_update_date := sysdate;
601: cs_incidentlinks_pub.create_incidentlink(
594: l_link_rec.object_number := l_ump_rec.title;
595: l_link_rec.object_type := 'AHL_UMP_EFF';
596: l_link_rec.link_type_id := 6;
597: l_link_rec.request_id := fnd_global.conc_request_id;
598: l_link_rec.program_application_id := fnd_global.prog_appl_id;
599: l_link_rec.program_id := fnd_global.conc_program_id;
600: l_link_rec.program_update_date := sysdate;
601: cs_incidentlinks_pub.create_incidentlink(
602: p_api_version => 2.0,
595: l_link_rec.object_type := 'AHL_UMP_EFF';
596: l_link_rec.link_type_id := 6;
597: l_link_rec.request_id := fnd_global.conc_request_id;
598: l_link_rec.program_application_id := fnd_global.prog_appl_id;
599: l_link_rec.program_id := fnd_global.conc_program_id;
600: l_link_rec.program_update_date := sysdate;
601: cs_incidentlinks_pub.create_incidentlink(
602: p_api_version => 2.0,
603: p_init_msg_list => FND_API.G_FALSE,
601: cs_incidentlinks_pub.create_incidentlink(
602: p_api_version => 2.0,
603: p_init_msg_list => FND_API.G_FALSE,
604: p_commit => FND_API.G_FALSE,
605: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
606: p_resp_id => FND_GLOBAL.RESP_ID,
607: p_user_id => FND_GLOBAL.USER_ID,
608: p_login_id => NULL,
609: p_org_id
602: p_api_version => 2.0,
603: p_init_msg_list => FND_API.G_FALSE,
604: p_commit => FND_API.G_FALSE,
605: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
606: p_resp_id => FND_GLOBAL.RESP_ID,
607: p_user_id => FND_GLOBAL.USER_ID,
608: p_login_id => NULL,
609: p_org_id
610: =>l_ump_rec.authoring_org_id,
603: p_init_msg_list => FND_API.G_FALSE,
604: p_commit => FND_API.G_FALSE,
605: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
606: p_resp_id => FND_GLOBAL.RESP_ID,
607: p_user_id => FND_GLOBAL.USER_ID,
608: p_login_id => NULL,
609: p_org_id
610: =>l_ump_rec.authoring_org_id,
611: p_link_rec => l_link_rec,
1236: p_commit => FND_API.G_FALSE,
1237: x_return_status => x_return_status,
1238: x_msg_count => x_msg_count,
1239: x_msg_data => x_msg_data,
1240: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1241: p_resp_id => FND_GLOBAL.RESP_ID,
1242: p_user_id => FND_GLOBAL.USER_ID,
1243: p_login_id => fnd_global.conc_login_id,
1244: p_request_id => incident_rec.subject_id,
1237: x_return_status => x_return_status,
1238: x_msg_count => x_msg_count,
1239: x_msg_data => x_msg_data,
1240: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1241: p_resp_id => FND_GLOBAL.RESP_ID,
1242: p_user_id => FND_GLOBAL.USER_ID,
1243: p_login_id => fnd_global.conc_login_id,
1244: p_request_id => incident_rec.subject_id,
1245: p_request_number => NULL,
1238: x_msg_count => x_msg_count,
1239: x_msg_data => x_msg_data,
1240: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1241: p_resp_id => FND_GLOBAL.RESP_ID,
1242: p_user_id => FND_GLOBAL.USER_ID,
1243: p_login_id => fnd_global.conc_login_id,
1244: p_request_id => incident_rec.subject_id,
1245: p_request_number => NULL,
1246: p_object_version_number => incident_rec.object_version_number,
1239: x_msg_data => x_msg_data,
1240: p_resp_appl_id => FND_GLOBAL.RESP_APPL_ID,
1241: p_resp_id => FND_GLOBAL.RESP_ID,
1242: p_user_id => FND_GLOBAL.USER_ID,
1243: p_login_id => fnd_global.conc_login_id,
1244: p_request_id => incident_rec.subject_id,
1245: p_request_number => NULL,
1246: p_object_version_number => incident_rec.object_version_number,
1247: -- status code CLOSED seeded in cs_incident_statuses
1261: P_COMMIT => FND_API.G_FALSE,
1262: P_RESP_APPL_ID => NULL,
1263: P_RESP_ID => NULL,
1264: P_USER_ID => NULL,
1265: P_LOGIN_ID => FND_GLOBAL.CONC_LOGIN_ID,
1266: P_ORG_ID => NULL,
1267: P_LINK_ID => incident_rec.link_id,
1268: X_RETURN_STATUS => x_return_status,
1269: X_MSG_COUNT => x_msg_count,