DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on AHL_PRD_RESOURCE_TRANX_PVT

Line 901: l_PRD_RESOURCE_TXNS_TBL AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;

897: SELECT OPERATION_SEQUENCE_NUM FROM ahl_workorder_operations
898: WHERE WORKORDER_ID = p_WorkorderId
899: AND OPERATION_SEQUENCE_NUM = NVL(p_OperationSequence, OPERATION_SEQUENCE_NUM);
900:
901: l_PRD_RESOURCE_TXNS_TBL AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
902: BEGIN
903: x_return_status := init_user_and_role(p_userid);
904: IF(x_return_status <> Fnd_Api.G_RET_STS_SUCCESS)THEN
905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 995: AHL_PRD_RESOURCE_TRANX_PVT.Get_Resource_Txn_Defaults

991: END LOOP;
992:
993: l_restxns_index := 0;
994: FOR res_txns_defaults IN get_operation_sequences_csr(l_workorder_id, l_operation_sequence)LOOP
995: AHL_PRD_RESOURCE_TRANX_PVT.Get_Resource_Txn_Defaults
996: (
997: p_api_version => 1.0,
998: p_init_msg_list => FND_API.G_TRUE,
999: p_module_type => NULL,

Line 2135: l_res_txns_tbl AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;

2131: x_return_status OUT NOCOPY VARCHAR2,
2132: x_msg_count OUT NOCOPY NUMBER,
2133: x_msg_data OUT NOCOPY VARCHAR2
2134: ) IS
2135: l_res_txns_tbl AHL_PRD_RESOURCE_TRANX_PVT.PRD_RESOURCE_TXNS_TBL;
2136: j INTEGER;
2137: BEGIN
2138: x_return_status := FND_API.G_RET_STS_SUCCESS;
2139: IF(p_ResourceTransactions IS NULL OR p_ResourceTransactions.COUNT < 1)THEN

Line 2177: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns

2173: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_NALWD');
2174: FND_MSG_PUB.ADD;
2175: RAISE FND_API.G_EXC_ERROR;
2176: END IF;
2177: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns
2178: (
2179: p_api_version => 1.0 ,
2180: p_init_msg_list => FND_API.G_TRUE,
2181: p_commit => FND_API.G_FALSE,