APPS.QP_LIST_UPGRADE_UTIL_PVT dependencies on QP_QUALIFIERS

Line 923: INSERT INTO qp_QUALIFIERS (

919:
920: BEGIN
921: --dbms_output.put_line('pr6');
922:
923: INSERT INTO qp_QUALIFIERS (
924: QUALIFIER_ID,
925: CREATION_DATE,
926: CREATED_BY,
927: LAST_UPDATE_DATE,

Line 946: QP_QUALIFIERS_S.nextval,

942: ,ORIG_SYS_LINE_REF
943: ,ORIG_SYS_HEADER_REF
944: )
945: select
946: QP_QUALIFIERS_S.nextval,
947: sysdate,
948: 1,
949: sysdate,
950: 1,

Line 963: ,to_char(QP_QUALIFIERS_S.currval)

959: l_datatype,
960: l_precedence,
961: NULL
962: --ENH Upgrade BOAPI for orig_sys...ref RAVI
963: ,to_char(QP_QUALIFIERS_S.currval)
964: ,null
965: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)
966: from dual
967: WHERE NOT EXISTS ( select null

Line 968: from qp_qualifiers

964: ,null
965: ,(select h.ORIG_SYSTEM_HEADER_REF from qp_list_headers_b h where h.list_header_id=l_secondary_price_list_id)
966: from dual
967: WHERE NOT EXISTS ( select null
968: from qp_qualifiers
969: where qualifier_context = 'MODLIST'
970: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
971: and qualifier_attr_value = to_char(l_price_list_id)
972: and comparison_operator_code = '='

Line 998: INSERT INTO qp_QUALIFIERS (

994:
995: BEGIN
996:
997: --dbms_output.put_line('pr8');
998: INSERT INTO qp_QUALIFIERS (
999: QUALIFIER_ID,
1000: CREATION_DATE,
1001: CREATED_BY,
1002: LAST_UPDATE_DATE,

Line 1016: QP_QUALIFIERS_S.nextval,

1012: QUALIFIER_DATATYPE,
1013: QUALIFIER_PRECEDENCE,
1014: QUALIFIER_ATTR_VALUE_TO)
1015: select
1016: QP_QUALIFIERS_S.nextval,
1017: sysdate,
1018: 1,
1019: sysdate,
1020: 1,

Line 1034: from qp_qualifiers

1030: l_precedence,
1031: NULL
1032: from dual
1033: WHERE NOT EXISTS ( select null
1034: from qp_qualifiers
1035: where qualifier_context = 'MODLIST'
1036: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
1037: and qualifier_attr_value = prc_list_maps(l_price_list_id).new_list_header_id
1038: and comparison_operator_code = '='