APPS.QP_LOADER_DIST_PUB dependencies on QP_PRC_CONTEXTS_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 78: (select prc_context_id from qp_prc_contexts_b

74: last_updated_by = decode(x_owner, 'SEED', 1, 'ORACLE', 1, 3),
75: last_update_login = 0,
76: source_lang = userenv('LANG')
77: where prc_context_id =
78: (select prc_context_id from qp_prc_contexts_b
79: where prc_context_code = x_prc_context_code
80: and prc_context_type = x_prc_context_type)
81: and userenv('LANG') in (language, source_lang);
82:

Line 115: select prc_context_id into l_prc_context_id from qp_prc_contexts_b

111: l_user_id := 1;
112: end if;
113:
114: begin
115: select prc_context_id into l_prc_context_id from qp_prc_contexts_b
116: where prc_context_code = x_prc_context_code
117: and prc_context_type = x_prc_context_type
118: and rownum = 1;
119:

Line 121: update qp_prc_contexts_b set

117: and prc_context_type = x_prc_context_type
118: and rownum = 1;
119:
120: if x_application_id = '661' then
121: update qp_prc_contexts_b set
122: seeded_flag = x_seeded_flag,
123: enabled_flag = x_enabled_flag,
124: last_updated_by = l_user_id,
125: last_update_date = nvl(to_date(x_last_update_date,'YYYY/MM/DD'),sysdate),

Line 146: insert into qp_prc_contexts_b (

142: exception
143: when no_data_found then
144: select qp_prc_contexts_s.nextval into l_prc_context_s from dual;
145: begin
146: insert into qp_prc_contexts_b (
147: prc_context_id,
148: prc_context_code,
149: prc_context_type,
150: seeded_flag,

Line 244: prc_context_id = (select prc_context_id from qp_prc_contexts_b

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);
247: if p_detect_dup_mapping_cols( l_segment_id,
248: l_prc_context_id,

Line 314: select prc_context_id into l_prc_context_id from qp_prc_contexts_b

310: null;
311: end;
312:
313: begin
314: select prc_context_id into l_prc_context_id from qp_prc_contexts_b
315: where prc_context_code = x_prc_context_code
316: and prc_context_type = x_prc_context_type
317: and rownum = 1;
318: exception