APPS.QP_ATM_UPGRADE dependencies on QP_SEGMENTS_B

Line 199: --Private function to check if Segment code exists in QP_SEGMENTS_B table.

195: FUNCTION p_seg_exists (p_prc_context_code in varchar2,
196: p_flexfield_name in varchar2,
197: p_segment_code in varchar2,
198: p_segment_mapping_column in varchar2)
199: --Private function to check if Segment code exists in QP_SEGMENTS_B table.
200: return number is
201: dummy varchar2(1);
202: begin
203: select 'x'

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 485: -- Private procedure to insert Segments in QP_SEGMENTS_B.

481: --
482: PROCEDURE p_insert_segment_b (p_prc_context_id in number,
483: p_valueset_id in number,
484: p_format_type in varchar2) is
485: -- Private procedure to insert Segments in QP_SEGMENTS_B.
486: begin
487: g_segment_seqno := g_segment_seqno + 1;
488: INSERT into QP_SEGMENTS_B
489: (SEGMENT_ID,

Line 488: INSERT into QP_SEGMENTS_B

484: p_format_type in varchar2) is
485: -- Private procedure to insert Segments in QP_SEGMENTS_B.
486: begin
487: g_segment_seqno := g_segment_seqno + 1;
488: INSERT into QP_SEGMENTS_B
489: (SEGMENT_ID,
490: SEGMENT_CODE,
491: PRC_CONTEXT_ID,
492: AVAILABILITY_IN_BASIC,

Line 886: from qp_segments_b b,

882: --
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

Line 898: from qp_segments_b b

894: --
895: delete from qp_pte_segments a
896: where a.pte_code = 'LOGSTX' and
897: exists ( select 'x'
898: from qp_segments_b b
899: where b.segment_id = a.segment_id and
900: b.segment_code = 'COUPON_NO') and
901: a.created_by = 1;
902: --

Line 908: from qp_segments_b b

904: --
905: delete from qp_pte_segments a
906: where a.pte_code <> 'ORDFUL' and
907: exists ( select 'x'
908: from qp_segments_b b
909: where b.segment_id = a.segment_id and
910: b.segment_code = 'Number of students') and
911: a.created_by = 1;
912: */

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 980: delete from qp_segments_b where segment_id = l_segment_id;

976: ' Refer to the Pricing Implementation Guide for details.',1,200),
977: 'Attribute Manager');
978: --
979: delete from qp_segments_tl where segment_id = l_segment_id;
980: delete from qp_segments_b where segment_id = l_segment_id;
981: exception
982: when no_data_found then
983: null;
984: end;

Line 995: from qp_segments_b

991: where prc_context_id < 100000;
992: --
993: select nvl(max(segment_id),100)
994: into g_segment_seqno
995: from qp_segments_b
996: where segment_id < 100000;
997: --
998: select nvl(max(pte_source_system_id),100)
999: into g_ssc_seqno

Line 1084: FROM qp_segments_b a,

1080: --
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,