APPS.QP_ATM_UPGRADE dependencies on QP_PRC_CONTEXTS_B

Line 175: --Private function to check if Context code exists in QP_PRC_CONTEXTS_B table.

171: --
172: FUNCTION p_con_exists (p_prc_context_code in varchar2,
173: p_flexfield_name in varchar2,
174: x_prc_context_id out NOCOPY /* file.sql.39 change */ number)
175: --Private function to check if Context code exists in QP_PRC_CONTEXTS_B table.
176: return number is
177: l_prc_context_id number(15);
178: begin
179: select prc_context_id

Line 181: from qp_prc_contexts_b

177: l_prc_context_id number(15);
178: begin
179: select prc_context_id
180: into l_prc_context_id
181: from qp_prc_contexts_b
182: where prc_context_code = p_prc_context_code and
183: ((p_flexfield_name = 'QP_ATTR_DEFNS_QUALIFIER' and prc_context_type = 'QUALIFIER') or
184: (p_flexfield_name <> 'QP_ATTR_DEFNS_QUALIFIER' and prc_context_type <> 'QUALIFIER')) and
185: rownum = 1;

Line 205: from qp_segments_b a,qp_prc_contexts_b b

201: dummy varchar2(1);
202: begin
203: select 'x'
204: into dummy
205: from qp_segments_b a,qp_prc_contexts_b b
206: where a.prc_context_id = b.prc_context_id and
207: b.prc_context_code = p_prc_context_code and
208: (a.segment_code = p_segment_code or a.segment_mapping_column = p_segment_mapping_column) and
209: ((p_flexfield_name = 'QP_ATTR_DEFNS_QUALIFIER' and b.prc_context_type = 'QUALIFIER') or

Line 403: -- Private procedure to insert Contexts in QP_PRC_CONTEXTS_B.

399: X_LAST_UPDATE_LOGIN => null);
400: end;
401: --
402: PROCEDURE p_insert_context_b (p_flexfield_name in varchar2) is
403: -- Private procedure to insert Contexts in QP_PRC_CONTEXTS_B.
404: begin
405: g_context_seqno := g_context_seqno + 1;
406: INSERT into QP_PRC_CONTEXTS_B
407: (PRC_CONTEXT_ID,

Line 406: INSERT into QP_PRC_CONTEXTS_B

402: PROCEDURE p_insert_context_b (p_flexfield_name in varchar2) is
403: -- Private procedure to insert Contexts in QP_PRC_CONTEXTS_B.
404: begin
405: g_context_seqno := g_context_seqno + 1;
406: INSERT into QP_PRC_CONTEXTS_B
407: (PRC_CONTEXT_ID,
408: PRC_CONTEXT_CODE,
409: PRC_CONTEXT_TYPE,
410: SEEDED_FLAG,

Line 887: qp_prc_contexts_b c

883: delete from qp_pte_segments a
884: where a.pte_code <> 'LOGSTX' and
885: exists ( select 'x'
886: from qp_segments_b b,
887: qp_prc_contexts_b c
888: where b.prc_context_id = c.prc_context_id and
889: b.segment_id = a.segment_id and
890: c.prc_context_code = 'LOGISTICS') and
891: a.created_by = 1;

Line 953: from qp_segments_b a, qp_prc_contexts_b b

949: select a.segment_id,
950: a.segment_code
951: into l_segment_id,
952: l_segment_code
953: from qp_segments_b a, qp_prc_contexts_b b
954: where a.prc_context_id = b.prc_context_id and
955: a.prc_context_id = p_prc_context_id and
956: segment_mapping_column = p_segment_mapping_column and
957: segment_code <> p_segment_code and

Line 990: from qp_prc_contexts_b

986: PROCEDURE p_initialize_sequences is
987: begin
988: select nvl(max(prc_context_id),100)
989: into g_context_seqno
990: from qp_prc_contexts_b
991: where prc_context_id < 100000;
992: --
993: select nvl(max(segment_id),100)
994: into g_segment_seqno

Line 1085: qp_prc_contexts_b b

1081: CURSOR all_segments_cur is
1082: SELECT b.prc_context_code,
1083: a.*
1084: FROM qp_segments_b a,
1085: qp_prc_contexts_b b
1086: WHERE b.prc_context_id = a.prc_context_id;
1087: --
1088: CURSOR pte_seg_cur (p_prc_context_code in varchar2,
1089: p_segment_mapping_column in varchar2) is