APPS.CSM_MULTI_MOBQRY_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 928: FROM JTF_TASK_ASSIGNMENTS

924: l_header_rec.requirement_header_id:=P_REQ_HDR_ID;
925: l_header_rec.ADDRESS_TYPE := NVL(P_ADDRESS_TYPE,'R'); --C or R or T
926:
927: SELECT TASK_ID INTO l_task_id
928: FROM JTF_TASK_ASSIGNMENTS
929: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);
930:
931: IF NVL(P_SHIP_LOC_SRC,'HR')='HZ' THEN
932: l_header_rec.SHIP_TO_LOCATION_ID:=get_hr_location(p_user_name,l_task_id,P_SHIP_LOC_ID); --party site

Line 1006: FROM JTF_TASK_ASSIGNMENTS

1002: l_err:=true;
1003: END IF;
1004:
1005: SELECT TASK_ID INTO l_task_id
1006: FROM JTF_TASK_ASSIGNMENTS
1007: WHERE TASK_ASSIGNMENT_ID=(SELECT TASK_ASSIGNMENT_ID FROM CSP_REQUIREMENT_HEADERS WHERE REQUIREMENT_HEADER_ID=P_REQ_HDR_ID);
1008:
1009: IF NVL(P_SHIP_LOC_SRC,'HR')='HZ' THEN
1010: l_hr_loc_id:=get_hr_location(p_user_name,l_task_id,P_SHIP_LOC_ID); --party site

Line 1867: FROM JTF_TASK_ASSIGNMENTS

1863: l_ta_audit_id NUMBER;
1864:
1865: CURSOR c_get_ovn IS
1866: SELECT object_version_number
1867: FROM JTF_TASK_ASSIGNMENTS
1868: WHERE TASK_ASSIGNMENT_ID=to_number(P_TA_ID);
1869:
1870: CURSOR c_task_status IS
1871: SELECT name FROM JTF_TASK_STATUSES_TL WHERE TASK_STATUS_ID=to_number(P_TA_ST_ID)

Line 1885: l_old_taa jtf_task_assignments%rowtype;

1881: l_closed_flag VARCHAR2(1);
1882: l_completed_flag VARCHAR2(1);
1883: l_debrief_header_id NUMBER;
1884:
1885: l_old_taa jtf_task_assignments%rowtype;
1886: l_new_taa jtf_task_assignments%rowtype;
1887:
1888: CURSOR c_audit
1889: IS select * from jtf_task_assignments where task_assignment_id=to_number(p_ta_id);

Line 1886: l_new_taa jtf_task_assignments%rowtype;

1882: l_completed_flag VARCHAR2(1);
1883: l_debrief_header_id NUMBER;
1884:
1885: l_old_taa jtf_task_assignments%rowtype;
1886: l_new_taa jtf_task_assignments%rowtype;
1887:
1888: CURSOR c_audit
1889: IS select * from jtf_task_assignments where task_assignment_id=to_number(p_ta_id);
1890:

Line 1889: IS select * from jtf_task_assignments where task_assignment_id=to_number(p_ta_id);

1885: l_old_taa jtf_task_assignments%rowtype;
1886: l_new_taa jtf_task_assignments%rowtype;
1887:
1888: CURSOR c_audit
1889: IS select * from jtf_task_assignments where task_assignment_id=to_number(p_ta_id);
1890:
1891: CURSOR c_chk_task_status ( p_task_assignment_id NUMBER ) IS
1892: SELECT dh.debrief_header_id, tst.rejected_flag,
1893: tst.on_hold_flag, tst.cancelled_flag,

Line 1895: FROM jtf_task_assignments tas, csf_debrief_headers dh,

1891: CURSOR c_chk_task_status ( p_task_assignment_id NUMBER ) IS
1892: SELECT dh.debrief_header_id, tst.rejected_flag,
1893: tst.on_hold_flag, tst.cancelled_flag,
1894: tst.closed_flag, tst.completed_flag
1895: FROM jtf_task_assignments tas, csf_debrief_headers dh,
1896: jtf_task_statuses_b tst
1897: WHERE tas.task_assignment_id = p_task_assignment_id
1898: AND tas.task_assignment_id = dh.task_assignment_id
1899: AND tas.assignment_status_id = tst.task_status_id;