DBA Data[Home] [Help]

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_NONROUTINE_PVT

Line 40: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

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

Line 54: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

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

Line 64: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

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

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

109: p_lot_number IN VARCHAR2);
110:
111: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
112: -- The API update_item_location and its use has been commented out. Its functionality will
113: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
114:
115: -- SURRKUMA :: ER 9213556 Create NR for Next Higher Position, 13-DEC-2010
116: -- Now update_item_location API is needed to move the non-serialized items to SR work order created for
117: -- parent position. It will be called only when the create NR for next higher position flag is checked.

Line 792: -- p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type Required

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

Line 810: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

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

Line 966: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

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

Line 1500: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

1496: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1497: p_module_type IN VARCHAR2 := NULL,
1498: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
1499: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
1500: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
1501: x_return_status OUT NOCOPY VARCHAR2,
1502: x_msg_count OUT NOCOPY NUMBER,
1503: x_msg_data OUT NOCOPY VARCHAR2
1504: ) IS

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

2395: END IF;
2396:
2397: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2398: -- The API update_item_location and its use has been commented out. Its functionality will
2399: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
2400: /*
2401: IF (NVL(x_return_status, FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS AND
2402: p_x_disposition_rec.non_routine_workorder_id IS NOT NULL AND
2403: l_disposition_rec.part_change_id IS NULL AND

Line 2596: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,

2592: PROCEDURE CREATE_SR(
2593: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
2594: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
2595: -- Parameter added by jaramana on Oct 9, 2007 for ER 5883257
2596: p_mr_asso_tbl IN AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type,
2597: x_primary_sr_id OUT NOCOPY NUMBER,
2598: x_non_routine_workorder_id OUT NOCOPY NUMBER,
2599: x_return_status OUT NOCOPY VARCHAR2,
2600: x_msg_count OUT NOCOPY NUMBER,

Line 2645: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;

2641:
2642: l_rel_nm_wo_id NUMBER;
2643: l_move_item_ins_tbl AHL_PRD_PARTS_CHANGE_PVT.move_item_instance_tbl_type;
2644:
2645: l_sr_task_tbl AHL_PRD_NONROUTINE_PVT.sr_task_tbl_type;
2646: l_visit_id NUMBER;
2647:
2648:
2649: -- Variable added by jaramana on Oct 9, 2007 for ER 5883257

Line 2650: l_mr_asso_tbl AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type := p_mr_asso_tbl;

2646: l_visit_id NUMBER;
2647:
2648:
2649: -- Variable added by jaramana on Oct 9, 2007 for ER 5883257
2650: l_mr_asso_tbl AHL_PRD_NONROUTINE_PVT.MR_Association_tbl_type := p_mr_asso_tbl;
2651:
2652:
2653: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || 'Create_SR';
2654: l_msg_index_out NUMBER;

Line 2796: AHL_PRD_NONROUTINE_PVT.process_nonroutine_job (

2792: --Calling Service Request API--
2793: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, L_DEBUG_KEY, 'Before process_nonroutine_job');
2795: END IF;
2796: AHL_PRD_NONROUTINE_PVT.process_nonroutine_job (
2797: p_api_version => 1.0,
2798: p_commit => Fnd_Api.g_false,
2799: p_module_type => NULL,
2800: x_return_status => x_return_status,

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

2846: x_non_routine_workorder_id := l_sr_task_tbl(0).Nonroutine_wo_id;
2847:
2848: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
2849: -- The API update_item_location and its use has been commented out. Its functionality will
2850: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
2851:
2852: -- SURRKUMA :: ER 9213556 Ceate NR for next higher position flag
2853: -- The API update_item_location is needed now to move the non-serialized items to SR work order
2854: -- created for the parent position when the create NR for next higher position flag is checked.

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

5501: --------------------------------------------------------------
5502:
5503: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 12-Dec-2007
5504: -- The API update_item_location and its use has been commented out. Its functionality will
5505: -- now be handled in the API AHL_PRD_NONROUTINE_PVT.process_nonroutine_job.
5506:
5507: -- SURRKUMA :: ER 9213556 Ceate NR for next higher position flag
5508: -- The API update_item_location is needed now to move the non-serialized items to SR work order
5509: -- created for the parent position when the create NR for next higher position flag is checked.