APPS.QP_BULK_VALIDATE dependencies on QP_QUALIFIERS

Line 2783: Select qp_qualifiers_s.nextval

2779: p_qualifier_rec.excluder_flag(I) := 'N';
2780: p_qualifier_rec.orig_sys_line_ref(I) := '-1';
2781:
2782: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2783: Select qp_qualifiers_s.nextval
2784: into p_qualifier_rec.qualifier_id(I) from dual;
2785: end if;
2786:
2787:

Line 3091: from qp_qualifiers

3087: l_exist:=null;
3088: -- Check for uniqueness of orig_sys_qualifier_ref
3089: BEGIN
3090: Select 1 INTO l_exist
3091: from qp_qualifiers
3092: where orig_sys_qualifier_ref=p_qualifier_rec.orig_sys_qualifier_ref(I)
3093: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I);
3094: EXCEPTION
3095: WHEN NO_DATA_FOUND THEN

Line 3188: from qp_qualifiers

3184: qp_bulk_loader_pub.write_log( 'Secondary Price List duplicate check');
3185: l_exist:=0;
3186: begin
3187: select 1 into l_exist
3188: from qp_qualifiers
3189: where qualifier_context = 'MODLIST'
3190: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
3191: and qualifier_attr_value = to_number(p_qualifier_rec.qualifier_attr_value(I))
3192: -- Bug# 5276935 RAVI