APPS.QP_ATM_UPGRADE dependencies on QP_ATTRIBUTE_SOURCING

Line 154: --Private function to check if given Segment,Request Type exist in QP_ATTRIBUTE_SOURCING table.

150: FUNCTION p_sourcing_exists(p_segment_id in number,
151: p_request_type_code in varchar2,
152: p_attribute_sourcing_level in varchar2)
153: return number is
154: --Private function to check if given Segment,Request Type exist in QP_ATTRIBUTE_SOURCING table.
155: dummy varchar2(1);
156: begin
157: select 'x'
158: into dummy

Line 159: from qp_attribute_sourcing

155: dummy varchar2(1);
156: begin
157: select 'x'
158: into dummy
159: from qp_attribute_sourcing
160: where segment_id = p_segment_id and
161: request_type_code = p_request_type_code and
162: attribute_sourcing_level = p_attribute_sourcing_level and
163: rownum = 1;

Line 794: -- Private procedure to insert Sourcing rules in QP_ATTRIBUTE_SOURCING.

790: PROCEDURE p_insert_sourcing( p_request_type_code in varchar2,
791: p_attribute_sourcing_level in varchar2,
792: p_value_string in varchar2,
793: p_enabled_flag in varchar2) is
794: -- Private procedure to insert Sourcing rules in QP_ATTRIBUTE_SOURCING.
795: begin
796: g_source_seqno := g_source_seqno + 1;
797: INSERT into QP_ATTRIBUTE_SOURCING
798: (ATTRIBUTE_SOURCING_ID,

Line 797: INSERT into QP_ATTRIBUTE_SOURCING

793: p_enabled_flag in varchar2) is
794: -- Private procedure to insert Sourcing rules in QP_ATTRIBUTE_SOURCING.
795: begin
796: g_source_seqno := g_source_seqno + 1;
797: INSERT into QP_ATTRIBUTE_SOURCING
798: (ATTRIBUTE_SOURCING_ID,
799: SEGMENT_ID,
800: REQUEST_TYPE_CODE,
801: ATTRIBUTE_SOURCING_LEVEL,

Line 921: from qp_attribute_sourcing b,

917: delete from qp_pte_segments a
918: where a.pte_code = 'INTCOM' and
919: a.seeded_sourcing_method = 'ATTRIBUTE MAPPING' and
920: not exists ( select 'x'
921: from qp_attribute_sourcing b,
922: qp_pte_request_types_b c
923: where b.segment_id = a.segment_id and
924: b.request_type_code = c.request_type_code and
925: a.pte_code = c.pte_code) and

Line 935: from qp_attribute_sourcing b,

931: delete from qp_pte_segments a
932: where a.pte_code = 'DEMAND' and
933: a.seeded_sourcing_method = 'ATTRIBUTE MAPPING' and
934: not exists ( select 'x'
935: from qp_attribute_sourcing b,
936: qp_pte_request_types_b c
937: where b.segment_id = a.segment_id and
938: b.request_type_code = c.request_type_code and
939: a.pte_code = c.pte_code) and

Line 1010: from qp_attribute_sourcing

1006: where segment_pte_id < 100000;
1007: --
1008: select nvl(max(attribute_sourcing_id),100)
1009: into g_source_seqno
1010: from qp_attribute_sourcing
1011: where attribute_sourcing_id < 100000;
1012: end;
1013: --
1014: PROCEDURE upgrade_atm is