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.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_REVISED_ITEMS

Line 553: FROM eng_revised_items eri

549: IS
550: l_rev_item_seq_id NUMBER;
551: CURSOR c_activeRevItem IS
552: SELECT revised_item_sequence_id
553: FROM eng_revised_items eri
554: WHERE eri.change_id = p_change_id
555: AND eri.status_type NOT IN (G_ENG_CANCELLED, G_ENG_IMPLEMENTED);
556: BEGIN
557: OPEN c_activeRevItem;

Line 2022: FROM eng_revised_items

2018:
2019: -- Select all revised items
2020: CURSOR c_revItems IS
2021: SELECT status_code
2022: FROM eng_revised_items
2023: WHERE change_id = p_change_id
2024: FOR UPDATE;
2025:
2026:

Line 2080: FROM eng_revised_items

2076: CURSOR c_no_revisedItem IS
2077: SELECT 'Y'
2078: FROM DUAL
2079: WHERE not exists (SELECT 1
2080: FROM eng_revised_items
2081: WHERE change_id=p_change_id
2082: AND status_code <> 5
2083: );
2084:

Line 2715: UPDATE eng_revised_items

2711:
2712: -- Only promote those revised items whose phase are lower than
2713: -- the new header promotion phase
2714: IF (l_ri_phase_sn < l_new_phase_sn) THEN
2715: UPDATE eng_revised_items
2716: SET status_code = p_status_code,
2717: status_type = l_new_status_type,
2718: last_update_date = sysdate,
2719: last_updated_by = l_fnd_user_id,

Line 2723: Write_Debug('After updating eng_revised_items.');

2719: last_updated_by = l_fnd_user_id,
2720: last_update_login = l_fnd_login_id
2721: WHERE CURRENT OF c_revItems;
2722: IF g_debug_flag THEN
2723: Write_Debug('After updating eng_revised_items.');
2724: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2725: END IF;
2726: END IF; -- ri_phase < new_header_phase
2727: END IF; -- not imp or cancelled

Line 3197: FROM eng_revised_items

3193: l_status_prop_row eng_status_properties%ROWTYPE;
3194:
3195: CURSOR c_revItems IS
3196: SELECT status_code
3197: FROM eng_revised_items
3198: WHERE change_id = p_change_id
3199: FOR UPDATE;
3200: l_ri_status_code eng_change_lines.status_code%TYPE;
3201: -- revItem's status_code's sequence_number

Line 3669: UPDATE eng_revised_items

3665:
3666: -- Update only those which are active
3667: -- and whose phase is ahead of the new demotion phase
3668: IF (l_ri_phase_sn > l_new_phase_sn) THEN
3669: UPDATE eng_revised_items
3670: SET status_code = p_status_code,
3671: status_type = l_new_status_type,
3672: last_update_date = sysdate,
3673: last_updated_by = l_fnd_user_id,

Line 3976: FROM eng_revised_items

3972: FROM eng_lifecycle_statuses
3973: WHERE entity_name = G_ENG_CHANGE
3974: AND entity_id1 = p_change_id
3975: AND status_code = ( SELECT status_code
3976: FROM eng_revised_items
3977: WHERE revised_item_sequence_id = p_object_id2)
3978: AND active_flag = 'Y'
3979: AND rownum = 1;
3980:

Line 4126: UPDATE eng_revised_items

4122: Write_Debug('l_request_id : ' || l_request_id );
4123: END IF;
4124:
4125: -- update parent revised item
4126: UPDATE eng_revised_items
4127: SET status_type = G_ENG_IMP_IN_PROGRESS,
4128: last_update_date = sysdate,
4129: last_updated_by = l_fnd_user_id,
4130: last_update_login = l_fnd_login_id,

Line 4134: Write_Debug('After updating eng_revised_items (parent level).');

4130: last_update_login = l_fnd_login_id,
4131: Implementation_req_id = l_request_id
4132: WHERE revised_item_sequence_id = p_object_id2;
4133: IF g_debug_flag THEN
4134: Write_Debug('After updating eng_revised_items (parent level).');
4135: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4136: END IF;
4137:
4138: -- update active children revised items

Line 4139: UPDATE eng_revised_items

4135: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4136: END IF;
4137:
4138: -- update active children revised items
4139: UPDATE eng_revised_items
4140: SET status_type = G_ENG_IMP_IN_PROGRESS,
4141: last_update_date = sysdate,
4142: last_updated_by = l_fnd_user_id,
4143: last_update_login = l_fnd_login_id,

Line 4148: Write_Debug('After updating eng_revised_items (child level).');

4144: Implementation_req_id = l_request_id
4145: WHERE parent_revised_item_seq_id = p_object_id2
4146: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);
4147: IF g_debug_flag THEN
4148: Write_Debug('After updating eng_revised_items (child level).');
4149: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4150: END IF;
4151:
4152: -- Case: promoting revised item to a phase that's not the last implement phase

Line 4155: UPDATE eng_revised_items

4151:
4152: -- Case: promoting revised item to a phase that's not the last implement phase
4153: ELSE
4154: -- update parent revised item
4155: UPDATE eng_revised_items
4156: SET status_code = p_status_code,
4157: status_type = l_new_status_type,
4158: last_update_date = sysdate,
4159: last_updated_by = l_fnd_user_id,

Line 4163: Write_Debug('After updating eng_revised_items (parent level).');

4159: last_updated_by = l_fnd_user_id,
4160: last_update_login = l_fnd_login_id
4161: WHERE revised_item_sequence_id = p_object_id2;
4162: IF g_debug_flag THEN
4163: Write_Debug('After updating eng_revised_items (parent level).');
4164: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4165: END IF;
4166:
4167: -- update active children revised items

Line 4168: /* UPDATE eng_revised_items

4164: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4165: END IF;
4166:
4167: -- update active children revised items
4168: /* UPDATE eng_revised_items
4169: SET status_code = p_status_code,
4170: status_type = l_new_status_type,
4171: last_update_date = sysdate,
4172: last_updated_by = l_fnd_user_id,

Line 4177: Write_Debug('After updating eng_revised_items (child level).');

4173: last_update_login = l_fnd_login_id
4174: WHERE parent_revised_item_seq_id = p_object_id2
4175: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);*/
4176: IF g_debug_flag THEN
4177: Write_Debug('After updating eng_revised_items (child level).');
4178: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4179: END IF;
4180: END IF;
4181:

Line 4350: FROM eng_revised_items

4346: WHERE entity_name = G_ENG_CHANGE
4347: AND entity_id1 = p_change_id
4348: AND active_flag = 'Y'
4349: AND status_code = ( SELECT status_code
4350: FROM eng_revised_items
4351: WHERE revised_item_sequence_id = p_object_id2)
4352: AND rownum = 1;
4353:
4354: -- Get the sequence number for the new phase of the change header

Line 4398: UPDATE eng_revised_items

4394: FND_MSG_PUB.Add;
4395: RAISE FND_API.G_EXC_ERROR;
4396: ELSE
4397: -- update parent revised item
4398: UPDATE eng_revised_items
4399: SET status_code = p_status_code,
4400: status_type = l_new_status_type,
4401: last_update_date = sysdate,
4402: last_updated_by = l_fnd_user_id,

Line 4406: Write_Debug('After updating eng_revised_items (parent level).');

4402: last_updated_by = l_fnd_user_id,
4403: last_update_login = l_fnd_login_id
4404: WHERE revised_item_sequence_id = p_object_id2;
4405: IF g_debug_flag THEN
4406: Write_Debug('After updating eng_revised_items (parent level).');
4407: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4408: END IF;
4409:
4410: -- update active children revised items

Line 4411: UPDATE eng_revised_items

4407: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4408: END IF;
4409:
4410: -- update active children revised items
4411: UPDATE eng_revised_items
4412: SET status_code = p_status_code,
4413: status_type = l_new_status_type,
4414: last_update_date = sysdate,
4415: last_updated_by = l_fnd_user_id,

Line 4420: Write_Debug('After updating eng_revised_items (child level).');

4416: last_update_login = l_fnd_login_id
4417: WHERE parent_revised_item_seq_id = p_object_id2
4418: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);
4419: IF g_debug_flag THEN
4420: Write_Debug('After updating eng_revised_items (child level).');
4421: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4422: END IF;
4423:
4424:

Line 7447: UPDATE eng_revised_items

7443: END IF;
7444:
7445:
7446: -- Real code starts here -----------------------------------------------
7447: UPDATE eng_revised_items
7448: SET status_type = p_status_type,
7449: last_update_date = sysdate,
7450: last_updated_by = l_fnd_user_id,
7451: last_update_login = l_fnd_login_id