[Home] [Help]
1872: AR.activity_id,
1873: AR.cost_basis_id,
1874: AR.scheduled_type_id,
1875: AR.autocharge_type_id,
1876: AR.standard_rate_flag,
1877: AR.schedule_seq
1878: FROM AHL_RT_OPER_RESOURCES AR
1879: WHERE AR.association_type_code='OPERATION'
1880: AND AR.object_id=c_operation_id;
2045: --p_x_resource_tbl(l_res_ctr).duration :=l_oper_resource_rec.duration;
2046: p_x_resource_tbl(l_res_ctr).quantity :=l_oper_resource_rec.quantity;
2047: p_x_resource_tbl(l_res_ctr).cost_basis_code :=l_oper_resource_rec.cost_basis_id;
2048: p_x_resource_tbl(l_res_ctr).charge_type_code :=l_oper_resource_rec.autocharge_type_id;
2049: p_x_resource_tbl(l_res_ctr).std_rate_flag_code :=l_oper_resource_rec.standard_rate_flag;
2050: p_x_resource_tbl(l_res_ctr).scheduled_type_code :=l_oper_resource_rec.scheduled_type_id;
2051: --JKJAIN US space FP for ER # 6998882 -- start
2052: p_x_resource_tbl(l_res_ctr).schedule_seq_num :=l_oper_resource_rec.schedule_seq;
2053: --JKJAIN US space FP for ER # 6998882 -- end
2085: AR.activity_id,
2086: AR.cost_basis_id,
2087: AR.scheduled_type_id,
2088: AR.autocharge_type_id,
2089: AR.standard_rate_flag,
2090: AR.schedule_seq
2091: FROM AHL_RT_OPER_RESOURCES AR
2092: WHERE AR.association_type_code=c_association_type
2093: AND AR.object_id=c_object_id;
2259: -- End OGMA Issue # 105 - Balaji
2260: p_x_resource_tbl(l_res_ctr).quantity :=l_rt_oper_resource_rec.quantity;
2261: p_x_resource_tbl(l_res_ctr).cost_basis_code :=l_rt_oper_resource_rec.cost_basis_id;
2262: p_x_resource_tbl(l_res_ctr).charge_type_code :=l_rt_oper_resource_rec.autocharge_type_id;
2263: p_x_resource_tbl(l_res_ctr).std_rate_flag_code :=l_rt_oper_resource_rec.standard_rate_flag;
2264: p_x_resource_tbl(l_res_ctr).scheduled_type_code :=l_rt_oper_resource_rec.scheduled_type_id;
2265: -- JKJAIN US space FP for ER # 6998882 -- start
2266: p_x_resource_tbl(l_res_ctr).schedule_seq_num :=l_rt_oper_resource_rec.schedule_seq;
2267: -- JKJAIN US space FP for ER # 6998882 -- end
2362: -- End OGMA Issue # 105 - Balaji
2363: p_x_resource_tbl(l_res_ctr).quantity :=l_rt_oper_resource_rec.quantity;
2364: p_x_resource_tbl(l_res_ctr).cost_basis_code :=l_rt_oper_resource_rec.cost_basis_id;
2365: p_x_resource_tbl(l_res_ctr).charge_type_code :=l_rt_oper_resource_rec.autocharge_type_id;
2366: p_x_resource_tbl(l_res_ctr).std_rate_flag_code :=l_rt_oper_resource_rec.standard_rate_flag;
2367: p_x_resource_tbl(l_res_ctr).scheduled_type_code :=l_rt_oper_resource_rec.scheduled_type_id;
2368: -- JKJAIN US space FP for ER # 6998882 -- start
2369: p_x_resource_tbl(l_res_ctr).schedule_seq_num :=l_rt_oper_resource_rec.schedule_seq;
2370: -- JKJAIN US space FP for ER # 6998882 -- end
6935: AHL_DEBUG_PUB.enable_debug;
6936: AHL_DEBUG_PUB.debug( l_full_name || '.begin - At the start of API' );
6937: END IF;
6938:
6939: -- Standard start of API savepoint
6940: SAVEPOINT process_stage_jobs_pvt;
6941:
6942: -- Standard call to check for call compatibility
6943: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
6938:
6939: -- Standard start of API savepoint
6940: SAVEPOINT process_stage_jobs_pvt;
6941:
6942: -- Standard call to check for call compatibility
6943: IF NOT FND_API.compatible_api_call( l_api_version, p_api_version,
6944: l_api_name, G_PKG_NAME ) THEN
6945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6946: END IF;
7310:
7311: END IF; -- p_module_type = 'VST'
7312:
7313:
7314: -- Standard check of p_commit
7315: IF FND_API.TO_BOOLEAN( p_commit ) THEN
7316: COMMIT WORK;
7317: END IF;
7318:
10070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
10071: fnd_log.string(fnd_log.level_procedure,'ahl.plsql.AHL_PRD_WORKORDER_PVT.Reschedule_Visit_Jobs.begin',
10072: 'At the start of PLSQL procedure');
10073: END IF;
10074: -- Standard start of API savepoint
10075: SAVEPOINT Reschedule_Visit_Jobs;
10076: --
10077: IF NOT FND_API.compatible_api_call(l_api_version,
10078: p_api_version,
10547: 'ahl.plsql.AHL_PRD_WORKORDER_PVT.INSERT_TURNOVER_NOTES.begin',
10548: 'At the start of PLSQL procedure'
10549: );
10550: END IF;
10551: -- Standard start of API savepoint
10552: SAVEPOINT INSERT_TURNOVER_NOTES;
10553:
10554: -- Standard call to check for call compatibility
10555: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
10550: END IF;
10551: -- Standard start of API savepoint
10552: SAVEPOINT INSERT_TURNOVER_NOTES;
10553:
10554: -- Standard call to check for call compatibility
10555: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version,l_api_name, G_PKG_NAME ) THEN
10556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10557: END IF;
10558: -- Initialize message list if p_init_msg_list is set to TRUE
10673: IF x_msg_count > 0 THEN
10674: RAISE FND_API.G_EXC_ERROR;
10675: END IF;
10676:
10677: -- Standard check of p_commit
10678: IF FND_API.TO_BOOLEAN(p_commit) THEN
10679: COMMIT WORK;
10680: END IF;
10681: -- Standard call to get message count and if count is 1, get message info
10677: -- Standard check of p_commit
10678: IF FND_API.TO_BOOLEAN(p_commit) THEN
10679: COMMIT WORK;
10680: END IF;
10681: -- Standard call to get message count and if count is 1, get message info
10682: FND_MSG_PUB.Count_And_Get
10683: ( p_count => x_msg_count,
10684: p_data => x_msg_data,
10685: p_encoded => fnd_api.g_false
11391: 'At Begin of the Procedure Unclose_Workorder'
11392: );
11393: END IF;
11394:
11395: -- Standard start of API savepoint
11396: SAVEPOINT Unclose_Workorder_PVT;
11397:
11398: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
11399:
11816:
11817: -- 1. Initialize error message stack by default
11818: FND_MSG_PUB.Initialize;
11819:
11820: -- Standard call to check for call compatibility
11821: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME)
11822: THEN
11823: retcode := 2;
11824: errbuf := FND_MSG_PUB.Get;
12570: -- Type : Private
12571: -- Description : This procedure is called for updating Work Order AOG Status.
12572: -- Pre-reqs :
12573: --
12574: -- Standard IN Parameters :
12575: -- p_api_version NUMBER := 1.0
12576: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
12577: -- p_commit VARCHAR2 := FND_API.G_FALSE
12578: --
12575: -- p_api_version NUMBER := 1.0
12576: -- p_init_msg_list VARCHAR2 := FND_API.G_FALSE
12577: -- p_commit VARCHAR2 := FND_API.G_FALSE
12578: --
12579: -- Standard OUT Parameters :
12580: -- x_return_status VARCHAR2 Required
12581: -- x_msg_count NUMBER Required
12582: -- x_msg_data VARCHAR2 Required
12583: --
12656: FND_LOG.STRING( G_LEVEL_STATEMENT, 'ahl.plsql.'||G_PKG_NAME||'.'||
12657: L_API_NAME, ' No of Workorders to be updated for AOG Status - ' || p_workorder_id_tbl.COUNT);
12658: END IF;
12659:
12660: -- Standard Start of API savepoint
12661: SAVEPOINT UPDATE_WO_AOG_STATUS;
12662:
12663: -- Initialize message list if p_init_msg_list is set to TRUE.
12664: IF FND_API.to_boolean(p_init_msg_list)
12668:
12669: -- Initialize API return status to success
12670: x_return_status := FND_API.G_RET_STS_SUCCESS;
12671:
12672: -- Standard call to check for call compatibility.
12673: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
12674: p_api_version,
12675: l_api_name,G_PKG_NAME)
12676: THEN