eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_PRD_DISPOSITION_PVT

Line 1: PACKAGE BODY AHL_PRD_DISPOSITION_PVT AS

1: PACKAGE BODY AHL_PRD_DISPOSITION_PVT AS
2: /* $Header: AHLVDISB.pls 120.17.12020000.2 2012/12/14 07:52:11 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_DISPOSITION_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_DISPOSITION_PVT';

1: PACKAGE BODY AHL_PRD_DISPOSITION_PVT AS
2: /* $Header: AHLVDISB.pls 120.17.12020000.2 2012/12/14 07:52:11 shnatu ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_DISPOSITION_PVT';
5: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
6: G_LOG_PREFIX CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.';
7:
8: g_module_type VARCHAR2(30) := NULL;

Line 38: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

34: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
35: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 52: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

48: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 62: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

58: );
59:
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,

Line 77: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

73: PROCEDURE Validate_Disposition_Types (
74: x_return_status OUT NOCOPY VARCHAR2,
75: x_msg_count OUT NOCOPY NUMBER,
76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
78:
79: PROCEDURE Calculate_Status (
80: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
81: x_status_code OUT NOCOPY VARCHAR2);

Line 80: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

76: x_msg_data OUT NOCOPY VARCHAR2,
77: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
78:
79: PROCEDURE Calculate_Status (
80: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
81: x_status_code OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE convert_values_to_ids(p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
84:

Line 83: PROCEDURE convert_values_to_ids(p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

79: PROCEDURE Calculate_Status (
80: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
81: x_status_code OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE convert_values_to_ids(p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
84:
85: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
86:
87: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

Line 85: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

81: x_status_code OUT NOCOPY VARCHAR2);
82:
83: PROCEDURE convert_values_to_ids(p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
84:
85: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
86:
87: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
88:
89: PROCEDURE validate_workorder(p_workorder_id IN NUMBER);

Line 87: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

83: PROCEDURE convert_values_to_ids(p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
84:
85: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
86:
87: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type);
88:
89: PROCEDURE validate_workorder(p_workorder_id IN NUMBER);
90:
91: PROCEDURE validate_path_position(p_path_position_id IN NUMBER);

Line 790: -- p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type Required

786: -- on which the Id's are populated.
787: --
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)

Line 808: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

804: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
805: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 964: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

960: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 1498: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

1494: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1495: p_commit IN VARCHAR2 := FND_API.G_FALSE,
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,

Line 1618: -- l_disposition_rec AHL_PRD_DISPOSITION_PVT.disposition_rec_type;

1614:
1615: l_inst_in_job_flag VARCHAR2(1) := 'N';
1616:
1617: l_disposition_rec disposition_csr%ROWTYPE;
1618: -- l_disposition_rec AHL_PRD_DISPOSITION_PVT.disposition_rec_type;
1619: l_primary_service_request_id NUMBER;
1620: l_non_routine_workorder_id NUMBER;
1621: l_calculated_status VARCHAR(30);
1622: l_disposition_h_id NUMBER;

Line 2594: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

2590: ------------------------------------------------------------------
2591:
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,

Line 2952: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type)

2948: END Create_SR;
2949:
2950:
2951: --------------DERIVE_COLUMNS---------------------------------------------------
2952: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2953: IS
2954:
2955: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
2956: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi

Line 3235: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)

3231:
3232:
3233: ---------------------------LOCAL VALIDATION PROCEDURES------------------------------------
3234:
3235: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
3236: IS
3237:
3238: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
3239: SELECT 'X' FROM ahl_mc_path_positions pos

Line 3937: p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type

3933:
3934: --------------------------------------------------------------------------------
3935: PROCEDURE convert_values_to_ids
3936: (
3937: p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type
3938: ) IS
3939:
3940: CURSOR instance_id_csr(p_instance_number IN VARCHAR2) IS
3941: SELECT instance_id from csi_item_instances

Line 4613: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

4609: -- x_status_code OUT NOCOPY the output of the disposition record
4610: --
4611: -- End of Comments.
4612: PROCEDURE Calculate_Status (
4613: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
4614: x_status_code OUT NOCOPY VARCHAR2)
4615: IS
4616: --
4617: CURSOR get_disposition_csr (p_disposition_id IN NUMBER) IS

Line 4862: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)

4858: PROCEDURE Validate_Disposition_Types (
4859: x_return_status OUT NOCOPY VARCHAR2,
4860: x_msg_count OUT NOCOPY NUMBER,
4861: x_msg_data OUT NOCOPY VARCHAR2,
4862: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
4863: IS
4864: --
4865: --
4866: CURSOR check_immed_disp_types_csr (p_disp_code IN VARCHAR2)IS

Line 5660: END AHL_PRD_DISPOSITION_PVT;

5656: END IF;
5657:
5658: END update_item_location;
5659:
5660: END AHL_PRD_DISPOSITION_PVT;