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.13 2011/10/20 14:23:00 ggkrishn ship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: ircomapi.pkb 120.13 2011/10/20 14:23:00 ggkrishn 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 1947: select communication_id, status, object_version_number, object_type, start_date from irc_communications

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

Line 1997: l_communication_id irc_communications.communication_id%type;

1993:
1994:
1995: l_assignmentIdArray assoc_arr;
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;

Line 1998: l_communication_status irc_communications.status%type;

1994:
1995: l_assignmentIdArray assoc_arr;
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;

Line 1999: l_assignmentId irc_communications.object_id%type;

1995: l_assignmentIdArray assoc_arr;
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;

Line 2002: l_object_type irc_communications.object_type%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
2005: --
2006: --Get assignmentId array

Line 2115: l_communication_id irc_communications.communication_id%type;

2111: and object_type ='VACANCY';
2112: --
2113: l_assignmentIdArray assoc_arr;
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;

Line 2116: l_communication_status irc_communications.status%type;

2112: --
2113: l_assignmentIdArray assoc_arr;
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;

Line 2117: l_assignmentId irc_communications.object_id%type;

2113: l_assignmentIdArray assoc_arr;
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;

Line 2120: l_object_type irc_communications.object_type%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
2123: --
2124: --Get assignmentId array

Line 2248: l_comm_rec irc_communications%rowtype;

2244: ,p_source_asg_id in number
2245: ) is
2246:
2247: l_proc varchar2(72) := g_package || 'copy_comm_to_apl_asg';
2248: l_comm_rec irc_communications%rowtype;
2249: l_comm_recp_rec irc_comm_recipients%rowtype;
2250: l_comm_topics irc_comm_topics%rowtype;
2251: irc_comm_msgs irc_comm_messages%rowtype;
2252: l_src_asgn_id number:=p_source_asg_id;

Line 2264: select * from irc_communications

2260: l_src_person_id number;
2261: l_trg_person_id number;
2262: l_dummy_person_id number;
2263: cursor csrGetCommForAsg(src_asgn_id in Number) is
2264: select * from irc_communications
2265: where object_id = src_asgn_id;
2266:
2267: Cursor csrGetCommRec(comm_topic_id in number) is
2268: select * from irc_comm_recipients

Line 2301: irc_communications_api.create_communication

2297: close csrGetCommForAsg;
2298: --
2299: hr_utility.set_location(' Create Communication: ' || l_proc,20);
2300: --
2301: irc_communications_api.create_communication
2302: (p_effective_date => l_eff_date
2303: ,p_communication_property_id => l_comm_rec.communication_property_id
2304: ,p_object_type => l_comm_rec.object_type
2305: ,p_object_id => l_target_asgn_id

Line 2317: irc_communications_api.create_comm_topic

2313: LOOP
2314: --
2315: hr_utility.set_location(' Create topic : ' || l_proc,30);
2316: --
2317: irc_communications_api.create_comm_topic
2318: (p_effective_date => l_eff_date
2319: ,p_communication_id => l_comm_id
2320: ,p_subject => commTopicRec.subject
2321: ,p_status => commTopicRec.status

Line 2331: irc_communications_api.create_message

2327: Loop
2328: --
2329: hr_utility.set_location(' Create message : ' || l_proc,40);
2330: --
2331: irc_communications_api.create_message
2332: (p_effective_date => l_eff_date
2333: ,p_communication_topic_id => l_comm_topic_id
2334: ,p_parent_id => commMessageRec.parent_id
2335: ,p_message_subject => commMessageRec.message_subject

Line 2360: irc_communications_api.add_recipient

2356: end if;
2357: --
2358: hr_utility.set_location(' Create recipient : ' || l_proc,30);
2359: --
2360: irc_communications_api.add_recipient
2361: (p_effective_date => l_eff_date
2362: ,p_communication_object_type => commRecpRec.communication_object_type
2363: ,p_communication_object_id => l_comm_topic_id
2364: ,p_recipient_type => commRecpRec.recipient_type

Line 2381: end IRC_COMMUNICATIONS_API;

2377: exception
2378: when others then
2379: hr_utility.set_location(' Error : '||sqlErrm || l_proc,30);
2380: end copy_comm_to_apl_asg;
2381: end IRC_COMMUNICATIONS_API;