DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_NONROUTINE_PVT

Line 42: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

38: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
39: p_module_type IN VARCHAR2 := NULL,
40: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
41: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
42: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
43: x_return_status OUT NOCOPY VARCHAR2,
44: x_msg_count OUT NOCOPY NUMBER,
45: x_msg_data OUT NOCOPY VARCHAR2
46: );

Line 56: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

52: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
53: p_module_type IN VARCHAR2 := NULL,
54: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
55: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
56: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
57: x_return_status OUT NOCOPY VARCHAR2,
58: x_msg_count OUT NOCOPY NUMBER,
59: x_msg_data OUT NOCOPY VARCHAR2
60: );

Line 66: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

62: PROCEDURE CREATE_SR(
63: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
64: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
65: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
66: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
67: x_primary_sr_id OUT NOCOPY NUMBER,
68: x_non_routine_workorder_id OUT NOCOPY NUMBER,
69: x_return_status OUT NOCOPY VARCHAR2,
70: x_msg_count OUT NOCOPY NUMBER,

Line 115: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.

111: p_lot_number IN VARCHAR2);
112:
113: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
114: -- The API update_item_location and its use has been commented out. Its functionality will
115: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
116: /*
117: -- Following Procedure and Function added by jaramana on October 8, 2007 for ER 5903256
118: PROCEDURE update_item_location(p_workorder_id IN NUMBER,
119: p_instance_id IN NUMBER,

Line 789: -- p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type Required

785: -- process_disposition Parameters:
786: --
787: -- p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type Required
788: -- Disposition record
789: -- p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type Required
790: -- Table of MRs associated to the Disposition's Primary NR
791: -- (Parameter added by jaramana on Oct 9, 2007 for ER 5883257)
792: --
793: -- Version :

Line 807: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

803: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
804: p_module_type IN VARCHAR2 := NULL,
805: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
806: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
807: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
808: x_return_status OUT NOCOPY VARCHAR2,
809: x_msg_count OUT NOCOPY NUMBER,
810: x_msg_data OUT NOCOPY VARCHAR2) IS
811:

Line 963: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

959: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
960: p_module_type IN VARCHAR2 := NULL,
961: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
962: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
963: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
964: x_return_status OUT NOCOPY VARCHAR2,
965: x_msg_count OUT NOCOPY NUMBER,
966: x_msg_data OUT NOCOPY VARCHAR2
967: ) IS

Line 1340: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

1336: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1337: p_module_type IN VARCHAR2 := NULL,
1338: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
1339: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
1340: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
1341: x_return_status OUT NOCOPY VARCHAR2,
1342: x_msg_count OUT NOCOPY NUMBER,
1343: x_msg_data OUT NOCOPY VARCHAR2
1344: ) IS

Line 2143: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.

2139: END IF;
2140:
2141: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2142: -- The API update_item_location and its use has been commented out. Its functionality will
2143: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
2144: /*
2145: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2146: p_x_disposition_rec.non_routine_workorder_id IS NOT NULL AND
2147: l_disposition_rec.part_change_id IS NULL AND

Line 2294: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

2290: PROCEDURE CREATE_SR(
2291: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2292: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
2293: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
2294: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
2295: x_primary_sr_id OUT NOCOPY NUMBER,
2296: x_non_routine_workorder_id OUT NOCOPY NUMBER,
2297: x_return_status OUT NOCOPY VARCHAR2,
2298: x_msg_count OUT NOCOPY NUMBER,

Line 2316: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;

2312: WHERE awo.wip_entity_id = csi.wip_job_id
2313: AND awo.workorder_id = p_workorder_id
2314: AND csi.instance_id = p_instance_id;
2315:
2316: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;
2317: l_visit_id NUMBER;
2318:
2319: -- Variable added by jaramana on Oct 9, 2007 for ER 5883257
2320: l_mr_asso_tbl AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type := p_mr_asso_tbl;

Line 2320: l_mr_asso_tbl AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type := p_mr_asso_tbl;

2316: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;
2317: l_visit_id NUMBER;
2318:
2319: -- Variable added by jaramana on Oct 9, 2007 for ER 5883257
2320: l_mr_asso_tbl AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type := p_mr_asso_tbl;
2321:
2322:
2323: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || 'Create_SR';
2324: l_msg_index_out NUMBER;

Line 2439: AHL_PRD_NONROUTINE_PVT.process_nonroutine_job (

2435: --Calling Service Request API--
2436: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2437: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before process_nonroutine_job');
2438: END IF;
2439: AHL_PRD_NONROUTINE_PVT.process_nonroutine_job (
2440: p_api_version => 1.0,
2441: p_commit => Fnd_Api.g_false,
2442: p_module_type => NULL,
2443: x_return_status => x_return_status,

Line 2493: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.

2489: x_non_routine_workorder_id := l_sr_task_tbl(0).Nonroutine_wo_id;
2490:
2491: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2492: -- The API update_item_location and its use has been commented out. Its functionality will
2493: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
2494: /*
2495: -- Added by jaramana on October 8, 2007 for ER 5903256
2496: -- Automatically change the location of the removed unserviceable instance to the Non Routine Work Order
2497: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 5045: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.

5041: --------------------------------------------------------------
5042:
5043: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
5044: -- The API update_item_location and its use has been commented out. Its functionality will
5045: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
5046: /*
5047: -- Procedure added by jaramana on February 14, 2007 for ER 5854667
5048: -- This procedure sets the instannce's location as the WIP Job passed in as parameter.
5049: PROCEDURE update_item_location(p_workorder_id IN NUMBER,