1887: x_return_status OUT NOCOPY VARCHAR2,
1888: x_msg_count OUT NOCOPY NUMBER,
1889: x_msg_data OUT NOCOPY VARCHAR2
1890: )IS
1891: l_cre_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1892: l_upd_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1893: l_del_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1894: j INTEGER;
1895: k INTEGER;
1888: x_msg_count OUT NOCOPY NUMBER,
1889: x_msg_data OUT NOCOPY VARCHAR2
1890: )IS
1891: l_cre_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1892: l_upd_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1893: l_del_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1894: j INTEGER;
1895: k INTEGER;
1896: l INTEGER;
1889: x_msg_data OUT NOCOPY VARCHAR2
1890: )IS
1891: l_cre_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1892: l_upd_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1893: l_del_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;
1894: j INTEGER;
1895: k INTEGER;
1896: l INTEGER;
1897:
2057: j := 1;
2058:
2059: p_x_ResourceRequirements := l_dummy_ResourceRequirements;--initialize
2060: IF(l_del_res_reqmts IS NOT NULL AND l_del_res_reqmts.COUNT > 0)THEN
2061: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(
2062: p_api_version => 1.0,
2063: p_init_msg_list => FND_API.G_TRUE,
2064: p_commit => FND_API.G_FALSE,
2065: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2074: RAISE FND_API.G_EXC_ERROR;
2075: END IF;
2076: END IF;
2077: IF(l_upd_res_reqmts IS NOT NULL AND l_upd_res_reqmts.COUNT > 0)THEN
2078: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(
2079: p_api_version => 1.0,
2080: p_init_msg_list => FND_API.G_TRUE,
2081: p_commit => FND_API.G_FALSE,
2082: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2152: j := j+1;
2153: END LOOP;
2154: END IF;
2155: IF(l_cre_res_reqmts IS NOT NULL AND l_cre_res_reqmts.COUNT >0)THEN
2156: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(
2157: p_api_version => 1.0,
2158: p_init_msg_list => FND_API.G_TRUE,
2159: p_commit => FND_API.G_FALSE,
2160: p_validation_level => FND_API.G_VALID_LEVEL_FULL,