APPS.QP_BULK_VALIDATE dependencies on QP_BULK_VALIDATE

Line 1: PACKAGE BODY QP_BULK_VALIDATE AS

1: PACKAGE BODY QP_BULK_VALIDATE AS
2: /* $Header: QPXBLVAB.pls 120.62.12010000.4 2008/11/05 12:07:08 kdurgasi ship $ */
3:
4: function get_count(p_request_id number,
5: p_orig_sys_header_ref VARCHAR2,

Line 310: l_dup_lin_rec qp_bulk_validate.dupl_line_type;

306: l_count2 number;
307: l_orig_sys_header_ref varchar2(50);
308: l_orig_sys_line_ref varchar2(50);
309: l_dummy VARCHAR2(10);
310: l_dup_lin_rec qp_bulk_validate.dupl_line_type;
311: l_check_ipa c_pa_line_ref%ROWTYPE;
312: l_check_qpa c_pa_line_ref%ROWTYPE;
313: l_start_date_active date;
314: l_end_date_active date;

Line 319: l_pa_line_type1 qp_bulk_validate.pa_line_type;

315: l1_orig_sys_header_ref varchar2(50);
316: l1_orig_sys_line_ref varchar2(50);
317:
318: -- Bug 5234939 RAVI START
319: l_pa_line_type1 qp_bulk_validate.pa_line_type;
320: l_pa_line_type2 qp_bulk_validate.pa_line_type;
321: l_pa_count1 Number;
322: l_pa_count2 Number;
323: l_pa_count Number;

Line 320: l_pa_line_type2 qp_bulk_validate.pa_line_type;

316: l1_orig_sys_line_ref varchar2(50);
317:
318: -- Bug 5234939 RAVI START
319: l_pa_line_type1 qp_bulk_validate.pa_line_type;
320: l_pa_line_type2 qp_bulk_validate.pa_line_type;
321: l_pa_count1 Number;
322: l_pa_count2 Number;
323: l_pa_count Number;
324: -- Bug 5234939 RAVI END

Line 6219: where QP_BULK_VALIDATE.product_uom(

6215: and qpip.product_attribute = 'PRICING_ATTRIBUTE2'
6216: AND NOT EXISTS (
6217: select 'EXISTS'
6218: from dual
6219: where QP_BULK_VALIDATE.product_uom(
6220: qpip.product_uom_code,
6221: to_number(qpip.product_attr_value),
6222: qplh.list_header_id) = 'TRUE'
6223: );

Line 6786: END QP_BULK_VALIDATE;

6782: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6783:
6784: END MARK_ERRORED_INTERFACE_RECORD;
6785:
6786: END QP_BULK_VALIDATE;