APPS.CSM_WF_PKG dependencies on CSF_DEBRIEF_HEADERS

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

1826: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1827: RETURN;
1828: END IF;
1829:
1830: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1831:
1832: csm_debrief_header_event_pkg.debrief_header_ins_init(p_debrief_header_id=>l_debrief_header_id,
1833: p_h_user_id=>NULL,
1834: p_flow_type=>NULL);

Line 1853: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

1849: END CSF_Debrief_Header_Pre_Upd;
1850:
1851: PROCEDURE CSF_Debrief_Header_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
1852: IS
1853: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1854: l_sqlerrno VARCHAR2(20);
1855: l_sqlerrmsg VARCHAR2(4000);
1856: l_error_msg VARCHAR2(4000);
1857: l_return_status VARCHAR2(2000);

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

1871: END IF;
1872:
1873: CSM_UTIL_PKG.LOG('CSM_WF_PKG.CSF_Debrief_Header_Post_Upd: IS_FIELD_SERVICE_PALM_ENABLED' );
1874:
1875: l_debrief_header_id := CSF_DEBRIEF_Headers_PKG.user_hooks_rec.debrief_header_id;
1876:
1877: FOR r_debrief_hdr_rec IN l_debrief_hdr_csr(l_debrief_header_id) LOOP
1878: csm_debrief_header_event_pkg.debrief_header_mdirty_u(p_debrief_header_id=>l_debrief_header_id,
1879: p_user_id=>r_debrief_hdr_rec.user_id);

Line 1894: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;

1890: END CSF_Debrief_Header_Post_Upd;
1891:
1892: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1893: IS
1894: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1895: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1896: l_user_id fnd_user.user_id%type;
1897: l_resource_id jtf_rs_resource_extns.resource_id%type;
1898:

Line 1895: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;

1891:
1892: PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2)
1893: IS
1894: l_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE;
1895: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1896: l_user_id fnd_user.user_id%type;
1897: l_resource_id jtf_rs_resource_extns.resource_id%type;
1898:
1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS

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

1895: l_task_assignment_id csf_debrief_headers.task_assignment_id%type;
1896: l_user_id fnd_user.user_id%type;
1897: l_resource_id jtf_rs_resource_extns.resource_id%type;
1898:
1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1900: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1901: FROM csf_debrief_headers dhdr,
1902: jtf_task_assignments jta,
1903: jtf_rs_resource_extns jtrs

Line 1901: FROM csf_debrief_headers dhdr,

1897: l_resource_id jtf_rs_resource_extns.resource_id%type;
1898:
1899: CURSOR l_csm_debrfdel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%type) IS
1900: SELECT dhdr.task_assignment_id, jtrs.user_id, jta.resource_id
1901: FROM csf_debrief_headers dhdr,
1902: jtf_task_assignments jta,
1903: jtf_rs_resource_extns jtrs
1904: WHERE dhdr.debrief_header_id = p_debrief_header_id
1905: AND jta.task_assignment_id = dhdr.task_assignment_id

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

1910: l_sqlerrmsg VARCHAR2(4000);
1911: l_error_msg VARCHAR2(4000);
1912: l_return_status VARCHAR2(2000);
1913:
1914: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
1915: IS
1916: SELECT dhdr.debrief_header_id, acc.user_id
1917: FROM csf_debrief_headers dhdr,
1918: csm_debrief_headers_acc acc

Line 1917: FROM csf_debrief_headers dhdr,

1913:
1914: CURSOR l_csm_debrfHdDel_csr (p_debrief_header_id csf_debrief_headers.debrief_header_id%TYPE)
1915: IS
1916: SELECT dhdr.debrief_header_id, acc.user_id
1917: FROM csf_debrief_headers dhdr,
1918: csm_debrief_headers_acc acc
1919: WHERE dhdr.debrief_header_id = p_debrief_header_id
1920: AND acc.debrief_header_id = dhdr.debrief_header_id;
1921:

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

1927: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1928: RETURN;
1929: END IF;
1930:
1931: l_debrief_header_id := CSF_DEBRIEF_HEADERS_PKG.user_hooks_rec.debrief_header_id;
1932:
1933: OPEN l_csm_debrfHdDel_csr(l_debrief_header_id);
1934: FETCH l_csm_debrfHdDel_csr INTO l_csm_debrfHdDel_rec;
1935: IF l_csm_debrfHdDel_csr%NOTFOUND THEN