APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMM_PROPERTIES

Line 1477: irc_comm_properties icp,

1473: Cursor cur_vac_id(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1474: --get vacancy_id from topic_id
1475: select icp.object_id
1476: from
1477: irc_comm_properties icp,
1478: irc_communications ic,
1479: irc_comm_topics ict
1480: where
1481: ict.communication_topic_id = p_topic_id

Line 1983: select communication_property_id from irc_comm_properties where

1979: --communication status needs to be updated or a new communication
1980: --needs to be created.
1981: --
1982: cursor cur_get_comm_property(p_assignment_id number) is
1983: select communication_property_id from irc_comm_properties where
1984: object_id = (select distinct vacancy_id from per_all_assignments_f where
1985: assignment_id =p_assignment_id )
1986: and object_type ='VACANCY' ;
1987:

Line 1989: select default_comm_status from irc_comm_properties where

1985: assignment_id =p_assignment_id )
1986: and object_type ='VACANCY' ;
1987:
1988: cursor cur_get_default_comm_status(p_assignment_id number) is
1989: select default_comm_status from irc_comm_properties where
1990: object_id = (select distinct vacancy_id from per_all_assignments_f where
1991: assignment_id =p_assignment_id )
1992: and object_type ='VACANCY' ;
1993:

Line 2000: l_comm_property_id irc_comm_properties.communication_property_id%type;

1996: l_listLength number;
1997: l_communication_id irc_communications.communication_id%type;
1998: l_communication_status irc_communications.status%type;
1999: l_assignmentId irc_communications.object_id%type;
2000: l_comm_property_id irc_comm_properties.communication_property_id%type;
2001: l_object_version_number number;
2002: l_object_type irc_communications.object_type%type;
2003: l_start_date date;
2004: begin

Line 2101: select communication_property_id from irc_comm_properties where

2097: --communication status needs to be updated or a new communication
2098: --needs to be created.
2099: --
2100: cursor cur_get_comm_property(p_assignment_id number) is
2101: select communication_property_id from irc_comm_properties where
2102: object_id = (select distinct vacancy_id from per_all_assignments_f where
2103: assignment_id =p_assignment_id )
2104: and object_type ='VACANCY' ;
2105: --

Line 2108: select default_comm_status from irc_comm_properties where

2104: and object_type ='VACANCY' ;
2105: --
2106: --
2107: cursor cur_get_default_comm_status(p_assignment_id number) is
2108: select default_comm_status from irc_comm_properties where
2109: object_id = (select distinct vacancy_id from per_all_assignments_f where
2110: assignment_id =p_assignment_id )
2111: and object_type ='VACANCY';
2112: --

Line 2118: l_comm_property_id irc_comm_properties.communication_property_id%type;

2114: l_listLength number;
2115: l_communication_id irc_communications.communication_id%type;
2116: l_communication_status irc_communications.status%type;
2117: l_assignmentId irc_communications.object_id%type;
2118: l_comm_property_id irc_comm_properties.communication_property_id%type;
2119: l_object_version_number number;
2120: l_object_type irc_communications.object_type%type;
2121: l_start_date date;
2122: begin