APPS.OKC_TERMS_DISP_PVT dependencies on OKC_TERMS_ARTSEC_DISP_TEMP

Line 52: FROM okc_terms_artsec_disp_temp

48: RETURN VARCHAR2 IS
49: l_display_order VARCHAR2(2000);
50: CURSOR l_get_display_order IS
51: SELECT terms_display_order
52: FROM okc_terms_artsec_disp_temp
53: WHERE terms_id = p_terms_id
54: AND terms_type = p_terms_type
55: AND processed_flag = 'Y';
56:

Line 90: FROM okc_terms_artsec_disp_temp

86: terms_display_level,
87: LPAD(ROWNUM,5,'0') disp_order,
88: 'Y',
89: runid
90: FROM okc_terms_artsec_disp_temp
91: WHERE document_id = p_document_id
92: AND document_type = p_document_type
93: AND processed_flag = 'N'
94: AND parent_id IS null

Line 111: FROM okc_terms_artsec_disp_temp t

107: parent_id,
108: terms_display_level,
109: terms_display_sequence,
110: runid
111: FROM okc_terms_artsec_disp_temp t
112: WHERE document_id = lc_document_id
113: AND document_type = lc_document_type
114: AND processed_flag = 'N'
115: AND exists (SELECT 1

Line 116: FROM okc_terms_artsec_disp_temp t1

112: WHERE document_id = lc_document_id
113: AND document_type = lc_document_type
114: AND processed_flag = 'N'
115: AND exists (SELECT 1
116: FROM okc_terms_artsec_disp_temp t1
117: WHERE t1.terms_type = 'SECTION'
118: AND t1.terms_id = t.parent_id
119: AND t1.document_id = lc_document_id
120: AND t1.document_type = lc_document_type

Line 128: FROM okc_terms_artsec_disp_temp

124: CURSOR l_max_levels_csr (
125: lc_document_id IN NUMBER,
126: lc_document_type IN VARCHAR2) IS
127: SELECT NVL(MAX(terms_display_level),0)
128: FROM okc_terms_artsec_disp_temp
129: WHERE document_id = lc_document_id
130: AND document_type = lc_document_type
131: AND processed_flag = 'N';
132:

Line 135: DELETE FROM okc_terms_artsec_disp_temp

131: AND processed_flag = 'N';
132:
133: BEGIN
134:
135: DELETE FROM okc_terms_artsec_disp_temp
136: WHERE document_id = p_document_id
137: AND document_type = p_document_type;
138:
139: INSERT INTO okc_terms_artsec_disp_temp

Line 139: INSERT INTO okc_terms_artsec_disp_temp

135: DELETE FROM okc_terms_artsec_disp_temp
136: WHERE document_id = p_document_id
137: AND document_type = p_document_type;
138:
139: INSERT INTO okc_terms_artsec_disp_temp
140: (document_id,
141: document_type,
142: terms_type,
143: terms_id,

Line 169: INSERT INTO okc_terms_artsec_disp_temp

165: start with scn_id is null
166: and document_id = p_document_id
167: and document_type = p_document_type);
168:
169: INSERT INTO okc_terms_artsec_disp_temp
170: (document_id,
171: document_type,
172: terms_type,
173: terms_id,

Line 201: insert into okc_terms_artsec_disp_temp

197: FETCH l_max_levels_csr INTO l_max_level;
198: CLOSE l_max_levels_csr;
199:
200: /***************************************
201: insert into okc_terms_artsec_disp_temp
202: (document_id,
203: document_type,
204: terms_type,
205: terms_id,

Line 221: FROM okc_terms_artsec_disp_temp

217: terms_display_sequence,
218: terms_display_level,
219: LPAD(ROWNUM,5,'0'),
220: 'Y'
221: FROM okc_terms_artsec_disp_temp
222: WHERE document_id = p_document_id
223: AND document_type = p_document_type
224: AND processed_flag = 'N'
225: AND parent_id IS null

Line 233: insert into okc_terms_artsec_disp_temp

229:
230: l_display_order := 1;
231:
232: FOR rec in l_lvl1_scn_csr LOOP
233: insert into okc_terms_artsec_disp_temp
234: (document_id,
235: document_type,
236: terms_type,
237: terms_id,

Line 280: insert into okc_terms_artsec_disp_temp

276: p_terms_id => rec.parent_id);
277: l_old_parent_id := rec.parent_id;
278: END IF;
279:
280: insert into okc_terms_artsec_disp_temp
281: ( document_id,
282: document_type,
283: terms_type,
284: terms_id,

Line 310: DELETE FROM okc_terms_artsec_disp_temp

306: END LOOP;
307:
308:
309: END LOOP;
310: DELETE FROM okc_terms_artsec_disp_temp
311: WHERE document_id = p_document_id
312: AND document_type = p_document_type
313: AND processed_flag = 'N';
314: commit;

Line 332: FROM OKC_TERMS_ARTSEC_DISP_TEMP

328: l_terms_display_order VARCHAR2(2000);
329: l_global_temp_loaded VARCHAR2(1) := 'N';
330: CURSOR l_global_temp_csr IS
331: SELECT '1'
332: FROM OKC_TERMS_ARTSEC_DISP_TEMP
333: WHERE document_type = p_document_type
334: AND document_id = p_document_id
335: AND runid = p_run_id;
336: BEGIN

Line 378: FROM OKC_TERMS_ARTSEC_DISP_TEMP

374: l_global_temp_loaded VARCHAR2(1) := 'N';
375: l_terms_structure_level number := 0;
376: CURSOR l_global_temp_csr IS
377: SELECT '1'
378: FROM OKC_TERMS_ARTSEC_DISP_TEMP
379: WHERE document_type = p_document_type
380: AND document_id = p_document_id;
381: BEGIN
382: /****