APPS.CS_INCIDENTLINKS_UTIL dependencies on CS_SR_LINK_TYPES_VL

Line 7: -- be defined in cs_sr_link_types_vl.

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CS_INCIDENTLINKS_UTIL';
5:
6: -- Procedure to validate if the passed in link type is valid. Link type should
7: -- be defined in cs_sr_link_types_vl.
8: -- Basic sanity validation
9: PROCEDURE VALIDATE_LINK_TYPE (
10: P_LINK_TYPE_ID IN NUMBER := NULL,
11: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 481: from cs_sr_link_types_vl

477: -- get the link name to set the message token. Using max to avoid no-data-found
478: -- exception; should never result in a no data found exception though.
479: select max(name)
480: into l_link_type_name
481: from cs_sr_link_types_vl
482: where link_type_id = p_link_type_id;
483:
484: if ( p_operation_mode = 'CREATE' ) then
485: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_CIRCULAR_LINK');

Line 593: from cs_sr_link_types_vl

589:
590: -- cursor to get the link name for p_link_type_id and c2rec.link_type_id
591: cursor get_link_name ( c_link_type_id NUMBER) is
592: select name
593: from cs_sr_link_types_vl
594: where link_type_id = c_link_type_id;
595:
596: BEGIN
597: -- Initialize API return status to success

Line 675: from cs_sr_link_types_vl

671: -- get the link name to set the message token. Using max to avoid no-data-found
672: -- exception; should never result in a no data found exception though.
673: select max(name)
674: into l_new_link_type_name
675: from cs_sr_link_types_vl
676: where link_type_id = p_link_type_id;
677:
678: select max(name)
679: into l_existing_link_type_name

Line 680: from cs_sr_link_types_vl

676: where link_type_id = p_link_type_id;
677:
678: select max(name)
679: into l_existing_link_type_name
680: from cs_sr_link_types_vl
681: where link_type_id = c2rec.link_type_id;
682:
683: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
684: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);

Line 708: from cs_sr_link_types_vl

704: -- get the link name to set the message token. Using max to avoid no-data-found
705: -- exception; should never result in a no data found exception though.
706: select max(name)
707: into l_new_link_type_name
708: from cs_sr_link_types_vl
709: where link_type_id = p_link_type_id;
710:
711: select max(name)
712: into l_existing_link_type_name

Line 713: from cs_sr_link_types_vl

709: where link_type_id = p_link_type_id;
710:
711: select max(name)
712: into l_existing_link_type_name
713: from cs_sr_link_types_vl
714: where link_type_id = c2rec.link_type_id;
715:
716: FND_MESSAGE.Set_Name('CS', 'CS_SR_LINK_DUP_ORG_NOT_ALLOW');
717: FND_MESSAGE.Set_Token('LINK_TYPE' , l_new_link_type_name);