APPS.QP_LOADER_DIST_PUB dependencies on QP_SEGMENTS_B

Line 14: from qp_segments_b a, qp_prc_contexts_b b

10: dummy varchar2(1);
11: begin
12: select 'x'
13: into dummy
14: from qp_segments_b a, qp_prc_contexts_b b
15: where a.prc_context_id = b.prc_context_id and
16: a.prc_context_id = p_prc_context_id and
17: segment_mapping_column = p_segment_mapping_column and
18: segment_code <> p_segment_code and

Line 242: from qp_segments_b

238: select segment_id,
239: prc_context_id
240: into l_segment_id,
241: l_prc_context_id
242: from qp_segments_b
243: where segment_code = x_segment_code and
244: prc_context_id = (select prc_context_id from qp_prc_contexts_b
245: where prc_context_code = x_prc_context_code and
246: prc_context_type = x_prc_context_type);

Line 326: select segment_id into l_segment_id from qp_segments_b

322:
323: if l_prc_context_id is not null then
324:
325: begin
326: select segment_id into l_segment_id from qp_segments_b
327: where segment_code = x_segment_code
328: and prc_context_id = l_prc_context_id;
329:
330: if p_detect_dup_mapping_cols( l_segment_id,

Line 334: update qp_segments_b set

330: if p_detect_dup_mapping_cols( l_segment_id,
331: l_prc_context_id,
332: x_segment_mapping_column,
333: x_segment_code, 'Update') = -1 then
334: update qp_segments_b set
335: availability_in_basic = x_availability_in_basic,
336: application_id = x_application_id,
337: segment_mapping_column = x_segment_mapping_column,
338: seeded_flag = x_seeded_flag,

Line 379: insert into qp_segments_b (

375: if p_detect_dup_mapping_cols( l_segment_id,
376: l_prc_context_id,
377: x_segment_mapping_column,
378: x_segment_code,'Add') = -1 then
379: insert into qp_segments_b (
380: segment_id,
381: segment_code,
382: prc_context_id,
383: availability_in_basic,