DBA Data[Home] [Help]

APPS.QP_VALIDATE dependencies on QP_UTIL

Line 6624: l_org_id number:= QP_UTIL.Get_Item_Validation_Org ;

6620: l_temp number := 0;
6621: l_valid_uom number:= 0;
6622: l_pte_code varchar2(30);
6623: l_ss_code varchar2(30);
6624: l_org_id number:= QP_UTIL.Get_Item_Validation_Org ;
6625:
6626: BEGIN
6627: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>In procedure QP_VALIDATE.product_uom()');
6628: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);

Line 6632: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing

6628: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_product_uom_code: '||p_product_uom_code);
6629: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_category_id: '||p_category_id);
6630: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>p_list_header_id: '||p_list_header_id);
6631:
6632: if QP_UTIL. Get_QP_Status <> 'I' then --advanced pricing
6633: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>basic pricing ');
6634: l_temp := 0;
6635: else
6636: select pte_code, source_system_code into l_pte_code, l_ss_code from qp_list_headers_all_b

Line 6664: End if;--QP_UTIL. Get_QP_Status

6660: else
6661: l_temp := 0;
6662: end if;
6663: end loop;
6664: End if;--QP_UTIL. Get_QP_Status
6665:
6666: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_temp: '||l_temp);
6667: oe_debug_Pub.add('>>>>>>>>>>>>>>>>>>>>>>>>l_org_id: '||l_org_id);
6668:

Line 17809: l_dummy := QP_UTIL.Validate_Org_Id(p_org_id);

17805: RETURN TRUE;
17806: END IF;
17807:
17808:
17809: l_dummy := QP_UTIL.Validate_Org_Id(p_org_id);
17810:
17811: IF l_dummy = 'Y' THEN
17812: RETURN TRUE;
17813: ELSIF l_dummy = 'N' THEN