DBA Data[Home] [Help]

APPS.QP_VALIDATE dependencies on QP_UTIL

Line 6626: l_org_id number:= QP_UTIL.Get_Item_Validation_Org ;

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

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

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

Line 6666: End if;--QP_UTIL. Get_QP_Status

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

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

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