DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PUB dependencies on AHL_PP_RESRC_REQUIRE_PVT

Line 1891: l_cre_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;

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;

Line 1892: l_upd_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;

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;

Line 1893: l_del_res_reqmts AHL_PP_RESRC_REQUIRE_PVT.Resrc_Require_Tbl_Type;

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:

Line 2061: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(

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,

Line 2078: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(

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,

Line 2156: AHL_PP_RESRC_REQUIRE_PVT.process_resrc_require(

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,