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_COMPLETIONS_PVT dependencies on AHL_COMPLETIONS_PVT

Line 1: PACKAGE BODY AHL_COMPLETIONS_PVT AS

1: PACKAGE BODY AHL_COMPLETIONS_PVT AS
2: /* $Header: AHLVPRCB.pls 120.45.12010000.4 2009/01/09 22:28:16 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_COMPLETIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;

Line 4: G_PKG_NAME VARCHAR2(30) := 'AHL_COMPLETIONS_PVT';

1: PACKAGE BODY AHL_COMPLETIONS_PVT AS
2: /* $Header: AHLVPRCB.pls 120.45.12010000.4 2009/01/09 22:28:16 sikumar ship $ */
3:
4: G_PKG_NAME VARCHAR2(30) := 'AHL_COMPLETIONS_PVT';
5: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
6:
7: -- Operation Statuses
8: G_OP_STATUS_UNCOMPLETE VARCHAR2(2) := '2'; --Uncomplete

Line 2086: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',

2082: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2083: THEN
2084: fnd_log.string(
2085: FND_LOG.LEVEL_STATEMENT,
2086: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2087: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2088: );
2089: END IF;
2090: FOR ctr_cursor IN get_counters( p_item_instance_id )

Line 2235: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

2231: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2232: THEN
2233: fnd_log.string(
2234: FND_LOG.LEVEL_STATEMENT,
2235: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2236: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2237: );
2238: END IF;
2239:

Line 2279: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

2275: THEN
2276:
2277: fnd_log.string(
2278: FND_LOG.LEVEL_STATEMENT,
2279: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2280: 'counter with id.. -> ' || ctr_cursor.counter_id
2281: ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2282: ||', l_cur_ct_reading ->' ||l_cur_ct_reading
2283: );

Line 2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

2289: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2290: THEN
2291: fnd_log.string(
2292: FND_LOG.LEVEL_STATEMENT,
2293: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );
2296: fnd_log.string(
2297: FND_LOG.LEVEL_STATEMENT,

Line 2298: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',

2294: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2295: );
2296: fnd_log.string(
2297: FND_LOG.LEVEL_STATEMENT,
2298: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2299: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2300: );
2301: END IF;
2302:

Line 9652: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;

9648: --ORDER BY level DESC;
9649:
9650: --declare local variables here
9651: l_mr_rec get_ue_details%ROWTYPE;
9652: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
9653: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
9654: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
9655: l_workorder_operation_id NUMBER;
9656: l_object_version_no NUMBER;

Line 9653: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;

9649:
9650: --declare local variables here
9651: l_mr_rec get_ue_details%ROWTYPE;
9652: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
9653: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
9654: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
9655: l_workorder_operation_id NUMBER;
9656: l_object_version_no NUMBER;
9657: l_date_validation VARCHAR2(1);

Line 9654: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;

9650: --declare local variables here
9651: l_mr_rec get_ue_details%ROWTYPE;
9652: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
9653: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
9654: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
9655: l_workorder_operation_id NUMBER;
9656: l_object_version_no NUMBER;
9657: l_date_validation VARCHAR2(1);
9658: l_return_status VARCHAR2(1);

Line 9868: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records

9864: --# x_msg_count OUT NOCOPY NUMBER
9865: --# x_msg_data OUT NOCOPY VARCHAR2
9866: --#
9867: --# Get_Default_Op_Actual_Dates Parameters
9868: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records
9869: --#
9870: --# DESCRIPTION
9871: --# This function will be used to default the actual dates before completing operations using the
9872: --# My Workorders or Update Workorders Uis. Calling APIs need to populate only the workorder_id and

Line 9884: P_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type

9880: (
9881: x_return_status OUT NOCOPY VARCHAR2,
9882: x_msg_count OUT NOCOPY NUMBER,
9883: x_msg_data OUT NOCOPY VARCHAR2,
9884: P_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
9885: )
9886: IS
9887: L_workorder_operation_id NUMBER;
9888: L_ovn NUMBER;

Line 10040: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records

10036: --# Standard OUT Parameters
10037: --# x_return_status OUT NOCOPY VARCHAR2
10038: --#
10039: --# Get_Op_Actual_Dates Parameters
10040: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records
10041: --#
10042: --# DESCRIPTION
10043: --# This function will be used to retrieve the current actual dates of operations. This is API
10044: --# is needed for the defaulting logic of actual dates on the Operations subtab of the

Line 10055: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type

10051:
10052: PROCEDURE Get_Op_Actual_Dates
10053: (
10054: x_return_status OUT NOCOPY VARCHAR2,
10055: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
10056: )
10057: IS
10058:
10059: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table

Line 10361: AHL_COMPLETIONS_PVT.complete_workorder

10357: ELSE -- chk_cmplt_wo_exists
10358: CLOSE chk_cmplt_wo_exists;
10359:
10360: IF l_workorder_id IS NOT NULL AND l_ovn IS NOT NULL THEN
10361: AHL_COMPLETIONS_PVT.complete_workorder
10362: (
10363: p_api_version => 1.0,
10364: p_init_msg_list => FND_API.G_TRUE,
10365: p_commit => FND_API.G_FALSE,

Line 10900: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND

10896: --FL.Meaning,
10897: UE.qa_collection_id
10898: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
10899: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
10900: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
10901: UE.unit_effectivity_id = p_unit_effectivity_id
10902: AND UE.object_version_number = p_ue_object_version_no;
10903:
10904: CURSOR get_mr_status_csr(p_status_code VARCHAR2) IS

Line 10962: l_mr_rec.ue_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );

10958: OPEN visit_task_csr(l_mr_rec.unit_effectivity_id);
10959: FETCH visit_task_csr INTO l_organization_id, l_visit_task_id;
10960: CLOSE visit_task_csr;
10961:
10962: l_mr_rec.ue_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );
10963:
10964: OPEN get_mr_status_csr(l_mr_rec.ue_status_code);
10965: FETCH get_mr_status_csr INTO l_mr_rec.ue_status;
10966: CLOSE get_mr_status_csr;

Line 11034: END AHL_COMPLETIONS_PVT;

11030:
11031: END are_all_operations_complete;
11032:
11033:
11034: END AHL_COMPLETIONS_PVT;