APPS.CSM_WF_PKG dependencies on CSF_DEBRIEF_HEADERS

Line 1840: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;

1836: l_error_msg VARCHAR2(4000);
1837: l_return_status VARCHAR2(2000);
1838:
1839: BEGIN
1840: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1841:
1842: x_return_status := FND_API.G_RET_STS_SUCCESS;
1843:
1844: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN

Line 1869: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

1865: END CSF_Debrief_Header_Pre_Upd;
1866:
1867: PROCEDURE CSF_Debrief_Header_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
1868: IS
1869: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1870: l_sqlerrno VARCHAR2(20);
1871: l_sqlerrmsg VARCHAR2(4000);
1872: l_error_msg VARCHAR2(4000);
1873: l_return_status VARCHAR2(2000);

Line 1885: l_debrief_header_id := CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;

1881:
1882: BEGIN
1883: x_return_status := FND_API.G_RET_STS_SUCCESS;
1884:
1885: l_debrief_header_id := CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;
1886:
1887: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1888: RETURN;
1889: END IF;

Line 1910: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

1906: END CSF_Debrief_Header_Post_Upd;
1907:
1908: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1909: IS
1910: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1912: l_user_id fnd_user.user_id%type;
1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:

Line 1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;

1907:
1908: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1909: IS
1910: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1912: l_user_id fnd_user.user_id%type;
1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS

Line 1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS

1911: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1912: l_user_id fnd_user.user_id%type;
1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1917: FROM csf_debrief_headers dhdr,
1918: jtf_task_assignments jta,
1919: jtf_rs_resource_extns jtrs

Line 1917: FROM csf_debrief_headers dhdr,

1913: l_resource_id jtf_rs_resource_extns.resource_id%type;
1914:
1915: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1916: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1917: FROM csf_debrief_headers dhdr,
1918: jtf_task_assignments jta,
1919: jtf_rs_resource_extns jtrs
1920: WHERE dhdr.debrief_header_id = p_debrief_header_id
1921: AND jta.task_assignment_id = dhdr.task_assignment_id

Line 1930: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)

1926: l_sqlerrmsg VARCHAR2(4000);
1927: l_error_msg VARCHAR2(4000);
1928: l_return_status VARCHAR2(2000);
1929:
1930: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
1931: IS
1932: SELECT dhdr.debrief_header_id, acc.user_id
1933: FROM csf_debrief_headers dhdr,
1934: csm_debrief_headers_acc acc

Line 1933: FROM csf_debrief_headers dhdr,

1929:
1930: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
1931: IS
1932: SELECT dhdr.debrief_header_id, acc.user_id
1933: FROM csf_debrief_headers dhdr,
1934: csm_debrief_headers_acc acc
1935: WHERE dhdr.debrief_header_id = p_debrief_header_id
1936: AND acc.debrief_header_id = dhdr.debrief_header_id;
1937:

Line 1943: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;

1939:
1940: BEGIN
1941: x_return_status := FND_API.G_RET_STS_SUCCESS;
1942:
1943: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1944:
1945: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1946: RETURN;
1947: END IF;