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 481: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));

477: ,name => 'EVENT');
478:
479: -- get event data
480: EventDocument:=Event.getEventData();
481: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
482: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
483: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
484: '/offer_status_history/offer_status_history_id'));
485:

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

478:
479: -- get event data
480: EventDocument:=Event.getEventData();
481: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
482: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
483: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
484: '/offer_status_history/offer_status_history_id'));
485:
486: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,

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

479: -- get event data
480: EventDocument:=Event.getEventData();
481: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
482: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
483: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,
484: '/offer_status_history/offer_status_history_id'));
485:
486: -- only when the new row is inserted with 'EXTENDED' offer status in irc_offer_status_history table,
487: -- proceed further

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

1451: ,actid => actid
1452: ,name => 'EVENT');
1453:
1454: EventDocument:=Event.getEventData();
1455: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1456: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1457: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1458: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1459:

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

1452: ,name => 'EVENT');
1453:
1454: EventDocument:=Event.getEventData();
1455: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1456: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1457: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1458: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1459:
1460:

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

1453:
1454: EventDocument:=Event.getEventData();
1455: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1456: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1457: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1458: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1459:
1460:
1461: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_ACCEPTED') THEN

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

1454: EventDocument:=Event.getEventData();
1455: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1456: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1457: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
1458: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
1459:
1460:
1461: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_ACCEPTED') THEN
1462: l_apl_response := true;

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

1580: hr_utility.set_location(l_proc, 100);
1581:
1582: IF ( l_apl_accepted = false ) THEN
1583: -- get the decline reason
1584: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
1585: open csr_get_decline_reason(l_decline_reason);
1586: fetch csr_get_decline_reason into l_decline_reason_meaning;
1587: close csr_get_decline_reason;
1588: END IF;

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

1823: ,actid => actid
1824: ,name => 'EVENT');
1825:
1826: EventDocument:=Event.getEventData();
1827: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1828: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1829:
1830:
1831: hr_utility.set_location(l_proc, 30);

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

1824: ,name => 'EVENT');
1825:
1826: EventDocument:=Event.getEventData();
1827: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
1828: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
1829:
1830:
1831: hr_utility.set_location(l_proc, 30);
1832: open csr_onhold_offer(l_offer_id);

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

2022: ,actid => actid
2023: ,name => 'EVENT');
2024:
2025: EventDocument:=Event.getEventData();
2026: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2027: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2028: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2029: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2030:

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

2023: ,name => 'EVENT');
2024:
2025: EventDocument:=Event.getEventData();
2026: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2027: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2028: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2029: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2030:
2031: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);

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

2024:
2025: EventDocument:=Event.getEventData();
2026: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2027: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2028: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2029: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2030:
2031: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);
2032: fetch csr_get_prev_offer_details into l_prev_offer_status,l_prev_change_reason;

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

2025: EventDocument:=Event.getEventData();
2026: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2027: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2028: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2029: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2030:
2031: open csr_get_prev_offer_details(l_offer_status_history_id,l_offer_id);
2032: fetch csr_get_prev_offer_details into l_prev_offer_status,l_prev_change_reason;
2033: close csr_get_prev_offer_details;

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

2174:
2175: hr_utility.set_location('l_action_performer' || l_action_performer, 20);
2176:
2177: -- get the decline reason
2178: l_withdrawal_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
2179: open csr_get_withdrawal_reason(l_withdrawal_reason);
2180: fetch csr_get_withdrawal_reason into l_withdrawal_reason_meaning;
2181: close csr_get_withdrawal_reason;
2182:

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

2400: ,actid => actid
2401: ,name => 'EVENT');
2402:
2403: EventDocument:=Event.getEventData();
2404: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2405: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2406: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2407: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2408:

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

2401: ,name => 'EVENT');
2402:
2403: EventDocument:=Event.getEventData();
2404: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2405: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2406: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2407: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2408:
2409: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN

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

2402:
2403: EventDocument:=Event.getEventData();
2404: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2405: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2406: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2407: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2408:
2409: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN
2410: l_apl_dec_acpt := true;

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

2403: EventDocument:=Event.getEventData();
2404: l_offer_id:= to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_id'));
2405: l_offer_status:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status');
2406: l_change_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/change_reason');
2407: l_offer_status_history_id:=to_number(irc_xml_util.valueOf(EventDocument,'/offer_status_history/offer_status_history_id'));
2408:
2409: IF ( l_offer_status = 'CLOSED' and l_change_reason = 'APL_DECLINED_ACCEPTANCE') THEN
2410: l_apl_dec_acpt := true;
2411: ELSE

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

2460: end if;
2461: close csr_offer_notes;
2462:
2463: -- get the decline reason
2464: l_decline_reason:= irc_xml_util.valueOf(EventDocument,'/offer_status_history/decline_reason');
2465: open csr_get_decline_reason(l_decline_reason);
2466: fetch csr_get_decline_reason into l_decline_reason_meaning;
2467: close csr_get_decline_reason;
2468: