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.71.12020000.5 2013/03/26 06:29:58 sosahni 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.71.12020000.5 2013/03/26 06:29:58 sosahni 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 2164: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',

2160: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2161: THEN
2162: fnd_log.string(
2163: FND_LOG.LEVEL_STATEMENT,
2164: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_cp_counters',
2165: 'l_wo_actual_date in get_cp_counters -> ' || TO_CHAR(l_wo_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2166: );
2167: END IF;
2168: FOR ctr_cursor IN get_counters( p_item_instance_id )

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

2309: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2310: THEN
2311: fnd_log.string(
2312: FND_LOG.LEVEL_STATEMENT,
2313: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2314: 'p_actual_date in get_reset_counters -> ' || TO_CHAR(p_actual_date, 'DD-MON-YYYY HH24:MI:SS')
2315: );
2316: END IF;
2317:

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

2355: THEN
2356:
2357: fnd_log.string(
2358: FND_LOG.LEVEL_STATEMENT,
2359: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2360: 'counter with id.. -> ' || ctr_cursor.counter_id
2361: ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2362: ||', l_cur_ct_reading ->' ||l_cur_ct_reading
2363: );

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

2369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2370: THEN
2371: fnd_log.string(
2372: FND_LOG.LEVEL_STATEMENT,
2373: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );
2376: fnd_log.string(
2377: FND_LOG.LEVEL_STATEMENT,

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

2374: 'Resetting counter with id.. -> ' || ctr_cursor.counter_id
2375: );
2376: fnd_log.string(
2377: FND_LOG.LEVEL_STATEMENT,
2378: 'ahl.plsql.AHL_COMPLETIONS_PVT.get_reset_counters',
2379: 'counter with id.. -> ' || ctr_cursor.counter_id ||', l_actual_ct_reading ->' ||l_actual_ct_reading
2380: );
2381: END IF;
2382:

Line 10437: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;

10433: --ORDER BY level DESC;
10434:
10435: --declare local variables here
10436: l_mr_rec get_ue_details%ROWTYPE;
10437: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
10438: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
10439: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
10440: l_workorder_operation_id NUMBER;
10441: l_object_version_no NUMBER;

Line 10438: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;

10434:
10435: --declare local variables here
10436: l_mr_rec get_ue_details%ROWTYPE;
10437: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
10438: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
10439: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
10440: l_workorder_operation_id NUMBER;
10441: l_object_version_no NUMBER;
10442: l_date_validation VARCHAR2(1);

Line 10439: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;

10435: --declare local variables here
10436: l_mr_rec get_ue_details%ROWTYPE;
10437: l_workorder_rec AHL_COMPLETIONS_PVT.workorder_rec_type;
10438: l_operation_tbl AHL_COMPLETIONS_PVT.operation_tbl_type;
10439: l_operation_rec AHL_COMPLETIONS_PVT.operation_rec_type;
10440: l_workorder_operation_id NUMBER;
10441: l_object_version_no NUMBER;
10442: l_date_validation VARCHAR2(1);
10443: l_return_status VARCHAR2(1);

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

10649: --# x_msg_count OUT NOCOPY NUMBER
10650: --# x_msg_data OUT NOCOPY VARCHAR2
10651: --#
10652: --# Get_Default_Op_Actual_Dates Parameters
10653: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records
10654: --#
10655: --# DESCRIPTION
10656: --# This function will be used to default the actual dates before completing operations using the
10657: --# My Workorders or Update Workorders Uis. Calling APIs need to populate only the workorder_id and

Line 10669: P_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type

10665: (
10666: x_return_status OUT NOCOPY VARCHAR2,
10667: x_msg_count OUT NOCOPY NUMBER,
10668: x_msg_data OUT NOCOPY VARCHAR2,
10669: P_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
10670: )
10671: IS
10672: L_workorder_operation_id NUMBER;
10673: L_ovn NUMBER;

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

10839: --# Standard OUT Parameters
10840: --# x_return_status OUT NOCOPY VARCHAR2
10841: --#
10842: --# Get_Op_Actual_Dates Parameters
10843: --# P_x_operation_tbl IN AHL_COMPLETIONS_PVT.operation_tbl_type - Table holding the operation records
10844: --#
10845: --# DESCRIPTION
10846: --# This function will be used to retrieve the current actual dates of operations. This is API
10847: --# is needed for the defaulting logic of actual dates on the Operations subtab of the

Line 10858: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type

10854:
10855: PROCEDURE Get_Op_Actual_Dates
10856: (
10857: x_return_status OUT NOCOPY VARCHAR2,
10858: p_x_operation_tbl IN OUT NOCOPY AHL_COMPLETIONS_PVT.operation_tbl_type
10859: )
10860: IS
10861:
10862: -- cursor to retrieve the relevant operation details from AHL_WORKORDER_OPERATIONS table

Line 11188: AHL_COMPLETIONS_PVT.complete_workorder

11184: ELSE -- chk_cmplt_wo_exists
11185: CLOSE chk_cmplt_wo_exists;
11186:
11187: IF l_workorder_id IS NOT NULL AND l_ovn IS NOT NULL THEN
11188: AHL_COMPLETIONS_PVT.complete_workorder
11189: (
11190: p_api_version => 1.0,
11191: p_init_msg_list => FND_API.G_TRUE,
11192: p_commit => FND_API.G_FALSE,

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

11751: --FL.Meaning,
11752: UE.qa_collection_id
11753: from ahl_unit_effectivities_b UE--, FND_LOOKUP_VALUES_VL FL
11754: where --FL.Lookup_type = 'AHL_PRD_MR_STATUS'
11755: --AND FL.Lookup_code = AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id ) AND
11756: UE.unit_effectivity_id = p_unit_effectivity_id
11757: AND UE.object_version_number = p_ue_object_version_no;
11758:
11759: CURSOR get_mr_status_csr(p_status_code VARCHAR2) IS

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

11813: OPEN visit_task_csr(l_mr_rec.unit_effectivity_id);
11814: FETCH visit_task_csr INTO l_organization_id, l_visit_task_id;
11815: CLOSE visit_task_csr;
11816:
11817: l_mr_rec.ue_status_code := AHL_COMPLETIONS_PVT.get_mr_status( p_unit_effectivity_id );
11818:
11819: OPEN get_mr_status_csr(l_mr_rec.ue_status_code);
11820: FETCH get_mr_status_csr INTO l_mr_rec.ue_status;
11821: CLOSE get_mr_status_csr;

Line 12753: END AHL_COMPLETIONS_PVT;

12749:
12750: END Is_Signoff_Update_User;
12751:
12752:
12753: END AHL_COMPLETIONS_PVT;