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.15.12010000.2 2008/12/09 01:42:51 jaramana ship $ */
3:
4:
5:

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

2: /* $Header: AHLVDISB.pls 120.15.12010000.2 2008/12/09 01:42:51 jaramana ship $ */
3:
4:
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_PRD_DISPOSITION_PVT';
7: G_APP_NAME CONSTANT VARCHAR2(3) := 'AHL';
8: G_LOG_PREFIX CONSTANT VARCHAR2(60) := 'ahl.plsql.'||G_PKG_NAME||'.';
9:
10: g_module_type VARCHAR2(30) := NULL;

Line 40: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

Line 54: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

Line 64: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

60: );
61:
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,

Line 79: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type);

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

Line 82: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

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

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

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

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

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

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

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

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

Line 805: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

Line 961: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

Line 1338: p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

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

Line 1435: -- l_disposition_rec AHL_PRD_DISPOSITION_PVT.disposition_rec_type;

1431: WHERE part_change_id = c_part_change_id;
1432: -- SATHAPLI::Bug 7111116, 21-May-2008, fix end
1433:
1434: l_disposition_rec disposition_csr%ROWTYPE;
1435: -- l_disposition_rec AHL_PRD_DISPOSITION_PVT.disposition_rec_type;
1436: l_primary_service_request_id NUMBER;
1437: l_non_routine_workorder_id NUMBER;
1438: l_calculated_status VARCHAR(30);
1439: l_disposition_h_id NUMBER;

Line 2292: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

2288: ------------------------------------------------------------------
2289:
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,

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

2525: END Create_SR;
2526:
2527:
2528: --------------DERIVE_COLUMNS---------------------------------------------------
2529: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2530: IS
2531:
2532: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
2533: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi

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

2808:
2809:
2810: ---------------------------LOCAL VALIDATION PROCEDURES------------------------------------
2811:
2812: PROCEDURE validate_for_create(p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2813: IS
2814:
2815: CURSOR exist_position_csr(p_path_position_id IN NUMBER, p_workorder_id IN NUMBER) IS
2816: SELECT 'X' FROM ahl_mc_path_positions pos

Line 3504: p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type

3500:
3501: --------------------------------------------------------------------------------
3502: PROCEDURE convert_values_to_ids
3503: (
3504: p_x_prd_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type
3505: ) IS
3506:
3507: CURSOR instance_id_csr(p_instance_number IN VARCHAR2) IS
3508: SELECT instance_id from csi_item_instances

Line 4153: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,

4149: -- x_status_code OUT NOCOPY the output of the disposition record
4150: --
4151: -- End of Comments.
4152: PROCEDURE Calculate_Status (
4153: p_disposition_Rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type,
4154: x_status_code OUT NOCOPY VARCHAR2)
4155: IS
4156: --
4157: CURSOR get_disposition_csr (p_disposition_id IN NUMBER) IS

Line 4402: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)

4398: PROCEDURE Validate_Disposition_Types (
4399: x_return_status OUT NOCOPY VARCHAR2,
4400: x_msg_count OUT NOCOPY NUMBER,
4401: x_msg_data OUT NOCOPY VARCHAR2,
4402: p_disposition_rec IN AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
4403: IS
4404: --
4405: --
4406: CURSOR check_immed_disp_types_csr (p_disp_code IN VARCHAR2)IS

Line 5197: END AHL_PRD_DISPOSITION_PVT;

5193:
5194: END update_item_location;
5195: */
5196:
5197: END AHL_PRD_DISPOSITION_PVT;