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_UMP_UNITMAINT_PVT dependencies on AHL_UMP_UNITMAINT_PVT

Line 1: PACKAGE BODY AHL_UMP_UNITMAINT_PVT AS

1: PACKAGE BODY AHL_UMP_UNITMAINT_PVT AS
2: /* $Header: AHLVUMXB.pls 120.35.12020000.4 2013/04/01 02:42:17 sracha ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_UnitMaint_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_UnitMaint_PVT';

1: PACKAGE BODY AHL_UMP_UNITMAINT_PVT AS
2: /* $Header: AHLVUMXB.pls 120.35.12020000.4 2013/04/01 02:42:17 sracha ship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AHL_UMP_UnitMaint_PVT';
6:
7: G_DEBUG VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
8:
9: TYPE CounterCurTyp is REF CURSOR;

Line 17: p_x_unit_threshold_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_rec_type,

13: -- Declare Local Procedures --
14: -------------------------------
15: -- Converts Value to Id for a Threshold
16: PROCEDURE Convert_Threshold_Val_To_ID(
17: p_x_unit_threshold_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_rec_type,
18: x_return_status OUT NOCOPY VARCHAR2);
19:
20: -- Converts Value to Id for an Accomplishment
21: PROCEDURE Convert_Accomplish_Val_To_ID(

Line 22: p_x_unit_accomplish_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_rec_type,

18: x_return_status OUT NOCOPY VARCHAR2);
19:
20: -- Converts Value to Id for an Accomplishment
21: PROCEDURE Convert_Accomplish_Val_To_ID(
22: p_x_unit_accomplish_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_rec_type,
23: x_return_status OUT NOCOPY VARCHAR2);
24:
25: -- Converts Value to Id for an Unit Effectivity
26: PROCEDURE Convert_Effectivity_Val_To_ID(

Line 27: p_x_unit_Effectivity_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

23: x_return_status OUT NOCOPY VARCHAR2);
24:
25: -- Converts Value to Id for an Unit Effectivity
26: PROCEDURE Convert_Effectivity_Val_To_ID(
27: p_x_unit_Effectivity_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
28: x_return_status OUT NOCOPY VARCHAR2);
29:
30: -- Validates an Unit Effectivity
31: PROCEDURE Validate_Effectivity(

Line 32: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

28: x_return_status OUT NOCOPY VARCHAR2);
29:
30: -- Validates an Unit Effectivity
31: PROCEDURE Validate_Effectivity(
32: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
33: p_authorized_user_flag IN VARCHAR2 := 'N',
34: x_return_status IN OUT NOCOPY VARCHAR2);
35:
36: -- Validates Thresholds

Line 38: p_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

34: x_return_status IN OUT NOCOPY VARCHAR2);
35:
36: -- Validates Thresholds
37: PROCEDURE Validate_Thresholds(
38: p_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
39: x_return_status IN OUT NOCOPY VARCHAR2);
40:
41: -- Validates Accomplishments
42: -- Added accomplishment date to fix bug# 6750836.

Line 44: p_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

40:
41: -- Validates Accomplishments
42: -- Added accomplishment date to fix bug# 6750836.
43: PROCEDURE Validate_Accomplishments(
44: p_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
45: p_accomplishment_date IN DATE,
46: p_ue_status_code IN VARCHAR2,
47: x_return_status IN OUT NOCOPY VARCHAR2);
48:

Line 51: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);

47: x_return_status IN OUT NOCOPY VARCHAR2);
48:
49: -- Updates a Unit Effectivity
50: PROCEDURE Update_Unit_Effectivity(
51: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);
52:
53: -- Terminates a descendent Unit Effectivity
54: PROCEDURE Terminate_Descendent(
55: p_descendent_ue_id IN NUMBER);

Line 59: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

55: p_descendent_ue_id IN NUMBER);
56:
57: -- Updates Thresholds
58: PROCEDURE Update_Thresholds(
59: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
60: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);
61:
62: -- Updates Accomplishments
63: -- Added p_unit_Effectivity_rec for R12: for counter lock

Line 60: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);

56:
57: -- Updates Thresholds
58: PROCEDURE Update_Thresholds(
59: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
60: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);
61:
62: -- Updates Accomplishments
63: -- Added p_unit_Effectivity_rec for R12: for counter lock
64: PROCEDURE Update_Accomplishments(

Line 65: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

61:
62: -- Updates Accomplishments
63: -- Added p_unit_Effectivity_rec for R12: for counter lock
64: PROCEDURE Update_Accomplishments(
65: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
66: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);
67:
68: -- Copies updated Thresholds from a sublist back to the original master list
69: PROCEDURE Restore_Thresholds(

Line 66: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);

62: -- Updates Accomplishments
63: -- Added p_unit_Effectivity_rec for R12: for counter lock
64: PROCEDURE Update_Accomplishments(
65: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
66: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);
67:
68: -- Copies updated Thresholds from a sublist back to the original master list
69: PROCEDURE Restore_Thresholds(
70: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

Line 70: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

66: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type);
67:
68: -- Copies updated Thresholds from a sublist back to the original master list
69: PROCEDURE Restore_Thresholds(
70: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
71: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);
72:
73: -- Copies updated Accomplishments from a sublist back to the original master list
74: PROCEDURE Restore_Accomplishments(

Line 71: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);

67:
68: -- Copies updated Thresholds from a sublist back to the original master list
69: PROCEDURE Restore_Thresholds(
70: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
71: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);
72:
73: -- Copies updated Accomplishments from a sublist back to the original master list
74: PROCEDURE Restore_Accomplishments(
75: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

Line 75: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

71: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type);
72:
73: -- Copies updated Accomplishments from a sublist back to the original master list
74: PROCEDURE Restore_Accomplishments(
75: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
76: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type);
77:
78: -- Calls FMP API to match counters before accomplishments and terminations
79: PROCEDURE Match_Counters_with_FMP(

Line 76: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type);

72:
73: -- Copies updated Accomplishments from a sublist back to the original master list
74: PROCEDURE Restore_Accomplishments(
75: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
76: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type);
77:
78: -- Calls FMP API to match counters before accomplishments and terminations
79: PROCEDURE Match_Counters_with_FMP(
80: p_unit_effectivity_id IN NUMBER,

Line 704: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,

700: p_commit IN VARCHAR2 := FND_API.G_FALSE,
701: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
702: p_default IN VARCHAR2 := FND_API.G_TRUE,
703: p_module_type IN VARCHAR2 := NULL,
704: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
705: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
706: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,

Line 705: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

701: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
702: p_default IN VARCHAR2 := FND_API.G_TRUE,
703: p_module_type IN VARCHAR2 := NULL,
704: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
705: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
706: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,
709: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 706: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

702: p_default IN VARCHAR2 := FND_API.G_TRUE,
703: p_module_type IN VARCHAR2 := NULL,
704: p_unit_Effectivity_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_tbl_type,
705: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
706: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
707: x_return_status OUT NOCOPY VARCHAR2,
708: x_msg_count OUT NOCOPY NUMBER,
709: x_msg_data OUT NOCOPY VARCHAR2) IS
710:

Line 713: l_unit_Effectivity_rec AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type;

709: x_msg_data OUT NOCOPY VARCHAR2) IS
710:
711: l_api_version CONSTANT NUMBER := 1.5;
712: l_api_name CONSTANT VARCHAR2(30) := 'Capture_MR_Updates';
713: l_unit_Effectivity_rec AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type;
714: l_unit_threshold_tbl AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type;
715: l_unit_accomplish_tbl AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type;
716: l_MR_Initialization_flag VARCHAR2(1) := 'N';
717: l_prev_status VARCHAR2(30);

Line 714: l_unit_threshold_tbl AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type;

710:
711: l_api_version CONSTANT NUMBER := 1.5;
712: l_api_name CONSTANT VARCHAR2(30) := 'Capture_MR_Updates';
713: l_unit_Effectivity_rec AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type;
714: l_unit_threshold_tbl AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type;
715: l_unit_accomplish_tbl AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type;
716: l_MR_Initialization_flag VARCHAR2(1) := 'N';
717: l_prev_status VARCHAR2(30);
718: l_prev_object_version_no NUMBER;

Line 715: l_unit_accomplish_tbl AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type;

711: l_api_version CONSTANT NUMBER := 1.5;
712: l_api_name CONSTANT VARCHAR2(30) := 'Capture_MR_Updates';
713: l_unit_Effectivity_rec AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type;
714: l_unit_threshold_tbl AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type;
715: l_unit_accomplish_tbl AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type;
716: l_MR_Initialization_flag VARCHAR2(1) := 'N';
717: l_prev_status VARCHAR2(30);
718: l_prev_object_version_no NUMBER;
719: l_counter_index BINARY_INTEGER := 0;

Line 1219: p_x_unit_Effectivity_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

1215: -- Local Procedure Definitions follow --
1216: ----------------------------------------
1217:
1218: PROCEDURE Convert_Effectivity_Val_To_ID(
1219: p_x_unit_Effectivity_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
1220: x_return_status OUT NOCOPY VARCHAR2 ) IS
1221:
1222: CURSOR l_get_mr_id_csr(p_mr_title IN VARCHAR2,
1223: p_mr_version_number IN NUMBER) IS

Line 1310: p_x_unit_threshold_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_Rec_Type,

1306:
1307: ------------------------------------
1308:
1309: PROCEDURE Convert_Threshold_Val_To_ID(
1310: p_x_unit_threshold_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_Rec_Type,
1311: x_return_status OUT NOCOPY VARCHAR2 ) IS
1312:
1313: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1314: p_ue_id IN NUMBER) IS

Line 1382: p_x_unit_accomplish_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_rec_type,

1378:
1379: ------------------------------------
1380:
1381: PROCEDURE Convert_Accomplish_Val_To_ID(
1382: p_x_unit_accomplish_rec IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_rec_type,
1383: x_return_status OUT NOCOPY VARCHAR2 ) IS
1384:
1385: CURSOR l_get_counter_id(p_counter_name IN VARCHAR2,
1386: p_ue_id IN NUMBER) IS

Line 1451: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

1447: -----------------------------
1448:
1449: PROCEDURE Validate_Effectivity
1450: (
1451: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
1452: p_authorized_user_flag IN VARCHAR2 := 'N',
1453: x_return_status IN OUT NOCOPY VARCHAR2) IS
1454:
1455: CURSOR l_invalid_descendents_csr(p_ue_id IN NUMBER) IS

Line 2017: p_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

2013: ------------------------------------
2014:
2015: PROCEDURE Validate_Thresholds
2016: (
2017: p_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
2018: x_return_status IN OUT NOCOPY VARCHAR2) IS
2019:
2020: CURSOR l_validate_counter_csr(p_ue_id IN NUMBER,
2021: p_counter_id IN NUMBER) IS

Line 2210: p_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

2206:
2207: -- Added accomplishment date to fix bug# 6750836.
2208: PROCEDURE Validate_Accomplishments
2209: (
2210: p_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
2211: p_accomplishment_date IN DATE,
2212: p_ue_status_code IN VARCHAR2,
2213: x_return_status IN OUT NOCOPY VARCHAR2) IS
2214:

Line 2504: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS

2500: ------------------------------------
2501:
2502: PROCEDURE Update_Unit_Effectivity
2503: (
2504: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
2505:
2506: CURSOR l_threshold_exists_csr(p_ue_id IN NUMBER) IS
2507: SELECT 'x'
2508: FROM AHL_UNIT_THRESHOLDS UTH, AHL_UNIT_DEFERRALS_B UDF

Line 3220: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,

3216: -- the insert_row, update_row or delete_row methods
3217: -- of the Thresholds table handler
3218: ------------------------------------
3219: PROCEDURE Update_Thresholds(
3220: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
3221: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS
3222:
3223: CURSOR l_get_unit_threshold_csr(p_threshold_id IN NUMBER) IS
3224: SELECT OBJECT_VERSION_NUMBER,

Line 3221: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS

3217: -- of the Thresholds table handler
3218: ------------------------------------
3219: PROCEDURE Update_Thresholds(
3220: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type,
3221: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS
3222:
3223: CURSOR l_get_unit_threshold_csr(p_threshold_id IN NUMBER) IS
3224: SELECT OBJECT_VERSION_NUMBER,
3225: --UNIT_EFFECTIVITY_ID,

Line 3560: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

3556: -- the insert_row, update_row or delete_row methods
3557: -- of the Accomplishments table handler
3558: ------------------------------------
3559: PROCEDURE Update_Accomplishments(
3560: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
3561: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
3562:
3563: CURSOR l_get_unit_accomplish_csr(p_accomplish_id IN NUMBER) IS
3564: SELECT OBJECT_VERSION_NUMBER,

Line 3561: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS

3557: -- of the Accomplishments table handler
3558: ------------------------------------
3559: PROCEDURE Update_Accomplishments(
3560: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
3561: p_unit_Effectivity_rec IN AHL_UMP_UNITMAINT_PVT.Unit_Effectivity_rec_type) IS
3562:
3563: CURSOR l_get_unit_accomplish_csr(p_accomplish_id IN NUMBER) IS
3564: SELECT OBJECT_VERSION_NUMBER,
3565: UNIT_EFFECTIVITY_ID,

Line 3876: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,

3872: -- This procedure transfers data to the master
3873: -- table from the sub list
3874: ------------------------------------
3875: PROCEDURE Restore_Thresholds(
3876: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
3877: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS
3878: l_index NUMBER;
3879: l_curr_ue_id NUMBER;
3880: BEGIN

Line 3877: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS

3873: -- table from the sub list
3874: ------------------------------------
3875: PROCEDURE Restore_Thresholds(
3876: p_x_unit_threshold_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type,
3877: p_unit_threshold_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Threshold_tbl_type) IS
3878: l_index NUMBER;
3879: l_curr_ue_id NUMBER;
3880: BEGIN
3881: IF (p_unit_threshold_tbl.COUNT > 0) THEN

Line 3898: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,

3894: -- This procedure transfers data to the master
3895: -- table from the sub list
3896: ------------------------------------
3897: PROCEDURE Restore_Accomplishments(
3898: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
3899: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type) IS
3900: l_index NUMBER;
3901: l_curr_ue_id NUMBER;
3902: BEGIN

Line 3899: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type) IS

3895: -- table from the sub list
3896: ------------------------------------
3897: PROCEDURE Restore_Accomplishments(
3898: p_x_unit_accomplish_tbl IN OUT NOCOPY AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type,
3899: p_unit_accomplish_tbl IN AHL_UMP_UNITMAINT_PVT.Unit_Accomplish_tbl_type) IS
3900: l_index NUMBER;
3901: l_curr_ue_id NUMBER;
3902: BEGIN
3903: IF (p_unit_accomplish_tbl.COUNT > 0) THEN

Line 5078: AHL_UMP_UNITMAINT_PVT.Build_UnitEffectivity (

5074: END IF;
5075:
5076: /* commented call from here as BUE api commits. Launching concurrent program instead.
5077: IF (l_new_mr_header_id IS NOT NULL AND trunc(l_effective_from_date) <= trunc(sysdate)) THEN
5078: AHL_UMP_UNITMAINT_PVT.Build_UnitEffectivity (
5079: p_init_msg_list => FND_API.G_FALSE,
5080: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
5081: p_default => FND_API.G_TRUE,
5082: p_module_type => NULL,

Line 6190: END AHL_UMP_UNITMAINT_PVT;

6186: fnd_file.put_line(fnd_file.log, 'End of processing Terminated Maintenance Requirements..');
6187:
6188: END process_terminated_MRs;
6189:
6190: END AHL_UMP_UNITMAINT_PVT;