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_OFFER_NOTIFICATIONS_PKG dependencies on IRC_XML_UTIL

Line 333: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

329: ,name => 'EVENT');
330:
331: -- get event data
332: EventDocument:=Event.getEventData();
333: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
334: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
335: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
336: '/offer_status_history/offer_status_history_id'));
337:

Line 334: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');

330:
331: -- get event data
332: EventDocument:=Event.getEventData();
333: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
334: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
335: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
336: '/offer_status_history/offer_status_history_id'));
337:
338: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,

Line 335: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,

331: -- get event data
332: EventDocument:=Event.getEventData();
333: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
334: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
335: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
336: '/offer_status_history/offer_status_history_id'));
337:
338: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,
339: -- proceed further

Line 947: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

943: ,actid => actid
944: ,name => 'EVENT');
945:
946: EventDocument:=Event.getEventData();
947: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
948: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
949: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
950: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
951:

Line 948: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');

944: ,name => 'EVENT');
945:
946: EventDocument:=Event.getEventData();
947: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
948: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
949: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
950: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
951:
952:

Line 949: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');

945:
946: EventDocument:=Event.getEventData();
947: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
948: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
949: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
950: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
951:
952:
953: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_ACCEPTED') THEN

Line 950: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));

946: EventDocument:=Event.getEventData();
947: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
948: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
949: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
950: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
951:
952:
953: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_ACCEPTED') THEN
954: l_apl_response := true;

Line 1060: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');

1056: hr_utility.set_location(l_proc, 100);
1057:
1058: IF ( l_apl_accepted = false ) THEN
1059: -- get the decline reason
1060: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
1061: open csr_get_decline_reason(l_decline_reason);
1062: fetch csr_get_decline_reason into l_decline_reason_meaning;
1063: close csr_get_decline_reason;
1064: END IF;

Line 1233: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

1229: ,actid => actid
1230: ,name => 'EVENT');
1231:
1232: EventDocument:=Event.getEventData();
1233: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1234: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1235:
1236:
1237: hr_utility.set_location(l_proc, 30);

Line 1234: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');

1230: ,name => 'EVENT');
1231:
1232: EventDocument:=Event.getEventData();
1233: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1234: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1235:
1236:
1237: hr_utility.set_location(l_proc, 30);
1238: open csr_onhold_offer(l_offer_id);

Line 1398: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

1394: ,actid => actid
1395: ,name => 'EVENT');
1396:
1397: EventDocument:=Event.getEventData();
1398: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1399: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1400: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1401: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1402:

Line 1399: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');

1395: ,name => 'EVENT');
1396:
1397: EventDocument:=Event.getEventData();
1398: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1399: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1400: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1401: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1402:
1403: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);

Line 1400: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');

1396:
1397: EventDocument:=Event.getEventData();
1398: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1399: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1400: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1401: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1402:
1403: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);
1404: fetch csr_get_prev_offer_details into l_prev_offer_status,l_prev_change_reason;

Line 1401: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));

1397: EventDocument:=Event.getEventData();
1398: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1399: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1400: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1401: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1402:
1403: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);
1404: fetch csr_get_prev_offer_details into l_prev_offer_status,l_prev_change_reason;
1405: close csr_get_prev_offer_details;

Line 1526: l_withdrawal_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');

1522:
1523: hr_utility.set_location('l_action_performer' || l_action_performer, 20);
1524:
1525: -- get the decline reason
1526: l_withdrawal_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
1527: open csr_get_withdrawal_reason(l_withdrawal_reason);
1528: fetch csr_get_withdrawal_reason into l_withdrawal_reason_meaning;
1529: close csr_get_withdrawal_reason;
1530:

Line 1704: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

1700: ,actid => actid
1701: ,name => 'EVENT');
1702:
1703: EventDocument:=Event.getEventData();
1704: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1705: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1706: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1707: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1708:

Line 1705: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');

1701: ,name => 'EVENT');
1702:
1703: EventDocument:=Event.getEventData();
1704: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1705: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1706: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1707: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1708:
1709: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN

Line 1706: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');

1702:
1703: EventDocument:=Event.getEventData();
1704: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1705: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1706: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1707: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1708:
1709: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN
1710: l_apl_dec_acpt := true;

Line 1707: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));

1703: EventDocument:=Event.getEventData();
1704: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1705: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1706: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1707: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1708:
1709: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN
1710: l_apl_dec_acpt := true;
1711: ELSE

Line 1764: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');

1760: end if;
1761: close csr_offer_notes;
1762:
1763: -- get the decline reason
1764: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
1765: open csr_get_decline_reason(l_decline_reason);
1766: fetch csr_get_decline_reason into l_decline_reason_meaning;
1767: close csr_get_decline_reason;
1768: