APPS.CSL_DEBRIEF_PKG dependencies on CSF_DEBRIEF_LINES

Line 9: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES'; -- publication item name

5: error EXCEPTION;
6:
7: /*** Globals ***/
8: g_object_name CONSTANT VARCHAR2(30) := 'CSL_DEBRIEF_PKG'; -- package name
9: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES'; -- publication item name
10: g_pub_name2 CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS'; -- publication item name
11: g_debug_level NUMBER; -- debug level
12: g_header_id NUMBER := NULL;
13: TYPE Deferred_Line_Tbl_Type IS TABLE OF CSF_DEBRIEF_LINES.DEBRIEF_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 13: TYPE Deferred_Line_Tbl_Type IS TABLE OF CSF_DEBRIEF_LINES.DEBRIEF_LINE_ID%TYPE INDEX BY BINARY_INTEGER;

9: g_pub_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES'; -- publication item name
10: g_pub_name2 CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_HEADERS'; -- publication item name
11: g_debug_level NUMBER; -- debug level
12: g_header_id NUMBER := NULL;
13: TYPE Deferred_Line_Tbl_Type IS TABLE OF CSF_DEBRIEF_LINES.DEBRIEF_LINE_ID%TYPE INDEX BY BINARY_INTEGER;
14: g_deferred_line_id_tbl Deferred_Line_Tbl_Type;
15:
16: /***
17: Cursor to retrieve all debrief lines from the debrief line inqueue that

Line 22: FROM CSL_CSF_DEBRIEF_LINES_INQ dbl

18: have a debrief header record in the debrief header inqueue.
19: ***/
20: CURSOR c_debrief ( b_user_name VARCHAR2, b_tranid NUMBER) is
21: SELECT dbl.*
22: FROM CSL_CSF_DEBRIEF_LINES_INQ dbl
23: , CSL_CSF_DEBRIEF_HEADERS_INQ dbh
24: WHERE dbl.debrief_header_id = dbh.debrief_header_id
25: AND dbl.tranid$$ = b_tranid
26: AND dbl.clid$$cs = b_user_name

Line 37: FROM CSL_CSF_DEBRIEF_LINES_INQ

33: The debrief lines without header remain then.
34: ***/
35: CURSOR c_debrief_no_headers( b_user_name VARCHAR2, b_tranid NUMBER) is
36: SELECT *
37: FROM CSL_CSF_DEBRIEF_LINES_INQ
38: WHERE tranid$$ = b_tranid
39: AND clid$$cs = b_user_name;
40:
41: CURSOR c_debrief_no_lines( b_user_name VARCHAR2, b_tranid NUMBER) is

Line 1639: item CSF_DEBRIEF_LINES is dirty. This happens when a mobile field service

1635: END PROCESS_DEBRIEF_NO_LINES;
1636:
1637: /***
1638: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication
1639: item CSF_DEBRIEF_LINES is dirty. This happens when a mobile field service
1640: device executed DML on an updatable table and did a fast sync. This
1641: procedure will insert the data that came from mobile into the backend
1642: tables using public APIs.
1643: ***/