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 167: INSERT INTO okc_terms_artsec_disp_temp

163: and document_type = p_document_type
164: connect by prior id = scn_id
165: start with scn_id is null);
166:
167: INSERT INTO okc_terms_artsec_disp_temp
168: (document_id,
169: document_type,
170: terms_type,
171: terms_id,

Line 199: insert into okc_terms_artsec_disp_temp

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

Line 219: FROM okc_terms_artsec_disp_temp

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

Line 231: insert into okc_terms_artsec_disp_temp

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

Line 278: insert into okc_terms_artsec_disp_temp

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

Line 308: DELETE FROM okc_terms_artsec_disp_temp

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

Line 330: FROM OKC_TERMS_ARTSEC_DISP_TEMP

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

Line 376: FROM OKC_TERMS_ARTSEC_DISP_TEMP

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