APPS.QP_BULK_VALIDATE dependencies on QP_QUALIFIERS

Line 2655: Select qp_qualifiers_s.nextval

2651: p_qualifier_rec.excluder_flag(I) := 'N';
2652: p_qualifier_rec.orig_sys_line_ref(I) := '-1';
2653:
2654: If p_qualifier_rec.interface_action_code(I)='INSERT' THEN
2655: Select qp_qualifiers_s.nextval
2656: into p_qualifier_rec.qualifier_id(I) from dual;
2657: end if;
2658:
2659:

Line 2963: from qp_qualifiers

2959: l_exist:=null;
2960: -- Check for uniqueness of orig_sys_qualifier_ref
2961: BEGIN
2962: Select 1 INTO l_exist
2963: from qp_qualifiers
2964: where orig_sys_qualifier_ref=p_qualifier_rec.orig_sys_qualifier_ref(I)
2965: and orig_sys_header_ref = p_qualifier_rec.orig_sys_header_ref(I);
2966: EXCEPTION
2967: WHEN NO_DATA_FOUND THEN

Line 3061: from qp_qualifiers

3057: qp_bulk_loader_pub.write_log( 'Secondary Price List duplicate check');
3058: l_exist:=0;
3059: begin
3060: select 1 into l_exist
3061: from qp_qualifiers
3062: where qualifier_context = 'MODLIST'
3063: and qualifier_attribute = 'QUALIFIER_ATTRIBUTE4'
3064: and qualifier_attr_value = to_number(p_qualifier_rec.qualifier_attr_value(I))
3065: -- Bug# 5276935 RAVI