DBA Data[Home] [Help]

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_OSP_PO_PVT

Line 271: l_search_criteria := l_search_criteria || and_str || ' AHL_OSP_PO_PVT.Has_New_PO_Line(OSP.OSP_ORDER_ID) = :b' || l_bind_index;

267: END IF;
268:
269:
270: IF P_search_order_rec.Has_New_PO_Line = 'Y' OR P_search_order_rec.Has_New_PO_Line = 'N' THEN
271: l_search_criteria := l_search_criteria || and_str || ' AHL_OSP_PO_PVT.Has_New_PO_Line(OSP.OSP_ORDER_ID) = :b' || l_bind_index;
272: l_conditions(l_bind_index) := P_search_order_rec.Has_New_PO_Line;
273: l_bind_index := l_bind_index + 1;
274: and_str := ' AND ';
275: END IF;

Line 857: AHL_OSP_PO_PVT.Associate_OSP_With_PO

853: IF G_DEBUG='Y' THEN
854: AHL_DEBUG_PUB.debug('Before Calling Associate_OSP_With_PO', 'GET_HEADER_AND_LINES: ');
855: END IF;
856: -- CALL PO API to synch OSP with PO
857: AHL_OSP_PO_PVT.Associate_OSP_With_PO
858: (
859: p_api_version => p_api_version ,
860: p_init_msg_list => p_init_msg_list,
861: p_commit => p_commit,