APPS.CSM_WF_PKG dependencies on CSF_DEBRIEF_LINES

Line 1817: l_debrief_header_id csf_debrief_lines.debrief_header_id%TYPE;

1813: *********************************************************/
1814:
1815: PROCEDURE CSF_Debrief_Header_Post_Ins(x_return_status OUT NOCOPY VARCHAR2)
1816: IS
1817: l_debrief_header_id csf_debrief_lines.debrief_header_id%TYPE;
1818: l_sqlerrno VARCHAR2(20);
1819: l_sqlerrmsg VARCHAR2(4000);
1820: l_error_msg VARCHAR2(4000);
1821: l_return_status VARCHAR2(2000);

Line 1963: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

1959: p_task_assignment_id: DEBRIEF_LINE_ID of the new debrief line
1960: *********************************************************/
1961: PROCEDURE CSF_Debrief_Line_Post_Ins (x_return_status OUT NOCOPY VARCHAR2)
1962: IS
1963: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
1964: l_sqlerrno VARCHAR2(20);
1965: l_sqlerrmsg VARCHAR2(4000);
1966: l_error_msg VARCHAR2(4000);
1967: l_return_status VARCHAR2(2000);

Line 1976: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

1972: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1973: RETURN;
1974: END IF;
1975:
1976: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
1977:
1978: csm_debrief_event_pkg.debrief_line_ins_init(p_debrief_line_id=>l_debrief_line_id,
1979: p_h_user_id=>NULL,
1980: p_flow_type=>NULL);

Line 1999: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

1995: p_task_assignment_id: DEBRIEF_LINE_ID of the debrief line
1996: *********************************************************/
1997: Procedure CSF_Debrief_Line_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
1998: IS
1999: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2000: l_sqlerrno VARCHAR2(20);
2001: l_sqlerrmsg VARCHAR2(4000);
2002: l_error_msg VARCHAR2(4000);
2003: l_return_status VARCHAR2(2000);

Line 2005: CURSOR l_debrief_line_pre_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)

2001: l_sqlerrmsg VARCHAR2(4000);
2002: l_error_msg VARCHAR2(4000);
2003: l_return_status VARCHAR2(2000);
2004:
2005: CURSOR l_debrief_line_pre_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)
2006: IS
2007: SELECT debrief_line_id,
2008: inventory_item_id,
2009: instance_id

Line 2010: FROM csf_debrief_lines

2006: IS
2007: SELECT debrief_line_id,
2008: inventory_item_id,
2009: instance_id
2010: FROM csf_debrief_lines
2011: WHERE debrief_line_id = p_debrief_line_id;
2012:
2013: BEGIN
2014: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2020: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

2016: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2017: RETURN;
2018: END IF;
2019:
2020: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2021:
2022: OPEN l_debrief_line_pre_upd(l_debrief_line_id);
2023: FETCH l_debrief_line_pre_upd INTO g_debrief_line_pre_upd_rec;
2024: IF l_debrief_line_pre_upd%NOTFOUND THEN

Line 2043: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

2039:
2040:
2041: Procedure CSF_Debrief_Line_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
2042: IS
2043: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2044: l_is_inventory_item_updated varchar2(1);
2045: l_is_debrief_instance_updated varchar2(1);
2046: l_sqlerrno VARCHAR2(20);
2047: l_sqlerrmsg VARCHAR2(4000);

Line 2051: CURSOR l_debrief_line_post_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)

2047: l_sqlerrmsg VARCHAR2(4000);
2048: l_error_msg VARCHAR2(4000);
2049: l_return_status VARCHAR2(2000);
2050:
2051: CURSOR l_debrief_line_post_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)
2052: IS
2053: SELECT debrief_line_id,
2054: inventory_item_id,
2055: instance_id

Line 2056: FROM csf_debrief_lines

2052: IS
2053: SELECT debrief_line_id,
2054: inventory_item_id,
2055: instance_id
2056: FROM csf_debrief_lines
2057: WHERE debrief_line_id = p_debrief_line_id;
2058:
2059: r_debrief_line_post_upd_rec l_debrief_line_post_upd%ROWTYPE;
2060:

Line 2068: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

2064: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2065: RETURN;
2066: END IF;
2067:
2068: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2069:
2070: l_is_inventory_item_updated := 'N';
2071: l_is_debrief_instance_updated := 'N';
2072:

Line 2114: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

2110: * Post Delete of CS_DEBRIEF_LINES records.
2111: */
2112: Procedure CSF_Debrief_Line_Post_Del (x_return_status OUT NOCOPY VARCHAR2)
2113: IS
2114: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2115: l_sqlerrno VARCHAR2(20);
2116: l_sqlerrmsg VARCHAR2(4000);
2117: l_error_msg VARCHAR2(4000);
2118: l_return_status VARCHAR2(2000);

Line 2120: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)

2116: l_sqlerrmsg VARCHAR2(4000);
2117: l_error_msg VARCHAR2(4000);
2118: l_return_status VARCHAR2(2000);
2119:
2120: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
2121: IS
2122: SELECT acc.user_id, dbl.debrief_line_id
2123: FROM csf_debrief_lines dbl,
2124: csm_debrief_lines_acc acc

Line 2123: FROM csf_debrief_lines dbl,

2119:
2120: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
2121: IS
2122: SELECT acc.user_id, dbl.debrief_line_id
2123: FROM csf_debrief_lines dbl,
2124: csm_debrief_lines_acc acc
2125: WHERE dbl.debrief_line_id = p_debrief_line_id
2126: AND acc.debrief_line_id = dbl.debrief_line_id;
2127:

Line 2137: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;

2133: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2134: RETURN;
2135: END IF;
2136:
2137: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2138:
2139: OPEN l_csm_debrfLnDel_csr(l_debrief_line_id);
2140: FETCH l_csm_debrfLnDel_csr INTO l_csm_debrfLnDel_rec;
2141: IF l_csm_debrfLnDel_csr%NOTFOUND THEN