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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on JTF_IH_WRAP_UPS_VL

Line 6709: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;

6705: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
6706: l_activity_rec JTF_IH_PUB.activity_rec_type;
6707:
6708: l_default_int_outcome_id NUMBER;
6709: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;

Line 6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;

6706: l_activity_rec JTF_IH_PUB.activity_rec_type;
6707:
6708: l_default_int_outcome_id NUMBER;
6709: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;

Line 6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

6708: l_default_int_outcome_id NUMBER;
6709: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6716: l_incident_number VARCHAR2(64);

Line 6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;

6709: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6716: l_incident_number VARCHAR2(64);
6717: l_default_result_id NUMBER;

Line 6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;

6710: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6716: l_incident_number VARCHAR2(64);
6717: l_default_result_id NUMBER;
6718: l_default_reason_id NUMBER;

Line 6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;

6711: l_default_int_result_id NUMBER;
6712: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6713: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6714: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6716: l_incident_number VARCHAR2(64);
6717: l_default_result_id NUMBER;
6718: l_default_reason_id NUMBER;
6719: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

Line 6719: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

6715: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6716: l_incident_number VARCHAR2(64);
6717: l_default_result_id NUMBER;
6718: l_default_reason_id NUMBER;
6719: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6720: l_activity_id NUMBER;
6721: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6722:
6723: l_default_outcome_id NUMBER;

Line 6721: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;

6717: l_default_result_id NUMBER;
6718: l_default_reason_id NUMBER;
6719: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6720: l_activity_id NUMBER;
6721: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6722:
6723: l_default_outcome_id NUMBER;
6724: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6725:

Line 6724: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;

6720: l_activity_id NUMBER;
6721: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6722:
6723: l_default_outcome_id NUMBER;
6724: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6725:
6726: l_action_item VARCHAR2(80);
6727: l_action VARCHAR2(80);
6728:

Line 6749: from jtf_ih_wrap_ups_vl

6745: result_short_desc,
6746: reason_required,
6747: reason_id,
6748: reason_short_desc
6749: from jtf_ih_wrap_ups_vl
6750: where wrap_id = c_wrap_id;
6751:
6752: CURSOR c_action_item_id IS
6753: SELECT nvl(action_item_id,0)