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.CSM_WF_PKG dependencies on CSF_DEBRIEF_LINES

Line 1833: l_debrief_header_id csf_debrief_lines.debrief_header_id%TYPE;

1829: *********************************************************/
1830:
1831: PROCEDURE CSF_Debrief_Header_Post_Ins(x_return_status OUT NOCOPY VARCHAR2)
1832: IS
1833: l_debrief_header_id csf_debrief_lines.debrief_header_id%TYPE;
1834: l_sqlerrno VARCHAR2(20);
1835: l_sqlerrmsg VARCHAR2(4000);
1836: l_error_msg VARCHAR2(4000);
1837: l_return_status VARCHAR2(2000);

Line 1979: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

1975: p_task_assignment_id: DEBRIEF_LINE_ID of the new debrief line
1976: *********************************************************/
1977: PROCEDURE CSF_Debrief_Line_Post_Ins (x_return_status OUT NOCOPY VARCHAR2)
1978: IS
1979: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
1980: l_sqlerrno VARCHAR2(20);
1981: l_sqlerrmsg VARCHAR2(4000);
1982: l_error_msg VARCHAR2(4000);
1983: l_return_status VARCHAR2(2000);

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

1984:
1985: BEGIN
1986: x_return_status := FND_API.G_RET_STS_SUCCESS;
1987:
1988: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
1989:
1990: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
1991: RETURN;
1992: END IF;

Line 2015: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

2011: p_task_assignment_id: DEBRIEF_LINE_ID of the debrief line
2012: *********************************************************/
2013: Procedure CSF_Debrief_Line_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2)
2014: IS
2015: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2016: l_sqlerrno VARCHAR2(20);
2017: l_sqlerrmsg VARCHAR2(4000);
2018: l_error_msg VARCHAR2(4000);
2019: l_return_status VARCHAR2(2000);

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

2017: l_sqlerrmsg VARCHAR2(4000);
2018: l_error_msg VARCHAR2(4000);
2019: l_return_status VARCHAR2(2000);
2020:
2021: CURSOR l_debrief_line_pre_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)
2022: IS
2023: SELECT debrief_line_id,
2024: inventory_item_id,
2025: instance_id

Line 2026: FROM csf_debrief_lines

2022: IS
2023: SELECT debrief_line_id,
2024: inventory_item_id,
2025: instance_id
2026: FROM csf_debrief_lines
2027: WHERE debrief_line_id = p_debrief_line_id;
2028:
2029: BEGIN
2030: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2032: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2033: RETURN;
2034: END IF;
2035:
2036: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2037:
2038: OPEN l_debrief_line_pre_upd(l_debrief_line_id);
2039: FETCH l_debrief_line_pre_upd INTO g_debrief_line_pre_upd_rec;
2040: IF l_debrief_line_pre_upd%NOTFOUND THEN

Line 2059: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

2055:
2056:
2057: Procedure CSF_Debrief_Line_Post_Upd(x_return_status OUT NOCOPY VARCHAR2)
2058: IS
2059: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2060: l_is_inventory_item_updated varchar2(1);
2061: l_is_debrief_instance_updated varchar2(1);
2062: l_sqlerrno VARCHAR2(20);
2063: l_sqlerrmsg VARCHAR2(4000);

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

2063: l_sqlerrmsg VARCHAR2(4000);
2064: l_error_msg VARCHAR2(4000);
2065: l_return_status VARCHAR2(2000);
2066:
2067: CURSOR l_debrief_line_post_upd (p_debrief_line_id csf_debrief_lines.debrief_line_id%type)
2068: IS
2069: SELECT debrief_line_id,
2070: inventory_item_id,
2071: instance_id

Line 2072: FROM csf_debrief_lines

2068: IS
2069: SELECT debrief_line_id,
2070: inventory_item_id,
2071: instance_id
2072: FROM csf_debrief_lines
2073: WHERE debrief_line_id = p_debrief_line_id;
2074:
2075: r_debrief_line_post_upd_rec l_debrief_line_post_upd%ROWTYPE;
2076:

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

2076:
2077: BEGIN
2078: x_return_status := FND_API.G_RET_STS_SUCCESS;
2079:
2080: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2081:
2082: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2083: RETURN;
2084: END IF;

Line 2130: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;

2126: * Post Delete of CS_DEBRIEF_LINES records.
2127: */
2128: Procedure CSF_Debrief_Line_Post_Del (x_return_status OUT NOCOPY VARCHAR2)
2129: IS
2130: l_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE;
2131: l_sqlerrno VARCHAR2(20);
2132: l_sqlerrmsg VARCHAR2(4000);
2133: l_error_msg VARCHAR2(4000);
2134: l_return_status VARCHAR2(2000);

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

2132: l_sqlerrmsg VARCHAR2(4000);
2133: l_error_msg VARCHAR2(4000);
2134: l_return_status VARCHAR2(2000);
2135:
2136: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
2137: IS
2138: SELECT acc.user_id, dbl.debrief_line_id
2139: FROM csf_debrief_lines dbl,
2140: csm_debrief_lines_acc acc

Line 2139: FROM csf_debrief_lines dbl,

2135:
2136: CURSOR l_csm_debrfLnDel_csr (p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
2137: IS
2138: SELECT acc.user_id, dbl.debrief_line_id
2139: FROM csf_debrief_lines dbl,
2140: csm_debrief_lines_acc acc
2141: WHERE dbl.debrief_line_id = p_debrief_line_id
2142: AND acc.debrief_line_id = dbl.debrief_line_id;
2143:

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

2145:
2146: BEGIN
2147: x_return_status := FND_API.G_RET_STS_SUCCESS;
2148:
2149: l_debrief_line_id := CSF_DEBRIEF_LINES_PKG.user_hooks_rec.debrief_line_id;
2150:
2151: IF NOT CSM_UTIL_PKG.IS_FIELD_SERVICE_PALM_ENABLED THEN
2152: RETURN;
2153: END IF;