231: x_req_header_id_succ_tbl(l_out_header_count) :=
232: p_req_header_id_tbl(i);
233: -- Set the org context
234: IF(l_org_id_tbl(i) IS NOT NULL) THEN
235: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
237: PO_MOAC_UTILS_PVT.set_org_context(l_org_id_tbl(i)) ; --
238: --END IF; --
239: END IF;
232: p_req_header_id_tbl(i);
233: -- Set the org context
234: IF(l_org_id_tbl(i) IS NOT NULL) THEN
235: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
236: --IF(l_original_org_context <> l_org_id_tbl(i)) THEN --
238: --END IF; --
239: END IF;
240:
233: -- Set the org context
234: IF(l_org_id_tbl(i) IS NOT NULL) THEN
235: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
236: --IF(l_original_org_context <> l_org_id_tbl(i)) THEN --
237: PO_MOAC_UTILS_PVT.set_org_context(l_org_id_tbl(i)) ; --
239: END IF;
240:
241: -- Send email notification of the success of the return
245: commit;
246: -- Set back the org context
247: --Commented out as code below. This is now handled
248: --in PO_MOAC_UTILS.set_org_context
249: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_context) ; --
251: END LOOP;
252:
253: -- End of API body