193: x_req_header_id_succ_tbl(l_out_header_count) :=
194: p_req_header_id_tbl(i);
195: -- Set the org context
196: IF(l_org_id_tbl(i) IS NOT NULL) THEN
197: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
199: PO_MOAC_UTILS_PVT.set_org_context(l_org_id_tbl(i)) ; --
200: --END IF; --
201: END IF;
194: p_req_header_id_tbl(i);
195: -- Set the org context
196: IF(l_org_id_tbl(i) IS NOT NULL) THEN
197: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
198: --IF(l_original_org_context <> l_org_id_tbl(i)) THEN --
200: --END IF; --
201: END IF;
202:
195: -- Set the org context
196: IF(l_org_id_tbl(i) IS NOT NULL) THEN
197: l_original_org_context := PO_MOAC_UTILS_PVT.get_current_org_id; --
198: --IF(l_original_org_context <> l_org_id_tbl(i)) THEN --
199: PO_MOAC_UTILS_PVT.set_org_context(l_org_id_tbl(i)) ; --
201: END IF;
202:
203: -- Send email notification of the success of the return
207: commit;
208: -- Set back the org context
209: --Commented out as code below. This is now handled
210: --in PO_MOAC_UTILS.set_org_context
211: PO_MOAC_UTILS_PVT.set_org_context(l_original_org_context) ; --
213: END LOOP;
214:
215: -- End of API body