eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMMUNICATIONS

Line 1: Package Body IRC_COMMUNICATIONS_API as

1: Package Body IRC_COMMUNICATIONS_API as
2: /* $Header: ircomapi.pkb 120.6.12010000.4 2008/11/14 14:46:27 amikukum ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'IRC_COMMUNICATIONS_API.';

2: /* $Header: ircomapi.pkb 120.6.12010000.4 2008/11/14 14:46:27 amikukum ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'IRC_COMMUNICATIONS_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-------------------------< DEFINE_COMM_PROPERTIES >------------------------|
10: -- ----------------------------------------------------------------------------

Line 64: irc_communications_bk1.define_comm_properties_b

60: --
61: -- Call Before Process User Hook
62: --
63: begin
64: irc_communications_bk1.define_comm_properties_b
65: (p_effective_date => p_effective_date
66: ,p_object_type => p_object_type
67: ,p_object_id => p_object_id
68: ,p_default_comm_status => p_default_comm_status

Line 145: irc_communications_bk1.define_comm_properties_a

141: --
142: -- Call After Process User Hook
143: --
144: begin
145: irc_communications_bk1.define_comm_properties_a
146: (p_effective_date => p_effective_date
147: ,p_object_type => p_object_type
148: ,p_object_id => p_object_id
149: ,p_default_comm_status => p_default_comm_status

Line 289: irc_communications_bk2.update_comm_properties_b

285: --
286: -- Call Before Process User Hook
287: --
288: begin
289: irc_communications_bk2.update_comm_properties_b
290: (p_effective_date => p_effective_date
291: ,p_object_type => p_object_type
292: ,p_object_id => p_object_id
293: ,p_default_comm_status => p_default_comm_status

Line 374: irc_communications_bk2.update_comm_properties_a

370: --
371: -- Call After Process User Hook
372: --
373: begin
374: irc_communications_bk2.update_comm_properties_a
375: (p_effective_date => p_effective_date
376: ,p_object_type => p_object_type
377: ,p_object_id => p_object_id
378: ,p_default_comm_status => p_default_comm_status

Line 487: irc_communications_bk3.create_communication_b

483: --
484: -- Call Before Process User Hook
485: --
486: begin
487: irc_communications_bk3.create_communication_b
488: (p_effective_date => p_effective_date
489: ,p_communication_property_id => p_communication_property_id
490: ,p_object_type => p_object_type
491: ,p_object_id => p_object_id

Line 521: irc_communications_bk3.create_communication_a

517: --
518: -- Call After Process User Hook
519: --
520: begin
521: irc_communications_bk3.create_communication_a
522: (p_effective_date => p_effective_date
523: ,p_communication_property_id => p_communication_property_id
524: ,p_object_type => p_object_type
525: ,p_object_id => p_object_id

Line 701: irc_communications_bk4.update_communication_b

697: --
698: -- Call Before Process User Hook
699: --
700: begin
701: irc_communications_bk4.update_communication_b
702: (p_effective_date => p_effective_date
703: ,p_communication_property_id => p_communication_property_id
704: ,p_communication_id => p_communication_id
705: ,p_object_type => p_object_type

Line 739: irc_communications_bk4.update_communication_a

735: --
736: -- Call After Process User Hook
737: --
738: begin
739: irc_communications_bk4.update_communication_a
740: (p_effective_date => p_effective_date
741: ,p_communication_property_id => p_communication_property_id
742: ,p_object_type => p_object_type
743: ,p_object_id => p_object_id

Line 981: irc_communications_bk5.create_comm_topic_b

977: --
978: -- Call Before Process User Hook
979: --
980: begin
981: irc_communications_bk5.create_comm_topic_b
982: (p_effective_date => p_effective_date
983: ,p_communication_id => p_communication_id
984: ,p_subject => p_subject
985: ,p_status => p_status

Line 1011: irc_communications_bk5.create_comm_topic_a

1007: --
1008: -- Call After Process User Hook
1009: --
1010: begin
1011: irc_communications_bk5.create_comm_topic_a
1012: (p_effective_date => p_effective_date
1013: ,p_communication_id => p_communication_id
1014: ,p_subject => p_subject
1015: ,p_status => p_status

Line 1111: irc_communications_bk6.create_message_b

1107: --
1108: -- Call Before Process User Hook
1109: --
1110: begin
1111: irc_communications_bk6.create_message_b
1112: (p_effective_date => p_effective_date
1113: ,p_communication_topic_id => p_communication_topic_id
1114: ,p_parent_id => p_parent_id
1115: ,p_message_subject => p_message_subject

Line 1155: irc_communications_bk6.create_message_a

1151: --
1152: -- Call After Process User Hook
1153: --
1154: begin
1155: irc_communications_bk6.create_message_a
1156: (p_effective_date => p_effective_date
1157: ,p_communication_topic_id => p_communication_topic_id
1158: ,p_parent_id => p_parent_id
1159: ,p_message_subject => p_message_subject

Line 1247: irc_communications_bk7.update_message_b

1243: --
1244: -- Call Before Process User Hook
1245: --
1246: begin
1247: irc_communications_bk7.update_message_b
1248: (p_effective_date => p_effective_date
1249: ,p_deleted_flag => p_deleted_flag
1250: ,p_communication_message_id => p_communication_message_id
1251: ,p_object_version_number => l_object_version_number

Line 1275: irc_communications_bk7.update_message_a

1271: --
1272: -- Call After Process User Hook
1273: --
1274: begin
1275: irc_communications_bk7.update_message_a
1276: (p_effective_date => p_effective_date
1277: ,p_deleted_flag => p_deleted_flag
1278: ,p_communication_message_id => p_communication_message_id
1279: ,p_object_version_number => l_object_version_number

Line 1367: irc_communications_bk8.ADD_RECIPIENT_b

1363: --
1364: -- Call Before Process User Hook
1365: --
1366: begin
1367: irc_communications_bk8.ADD_RECIPIENT_b
1368: (p_effective_date => p_effective_date
1369: ,p_communication_object_type => p_communication_object_type
1370: ,p_communication_object_id => p_communication_object_id
1371: ,p_recipient_type => p_recipient_type

Line 1405: irc_communications_bk8.add_recipient_a

1401: --
1402: -- Call After Process User Hook
1403: --
1404: begin
1405: irc_communications_bk8.add_recipient_a
1406: (p_effective_date => p_effective_date
1407: ,p_communication_object_type => p_communication_object_type
1408: ,p_communication_object_id => p_communication_object_id
1409: ,p_recipient_type => p_recipient_type

Line 1478: irc_communications ic,

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
1482: and ic.communication_id = ict.communication_id

Line 1508: irc_communications ic,

1504: --get applicant for application attached to the given topic
1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,
1508: irc_communications ic,
1509: irc_comm_topics ict
1510: where
1511: ict.communication_topic_id = p_topic_id
1512: and ic.communication_id = ict.communication_id

Line 1946: select communication_id, status, object_version_number, object_type, start_date from irc_communications

1942: ,p_start_dateOut out nocopy date
1943: ) return boolean is
1944:
1945: cursor cur_get_communication is
1946: select communication_id, status, object_version_number, object_type, start_date from irc_communications
1947: where object_type ='APPL' and object_id = p_assignmentIdIn;
1948:
1949: begin
1950: open cur_get_communication;

Line 1996: l_communication_id irc_communications.communication_id%type;

1992:
1993:
1994: l_assignmentIdArray assoc_arr;
1995: l_listLength number;
1996: l_communication_id irc_communications.communication_id%type;
1997: l_communication_status irc_communications.status%type;
1998: l_assignmentId irc_communications.object_id%type;
1999: l_comm_property_id irc_comm_properties.communication_property_id%type;
2000: l_object_version_number number;

Line 1997: l_communication_status irc_communications.status%type;

1993:
1994: l_assignmentIdArray assoc_arr;
1995: l_listLength number;
1996: l_communication_id irc_communications.communication_id%type;
1997: l_communication_status irc_communications.status%type;
1998: l_assignmentId irc_communications.object_id%type;
1999: l_comm_property_id irc_comm_properties.communication_property_id%type;
2000: l_object_version_number number;
2001: l_object_type irc_communications.object_type%type;

Line 1998: l_assignmentId irc_communications.object_id%type;

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

Line 2001: l_object_type irc_communications.object_type%type;

1997: l_communication_status irc_communications.status%type;
1998: l_assignmentId irc_communications.object_id%type;
1999: l_comm_property_id irc_comm_properties.communication_property_id%type;
2000: l_object_version_number number;
2001: l_object_type irc_communications.object_type%type;
2002: l_start_date date;
2003: begin
2004: --
2005: --Get assignmentId array

Line 2114: l_communication_id irc_communications.communication_id%type;

2110: and object_type ='VACANCY';
2111: --
2112: l_assignmentIdArray assoc_arr;
2113: l_listLength number;
2114: l_communication_id irc_communications.communication_id%type;
2115: l_communication_status irc_communications.status%type;
2116: l_assignmentId irc_communications.object_id%type;
2117: l_comm_property_id irc_comm_properties.communication_property_id%type;
2118: l_object_version_number number;

Line 2115: l_communication_status irc_communications.status%type;

2111: --
2112: l_assignmentIdArray assoc_arr;
2113: l_listLength number;
2114: l_communication_id irc_communications.communication_id%type;
2115: l_communication_status irc_communications.status%type;
2116: l_assignmentId irc_communications.object_id%type;
2117: l_comm_property_id irc_comm_properties.communication_property_id%type;
2118: l_object_version_number number;
2119: l_object_type irc_communications.object_type%type;

Line 2116: l_assignmentId irc_communications.object_id%type;

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

Line 2119: l_object_type irc_communications.object_type%type;

2115: l_communication_status irc_communications.status%type;
2116: l_assignmentId irc_communications.object_id%type;
2117: l_comm_property_id irc_comm_properties.communication_property_id%type;
2118: l_object_version_number number;
2119: l_object_type irc_communications.object_type%type;
2120: l_start_date date;
2121: begin
2122: --
2123: --Get assignmentId array

Line 2234: end IRC_COMMUNICATIONS_API;

2230: commit;
2231: end;
2232: --
2233: --
2234: end IRC_COMMUNICATIONS_API;