4339: --Start of Comments
4340: --Name: is_complex_work_po
4341: --
4342: -- Function:
4343: -- This is wrapper function on PO_COMPLEX_WORK_PVT.is_complex_work_
4344: -- PO_COMPLEX_WORK_PVT.is_complex_work_po returns boolean,so cannot be used
4345: -- in sql statmemt
4346: -- So creating a wrapper on it, that will return 'Y'/'N'.
4347:
4340: --Name: is_complex_work_po
4341: --
4342: -- Function:
4343: -- This is wrapper function on PO_COMPLEX_WORK_PVT.is_complex_work_
4344: -- PO_COMPLEX_WORK_PVT.is_complex_work_po returns boolean,so cannot be used
4345: -- in sql statmemt
4346: -- So creating a wrapper on it, that will return 'Y'/'N'.
4347:
4348: --Parameters:
4371: PO_DEBUG.debug_begin(d_module);
4372: PO_DEBUG.debug_var(d_module,l_progress,'p_doc_id',p_doc_id);
4373: END IF;
4374:
4375: IF PO_COMPLEX_WORK_PVT.is_complex_work_po(
4376: p_po_header_id => p_doc_id) THEN
4377:
4378: RETURN 'Y';
4379: ELSE