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_PROCESSUNIT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_B

Line 377: -- from ahl_unit_effectivities_b.

373: x_contract_found_flag OUT NOCOPY BOOLEAN);
374:
375: -- After creation of all maintenance requirements for the instance in the temporary table,
376: -- assign unit effectivity IDs from existing un-accomplished maintenance requirements
377: -- from ahl_unit_effectivities_b.
378: PROCEDURE Assign_Unit_effectivity_IDs;
379:
380: -- Fix for Prev. Maint. performance bug# 5093064.
381: -- instead of calling procedure AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS,

Line 2500: FROM AHL_UNIT_EFFECTIVITIES_B UE, II

2496: AND TRUNC(NVL(ACTIVE_END_DATE, SYSDATE+1))
2497: )
2498: SELECT 1
2499: --FROM AHL_UNIT_EFFECTIVITIES_APP_V UE, II
2500: FROM AHL_UNIT_EFFECTIVITIES_B UE, II
2501: WHERE UE.csi_item_instance_id = II.INSTANCE_ID
2502: AND UE.application_usg_code = p_appln_usg_code
2503: AND (status_code IS NULL OR status_code IN ('INIT-DUE','EXCEPTION'))
2504: FOR UPDATE OF status_code NOWAIT;

Line 3184: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr1, ahl_mr_headers_b mr2

3180: -- check for existence of old MR revision
3181: CURSOR check_old_mr_ver (p_csi_instance_id IN NUMBER,
3182: p_mr_header_id IN NUMBER) IS
3183: SELECT 'x'
3184: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr1, ahl_mr_headers_b mr2
3185: WHERE mr2.mr_header_id = p_mr_header_id
3186: and mr1.title = mr2.title
3187: and mr1.version_number <> mr2.version_number
3188: and mr1.mr_header_id = ue.mr_header_id

Line 3402: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE

3398: AND (UE.Status_code IS NULL OR status_code = 'INIT-DUE')
3399: AND UE.defer_from_ue_id IS NULL -- do not pick deferred unit effectivities.
3400: AND nvl(UE.manually_planned_flag,'N') = 'N' -- do not pick manually planned UEs.
3401: -- do not pick up child UEs if parent init-accomplished.
3402: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE
3403: WHERE PARENT_UE.UNIT_EFFECTIVITY_ID = RELN.ORIGINATOR_UE_ID
3404: AND PARENT_UE.STATUS_CODE = 'INIT-ACCOMPLISHED')
3405: ORDER BY forecast_sequence ASC;
3406: */

Line 3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,

3410: p_csi_item_instance_id IN NUMBER,
3411: p_appln_usg_code IN VARCHAR2) IS
3412: SELECT ue.unit_effectivity_id, ue.status_code, reln.related_ue_id, reln.originator_ue_id, ue.mr_header_id
3413: --FROM ahl_unit_effectivities_app_v UE, ahl_UE_relationships reln,
3414: FROM ahl_unit_effectivities_b UE, ahl_UE_relationships reln,
3415: ahl_mr_headers_b mr
3416: WHERE UE.unit_effectivity_id = RELN.RELATED_UE_ID(+)
3417: AND UE.mr_header_id = mr.mr_header_id
3418: AND mr.mr_header_id IN (select mr1.mr_header_id from ahl_mr_headers_b mr1 where mr1.title = p_title)

Line 3425: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE

3421: AND (UE.Status_code IS NULL OR UE.status_code = 'INIT-DUE')
3422: AND UE.defer_from_ue_id IS NULL -- do not pick deferred unit effectivities.
3423: AND nvl(UE.manually_planned_flag,'N') = 'N' -- do not pick manually planned UEs.
3424: -- do not pick up child UEs if parent init-accomplished.
3425: AND NOT EXISTS (SELECT 'x' FROM AHL_UNIT_EFFECTIVITIES_B PARENT_UE
3426: WHERE PARENT_UE.UNIT_EFFECTIVITY_ID = RELN.ORIGINATOR_UE_ID
3427: AND PARENT_UE.STATUS_CODE = 'INIT-ACCOMPLISHED')
3428: ORDER BY mr.version_number ASC, forecast_sequence ASC ;
3429:

Line 3570: FROM ahl_unit_effectivities_b ue

3566: p_title IN VARCHAR2,
3567: p_appln_usg_code IN VARCHAR2) IS
3568: SELECT ue.unit_effectivity_id
3569: --FROM ahl_unit_effectivities_app_v ue
3570: FROM ahl_unit_effectivities_b ue
3571: WHERE ue.csi_item_instance_id = p_item_instance_id
3572: AND ue.application_usg_code = p_appln_usg_code
3573: AND ue.mr_header_id IN (select amh.mr_header_id from ahl_mr_headers_b amh where amh.title = p_title)
3574: AND ue.status_code IS NULL

Line 3577: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

3573: AND ue.mr_header_id IN (select amh.mr_header_id from ahl_mr_headers_b amh where amh.title = p_title)
3574: AND ue.status_code IS NULL
3575: AND ue.manually_planned_flag = 'Y'
3576: AND NOT EXISTS (SELECT 'x'
3577: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
3578: WHERE uer.related_ue_id = ue.unit_effectivity_id
3579: AND uer.originator_ue_id = ue1.unit_effectivity_id
3580: AND ue1.object_type = 'SR');
3581: -- Do not pick MRs associated to a SR.

Line 4655: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b ud

4651: CURSOR ahl_init_due_csr (p_csi_item_instance_id IN NUMBER,
4652: p_title IN VARCHAR2) IS
4653: SELECT ud.set_due_date, ue.unit_effectivity_id, ud.unit_deferral_id
4654: --FROM ahl_unit_effectivities_app_v ue, ahl_unit_deferrals_vl ud
4655: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b ud
4656: WHERE ue.unit_effectivity_id = ud.unit_effectivity_id AND
4657: ud.unit_deferral_type = 'INIT-DUE' AND
4658: ue.csi_item_instance_id = p_csi_item_instance_id AND
4659: ue.mr_header_id IN (select mr_header_id from ahl_mr_headers_b mr where mr.title = p_title) AND

Line 7432: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

7428: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
7429: ue2.mr_header_id related_mr_header_id,
7430: ue2.csi_item_instance_id related_csi_item_instance_id
7431: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
7432: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
7433: WHERE ue1.unit_effectivity_id = p_ue_id AND
7434: ue2.unit_effectivity_id = p_related_ue_id;
7435:
7436: -- To check if mr has a preceding mr.

Line 8672: FROM ahl_unit_effectivities_b

8668: CURSOR ahl_due_date_csr(p_accomplishment_date IN DATE,
8669: p_mr_header_id IN NUMBER,
8670: p_csi_item_instance_id IN NUMBER) IS
8671: SELECT due_date
8672: FROM ahl_unit_effectivities_b
8673: WHERE mr_header_id = p_mr_header_id
8674: AND csi_item_instance_id = p_csi_item_instance_id
8675: AND trunc(accomplished_date) = trunc(p_accomplishment_date)
8676: AND status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')

Line 8689: FROM ahl_unit_effectivities_b

8685: p_mr_header_id IN NUMBER,
8686: p_csi_item_instance_id IN NUMBER,
8687: p_service_line_id IN NUMBER) IS
8688: SELECT due_date, accomplished_date
8689: FROM ahl_unit_effectivities_b
8690: WHERE mr_header_id = p_mr_header_id
8691: AND csi_item_instance_id = p_csi_item_instance_id
8692: AND service_line_id = p_service_line_id
8693: --AND trunc(accomplished_date) = trunc(p_accomplishment_date)

Line 9461: -- belonging to the same instance from ahl_unit_effectivities_b.

9457:
9458: -------------------------------------------------------------
9459: -- After creation of all maintenance requirements for the instance in the temporary table,
9460: -- assign unit effectivity IDs from existing un-accomplished maintenance requirements
9461: -- belonging to the same instance from ahl_unit_effectivities_b.
9462: PROCEDURE Assign_Unit_Effectivity_IDs IS
9463:
9464: -- Added service_line_id to fix FP bug# 5481605.
9465: -- read temporary table sequentially.

Line 9476: FROM ahl_unit_effectivities_b UE

9472: p_mr_header_id IN NUMBER,
9473: p_service_line_id IN NUMBER,
9474: p_appl_usg_code IN VARCHAR2) IS
9475: SELECT ue.unit_effectivity_id
9476: FROM ahl_unit_effectivities_b UE
9477: WHERE mr_header_id = p_mr_header_id
9478: AND csi_item_instance_id = p_csi_item_instance_id
9479: AND application_usg_code = p_appl_usg_code
9480: AND service_line_id = p_service_line_id

Line 9499: l_appl_usg_code ahl_unit_effectivities_b.application_usg_code%TYPE;

9495:
9496: l_unit_effectivity_id NUMBER;
9497:
9498: l_ue_id_tbl nbr_tbl_type;
9499: l_appl_usg_code ahl_unit_effectivities_b.application_usg_code%TYPE;
9500:
9501: BEGIN
9502:
9503: IF G_DEBUG = 'Y' THEN

Line 10066: FROM ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR

10062: nvl(MR.whichever_first_code, 'FIRST') whichever_first_code,
10063: UDF.unit_deferral_type, UE.CS_INCIDENT_ID, UDF.DEFERRAL_EFFECTIVE_ON,
10064: UDF.AFFECT_DUE_CALC_FLAG, UDF.SET_DUE_DATE, UDF.unit_deferral_id,
10065: MR.title
10066: FROM ahl_unit_effectivities_b UE, ahl_unit_deferrals_b UDF, ahl_mr_headers_b MR
10067: WHERE UE.defer_from_ue_id = UDF.unit_effectivity_id
10068: AND UE.mr_header_id = MR.mr_header_id(+)
10069: AND UE.csi_item_instance_id = p_csi_item_instance_id
10070: AND UE.application_usg_code = p_appln_usage_code

Line 10129: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue

10125: -- Read immediate children of the SR.
10126: CURSOR ahl_ue_reln_csr (p_ue_id IN NUMBER) IS
10127: SELECT ue.unit_effectivity_id, ue.status_code,
10128: UE.CSI_ITEM_INSTANCE_ID, UE.MR_HEADER_ID
10129: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue
10130: WHERE ue.unit_effectivity_id = uer.related_ue_id
10131: AND uer.ue_id = p_ue_id;
10132:
10133: --

Line 10599: FROM ahl_unit_effectivities_b UE

10595: UE.MR_HEADER_ID,
10596: UE.STATUS_CODE,
10597: UE.DUE_DATE,
10598: UE.DUE_COUNTER_VALUE
10599: FROM ahl_unit_effectivities_b UE
10600: WHERE UE.OBJECT_TYPE = 'SR'
10601: AND UE.application_usg_code = p_appln_usg_code
10602: AND defer_from_ue_id IS NULL
10603: AND csi_item_instance_id = p_csi_item_instance_id

Line 10856: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

10852: p_related_ue_id IN NUMBER ) IS
10853: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
10854: ue2.mr_header_id related_mr_header_id,
10855: ue2.csi_item_instance_id related_csi_item_instance_id
10856: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
10857: WHERE ue1.unit_effectivity_id = p_ue_id AND
10858: ue2.unit_effectivity_id = p_related_ue_id;
10859:
10860: -- Read applicable relns table for group MR details.

Line 11012: FROM ahl_unit_effectivities_b ue

11008: SELECT ue.mr_header_id,
11009: ue.csi_item_instance_id,
11010: ue.unit_effectivity_id,
11011: ue.status_code
11012: FROM ahl_unit_effectivities_b ue
11013: /*
11014: WHERE NOT EXISTS ( SELECT 'x'
11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

Line 11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

11012: FROM ahl_unit_effectivities_b ue
11013: /*
11014: WHERE NOT EXISTS ( SELECT 'x'
11015: --FROM ahl_ue_relationships uer, ahl_unit_effectivities_app_v ue1
11016: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
11017: WHERE uer.related_ue_id = ue.unit_effectivity_id AND
11018: uer.originator_ue_id = ue1.unit_effectivity_id AND
11019: ue1.object_type <> 'SR' )
11020: */

Line 11111: l_message_code ahl_unit_effectivities_b.message_code%TYPE;

11107: originator_ue_id = p_unit_effectivity_id;
11108:
11109: l_exception_flag BOOLEAN;
11110: l_grp_match_flag VARCHAR2(1);
11111: l_message_code ahl_unit_effectivities_b.message_code%TYPE;
11112: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
11113: l_junk VARCHAR2(1);
11114:
11115: l_ue_rec ahl_unit_effectivity_csr%ROWTYPE;

Line 11112: l_status_code ahl_unit_effectivities_b.status_code%TYPE;

11108:
11109: l_exception_flag BOOLEAN;
11110: l_grp_match_flag VARCHAR2(1);
11111: l_message_code ahl_unit_effectivities_b.message_code%TYPE;
11112: l_status_code ahl_unit_effectivities_b.status_code%TYPE;
11113: l_junk VARCHAR2(1);
11114:
11115: l_ue_rec ahl_unit_effectivity_csr%ROWTYPE;
11116:

Line 13026: AND EXISTS (select 'x' from ahl_unit_effectivities_b UE

13022: and me.inventory_item_id is not null
13023: ) mre
13024: WHERE cii.active_end_date <= sysdate
13025: AND mre.inventory_item_id = cii.inventory_item_id
13026: AND EXISTS (select 'x' from ahl_unit_effectivities_b UE
13027: where ue.csi_item_instance_id = cii.instance_id
13028: and (ue.status_code IS NULL OR ue.status_code IN ('INIT-DUE','EXCEPTION'))
13029: );
13030:

Line 14189: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

14185: SELECT ue1.mr_header_id, ue1.csi_item_instance_id,
14186: ue2.mr_header_id related_mr_header_id,
14187: ue2.csi_item_instance_id related_csi_item_instance_id
14188: --FROM ahl_unit_effectivities_app_v ue1, ahl_unit_effectivities_app_v ue2
14189: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
14190: WHERE ue1.unit_effectivity_id = p_ue_id AND
14191: ue2.unit_effectivity_id = p_related_ue_id;
14192:
14193:

Line 14233: FROM ahl_unit_effectivities_b

14229: -- Added for SB Enh.
14230: -- for prior MR, retain accomplishment trigger details.
14231: CURSOR get_accomplish_trig_dtls(p_unit_effectivity_id in number) IS
14232: SELECT accomplish_trigger_type, loop_chain_seq_num, start_lc_ue_id
14233: FROM ahl_unit_effectivities_b
14234: WHERE unit_effectivity_id = p_unit_effectivity_id;
14235:
14236:
14237: BEGIN

Line 14996: FROM ahl_unit_effectivities_b

14992: -- pick only deferrals and not SR related MRs.
14993:
14994: CURSOR ahl_ue_csr (p_unit_effectivity_id IN NUMBER) IS
14995: SELECT loop_chain_seq_num, start_lc_ue_id
14996: FROM ahl_unit_effectivities_b
14997: WHERE unit_effectivity_id = p_unit_effectivity_id;
14998:
14999:
15000: l_mr_tbl nbr_tbl_type;

Line 15190: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2

15186: CURSOR ahl_inprogress_chain_MRs(p_csi_item_instance_id IN NUMBER,
15187: p_mr_header_id IN NUMBER) IS
15188: SELECT ue.start_lc_ue_id,
15189: min(loop_chain_seq_num)
15190: FROM ahl_unit_effectivities_b ue1, ahl_unit_effectivities_b ue2
15191: WHERE ue1.unit_effectivity_id = ue2.start_lc_ue_id
15192: AND ue.csi_item_instance_id = p_csi_item_instance_id
15193: AND ue.status_code IS NOT NULL AND ue.status_code <> 'INIT-DUE'
15194: AND EXISTS (select 'x'

Line 15196: (select mr_header_id from ahl_unit_effectivities_b ue1

15192: AND ue.csi_item_instance_id = p_csi_item_instance_id
15193: AND ue.status_code IS NOT NULL AND ue.status_code <> 'INIT-DUE'
15194: AND EXISTS (select 'x'
15195: from ahl_mr_headers_b mr_title
15196: (select mr_header_id from ahl_unit_effectivities_b ue1
15197: where unit_effectivity_id = ue.start_lc_ue_id) start_mr
15198: where
15199: and appl_mr.start_mr_header_id = p_mr_header_id
15200: and appl_mr.mr_header_id = mr1.mr_header_id)

Line 15206: AND NOT EXISTS (select 'x' from ahl_unit_effectivities_b

15202: AND ue.defer_from_ue_id IS NULL
15203: AND ue.accomplish_trigger_type = 'CHAIN'
15204: AND (ue.status_code IS NULL)
15205: -- parent is accomplished
15206: AND NOT EXISTS (select 'x' from ahl_unit_effectivities_b
15207: where unit_effectivity_id = ue.start_lc_ue_id
15208: AND (status_code is NULL or status_code = 'INIT-DUE')
15209: )
15210: GROUP BY ue.start_lc_ue_id;

Line 15217: from ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

15213: -- get inprogress chain MRs
15214: CURSOR get_inprogress_chain_MRs(p_start_mr_header_id IN NUMBER,
15215: p_csi_item_instance_id IN NUMBER) IS
15216: SELECT ue.start_lc_ue_id, max(ue.loop_chain_seq_num)
15217: from ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
15218: where ue.csi_item_instance_id = p_csi_item_instance_id
15219: and ue.mr_header_id = mr.mr_header_id
15220: and ue.status_code IN ('ACCOMPLISHED','TERMINATED','INIT-ACCOMPLISHED')
15221: and mr.title in (select title from ahl_applicable_mrs appl, ahl_mr_headers_b mr1

Line 15226: and exists (select 'x' from ahl_unit_effectivities_b ue1

15222: where appl.start_mr_header_id = p_start_mr_header_id
15223: and appl.csi_item_instance_id = p_csi_item_instance_id
15224: and appl.mr_header_id = mr1.mr_header_id
15225: )
15226: and exists (select 'x' from ahl_unit_effectivities_b ue1
15227: where ue1.csi_item_instance_id = p_csi_item_instance_id
15228: and ue1.start_lc_ue_id = ue.start_lc_ue_id
15229: and (ue.STATUS_CODE IS NULL or ue.STATUS_CODE = 'INIT-DUE')
15230: )

Line 15240: FROM ahl_unit_effectivities_b ue

15236: SELECT ue.unit_effectivity_id,
15237: ue.due_date,
15238: ue.mr_header_id,
15239: to_date(null) visit_end_date
15240: FROM ahl_unit_effectivities_b ue
15241: WHERE ue.mr_header_id IN (select amh.mr_header_id from ahl_mr_headers_b amh where amh.title = p_start_mr_title)
15242: AND ue.csi_item_instance_id = p_csi_item_instance_id
15243: AND ue.status_code IS NULL
15244: AND ue.manually_planned_flag = 'Y'

Line 15248: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1

15244: AND ue.manually_planned_flag = 'Y'
15245: AND ue.defer_from_ue_id IS NULL
15246: -- Do not pick MRs associated to a SR.
15247: AND NOT EXISTS (SELECT 'x'
15248: FROM ahl_ue_relationships uer, ahl_unit_effectivities_b ue1
15249: WHERE uer.related_ue_id = ue.unit_effectivity_id
15250: AND uer.originator_ue_id = ue1.unit_effectivity_id
15251: AND ue1.object_type = 'SR');
15252:

Line 15269: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

15265: CURSOR get_chain_ue_csr(p_start_lc_ue_id in number,
15266: p_chain_seq_num in number) is
15267: SELECT ue.unit_effectivity_id, AHL_UMP_UTIL_PKG.get_Visit_Status (ue.unit_effectivity_id) l_visit_status,
15268: ue.defer_from_ue_id, ue.mr_header_id, mr.title
15269: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
15270: where ue.mr_header_id = mr.mr_header_id
15271: and ue.start_lc_ue_id = p_start_lc_ue_id
15272: and ue.loop_chain_seq_num = p_chain_seq_num
15273: and ue.accomplish_trigger_type = 'CHAIN';

Line 15281: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter

15277: p_chain_seq_num in number) is
15278: SELECT ue.accomplished_date, ue.unit_effectivity_id, ue.loop_chain_seq_num, ue.mr_header_id,
15279: decode(ue.status_code, 'TERMINATED', ter.affect_due_calc_flag, def.affect_due_calc_flag),
15280: decode(ue.status_code, 'TERMINATED', ter.deferral_effective_on, def.deferral_effective_on)
15281: FROM ahl_unit_effectivities_b ue, ahl_unit_deferrals_b def, ahl_unit_deferrals_b ter
15282: WHERE ue.defer_from_ue_id = def.unit_effectivity_id (+)
15283: AND ue.unit_effectivity_id = ter.unit_effectivity_id(+)
15284: AND ue.status_code IN ('ACCOMPLISHED','INIT-ACCOMPLISHED','TERMINATED')
15285: AND def.unit_deferral_type(+) = 'DEFERRAL'

Line 15603: -- update ahl_unit_effectivities_b for chain trigger

15599: l_unplan_unit_effectivity_rec.visit_end_date := l_start_vst_end_tbl(i);
15600: l_unplan_unit_effectivity_rec.repetitive_mr_flag := 'Y';
15601: l_unplan_unit_effectivity_rec.forecast_sequence := null;
15602:
15603: -- update ahl_unit_effectivities_b for chain trigger
15604: UPDATE ahl_unit_effectivities_b
15605: SET accomplish_trigger_type = p_applicable_mrs_rec.accomplish_trigger_type,
15606: start_lc_ue_id = l_start_ue_id_tbl(i),
15607: loop_chain_seq_num = p_applicable_mrs_rec.loop_chain_seq_num

Line 15604: UPDATE ahl_unit_effectivities_b

15600: l_unplan_unit_effectivity_rec.repetitive_mr_flag := 'Y';
15601: l_unplan_unit_effectivity_rec.forecast_sequence := null;
15602:
15603: -- update ahl_unit_effectivities_b for chain trigger
15604: UPDATE ahl_unit_effectivities_b
15605: SET accomplish_trigger_type = p_applicable_mrs_rec.accomplish_trigger_type,
15606: start_lc_ue_id = l_start_ue_id_tbl(i),
15607: loop_chain_seq_num = p_applicable_mrs_rec.loop_chain_seq_num
15608: WHERE unit_effectivity_id = l_start_ue_id_tbl(i);

Line 15687: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr

15683:
15684: CURSOR ahl_ue_csr (p_start_lc_ue_id IN NUMBER,
15685: p_loop_chain_seq_num IN NUMBER) IS
15686: SELECT unit_effectivity_id, mr.title
15687: FROM ahl_unit_effectivities_b ue, ahl_mr_headers_b mr
15688: WHERE ue.mr_header_id = mr.mr_header_id
15689: AND ue.start_lc_ue_id = p_start_lc_ue_id
15690: AND ue.loop_chain_seq_num = p_loop_chain_seq_num
15691: AND (ue.STATUS_CODE IS NULL or ue.STATUS_CODE = 'INIT-DUE');

Line 16118: -- due date details will be updated in ahl_unit_effectivities_b table.

16114: -----------------------------
16115:
16116: -- Added for Complex Assembly enhancements.
16117: -- Procedure to calculate NR due date for init-due definition.
16118: -- due date details will be updated in ahl_unit_effectivities_b table.
16119: PROCEDURE Calculate_Init_DueDate (
16120: x_return_status OUT NOCOPY VARCHAR2,
16121: x_msg_data OUT NOCOPY VARCHAR2,
16122: x_msg_count OUT NOCOPY NUMBER,

Line 16173: UPDATE ahl_unit_effectivities_b

16169: AHL_DEBUG_PUB.debug('Before updating UE table:UE:DDT:DCV:CTR_ID:' || p_unit_effectivity_id || ':' || l_due_date || ':' || l_due_counter_value || ':' || l_counter_id);
16170: END IF;
16171:
16172: -- Update table.
16173: UPDATE ahl_unit_effectivities_b
16174: SET due_date = l_due_date,
16175: due_counter_value = l_due_counter_value,
16176: counter_id = l_counter_id,
16177: last_update_date = sysdate,

Line 16183: UPDATE ahl_unit_effectivities_b

16179: object_version_number = object_version_number + 1
16180: WHERE unit_effectivity_id = p_unit_effectivity_id;
16181:
16182: -- update child UEs.
16183: UPDATE ahl_unit_effectivities_b
16184: SET due_date = l_due_date,
16185: due_counter_value = l_due_counter_value,
16186: counter_id = l_counter_id,
16187: last_update_date = sysdate,

Line 16449: FROM ahl_unit_effectivities_b ue, cs_incidents_all_b cs

16445: -- get resolution date.
16446: BEGIN
16447: SELECT cs.expected_resolution_date
16448: INTO l_expected_resolution_date
16449: FROM ahl_unit_effectivities_b ue, cs_incidents_all_b cs
16450: WHERE ue.unit_effectivity_id = p_unit_effectivity_id
16451: AND cs.incident_id = ue.cs_incident_id;
16452: EXCEPTION
16453: WHEN OTHERS THEN