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 6773: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;

6769: l_interaction_rec JTF_IH_PUB.interaction_rec_type;
6770: l_activity_rec JTF_IH_PUB.activity_rec_type;
6771:
6772: l_default_int_outcome_id NUMBER;
6773: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;

Line 6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;

6770: l_activity_rec JTF_IH_PUB.activity_rec_type;
6771:
6772: l_default_int_outcome_id NUMBER;
6773: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;

Line 6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

6772: l_default_int_outcome_id NUMBER;
6773: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6780: l_incident_number VARCHAR2(64);

Line 6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;

6773: l_default_int_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6780: l_incident_number VARCHAR2(64);
6781: l_default_result_id NUMBER;

Line 6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;

6774: l_result_reqd jtf_ih_wrap_ups_vl.result_required%TYPE;
6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6780: l_incident_number VARCHAR2(64);
6781: l_default_result_id NUMBER;
6782: l_default_reason_id NUMBER;

Line 6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;

6775: l_default_int_result_id NUMBER;
6776: l_default_int_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6777: l_reason_reqd jtf_ih_wrap_ups_vl.reason_required%TYPE;
6778: l_default_int_reason_id jtf_ih_wrap_ups_vl.reason_id%TYPE;
6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6780: l_incident_number VARCHAR2(64);
6781: l_default_result_id NUMBER;
6782: l_default_reason_id NUMBER;
6783: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

Line 6783: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;

6779: l_default_int_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6780: l_incident_number VARCHAR2(64);
6781: l_default_result_id NUMBER;
6782: l_default_reason_id NUMBER;
6783: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6784: l_activity_id NUMBER;
6785: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6786:
6787: l_default_outcome_id NUMBER;

Line 6785: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;

6781: l_default_result_id NUMBER;
6782: l_default_reason_id NUMBER;
6783: l_default_result jtf_ih_wrap_ups_vl.result_short_desc%TYPE;
6784: l_activity_id NUMBER;
6785: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6786:
6787: l_default_outcome_id NUMBER;
6788: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6789:

Line 6788: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;

6784: l_activity_id NUMBER;
6785: l_default_reason jtf_ih_wrap_ups_vl.reason_short_desc%TYPE;
6786:
6787: l_default_outcome_id NUMBER;
6788: l_default_outcome jtf_ih_wrap_ups_vl.outcome_short_desc%TYPE;
6789:
6790: l_action_item VARCHAR2(80);
6791: l_action VARCHAR2(80);
6792:

Line 6813: from jtf_ih_wrap_ups_vl

6809: result_short_desc,
6810: reason_required,
6811: reason_id,
6812: reason_short_desc
6813: from jtf_ih_wrap_ups_vl
6814: where wrap_id = c_wrap_id;
6815:
6816: CURSOR c_action_item_id IS
6817: SELECT nvl(action_item_id,0)