APPS.ENG_NEW_ITEM_REQ_UTIL dependencies on ENG_NIR_UTIL_PKG

Line 770: -- The query in the ENG_NIR_UTIL_PKG.set_nir_item_approval_status() is returning no rows because change subjects are not yet created.

766: END LOOP;
767:
768: -- Bug 6162913
769: -- Added the following because the items approval status is not getting updated in the NIR newly created from the excel import flow
770: -- The query in the ENG_NIR_UTIL_PKG.set_nir_item_approval_status() is returning no rows because change subjects are not yet created.
771: -- This is requuired because the lifecycle is created first and the subjects were getting created later
772: -- So we have to reset the Item approval status again after creating the NIR.
773:
774: --bug 14376801 begin

Line 780: ENG_NIR_UTIL_PKG.set_nir_item_approval_status (l_change_ids_array(l_nir_created),

776: then
777: for l_nir_created IN l_change_ids_array.FIRST .. l_change_ids_array.LAST
778: LOOP
779:
780: ENG_NIR_UTIL_PKG.set_nir_item_approval_status (l_change_ids_array(l_nir_created),
781: Eng_Workflow_Util.G_REQUESTED,
782: x_return_status => x_return_status,
783: x_msg_count => x_msg_count,
784: x_msg_data => x_msg_data);

Line 789: ENG_NIR_UTIL_PKG.set_nir_item_approval_status (l_change_ids_array_all(l_nir_created),

785: END LOOP;
786: else --bug 14376801 [for P_NIR_OPTION is I, use l_change_ids_array_all]
787: for l_nir_created IN l_change_ids_array_all.FIRST .. l_change_ids_array_all.LAST
788: LOOP
789: ENG_NIR_UTIL_PKG.set_nir_item_approval_status (l_change_ids_array_all(l_nir_created),
790: Eng_Workflow_Util.G_REQUESTED,
791: x_return_status => x_return_status,
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data);