APPS.PER_RI_WORKBENCH_PKG dependencies on PER_RI_DEPENDENCIES

Line 338: From per_ri_dependencies

334: ) Is
335:
336: Cursor csr_dep Is
337: Select 1
338: From per_ri_dependencies
339: where workbench_item_code = p_workbench_item_code
340: and dependent_item_code = p_dependent_item_code ;
341:
342: l_temp Number;

Line 349: Insert Into per_ri_dependencies(workbench_item_code,dependent_item_code,dependency_item_sequence)

345:
346: Open csr_dep;
347: Fetch csr_dep Into l_temp;
348: If csr_dep%NotFound Then
349: Insert Into per_ri_dependencies(workbench_item_code,dependent_item_code,dependency_item_sequence)
350: values(p_workbench_item_code,p_dependent_item_code,p_dependency_item_sequence) ;
351: Else
352: update per_ri_dependencies
353: set dependency_item_sequence = p_dependency_item_sequence

Line 352: update per_ri_dependencies

348: If csr_dep%NotFound Then
349: Insert Into per_ri_dependencies(workbench_item_code,dependent_item_code,dependency_item_sequence)
350: values(p_workbench_item_code,p_dependent_item_code,p_dependency_item_sequence) ;
351: Else
352: update per_ri_dependencies
353: set dependency_item_sequence = p_dependency_item_sequence
354: where workbench_item_code = p_workbench_item_code
355: and dependent_item_code = p_dependent_item_code ;
356: End If;