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 1996: FROM eng_revised_items

1992:
1993: -- Select all revised items
1994: CURSOR c_revItems IS
1995: SELECT status_code
1996: FROM eng_revised_items
1997: WHERE change_id = p_change_id
1998: FOR UPDATE;
1999:
2000:

Line 2054: FROM eng_revised_items

2050: CURSOR c_no_revisedItem IS
2051: SELECT 'Y'
2052: FROM DUAL
2053: WHERE not exists (SELECT 1
2054: FROM eng_revised_items
2055: WHERE change_id=p_change_id
2056: AND status_code <> 5
2057: );
2058:

Line 2632: UPDATE eng_revised_items

2628:
2629: -- Only promote those revised items whose phase are lower than
2630: -- the new header promotion phase
2631: IF (l_ri_phase_sn < l_new_phase_sn) THEN
2632: UPDATE eng_revised_items
2633: SET status_code = p_status_code,
2634: status_type = l_new_status_type,
2635: last_update_date = sysdate,
2636: last_updated_by = l_fnd_user_id,

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

2636: last_updated_by = l_fnd_user_id,
2637: last_update_login = l_fnd_login_id
2638: WHERE CURRENT OF c_revItems;
2639: IF g_debug_flag THEN
2640: Write_Debug('After updating eng_revised_items.');
2641: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
2642: END IF;
2643: END IF; -- ri_phase < new_header_phase
2644: END IF; -- not imp or cancelled

Line 3106: FROM eng_revised_items

3102: l_status_prop_row eng_status_properties%ROWTYPE;
3103:
3104: CURSOR c_revItems IS
3105: SELECT status_code
3106: FROM eng_revised_items
3107: WHERE change_id = p_change_id
3108: FOR UPDATE;
3109: l_ri_status_code eng_change_lines.status_code%TYPE;
3110: -- revItem's status_code's sequence_number

Line 3551: UPDATE eng_revised_items

3547:
3548: -- Update only those which are active
3549: -- and whose phase is ahead of the new demotion phase
3550: IF (l_ri_phase_sn > l_new_phase_sn) THEN
3551: UPDATE eng_revised_items
3552: SET status_code = p_status_code,
3553: status_type = l_new_status_type,
3554: last_update_date = sysdate,
3555: last_updated_by = l_fnd_user_id,

Line 3858: FROM eng_revised_items

3854: FROM eng_lifecycle_statuses
3855: WHERE entity_name = G_ENG_CHANGE
3856: AND entity_id1 = p_change_id
3857: AND status_code = ( SELECT status_code
3858: FROM eng_revised_items
3859: WHERE revised_item_sequence_id = p_object_id2)
3860: AND active_flag = 'Y'
3861: AND rownum = 1;
3862:

Line 4008: UPDATE eng_revised_items

4004: Write_Debug('l_request_id : ' || l_request_id );
4005: END IF;
4006:
4007: -- update parent revised item
4008: UPDATE eng_revised_items
4009: SET status_type = G_ENG_IMP_IN_PROGRESS,
4010: last_update_date = sysdate,
4011: last_updated_by = l_fnd_user_id,
4012: last_update_login = l_fnd_login_id,

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

4012: last_update_login = l_fnd_login_id,
4013: Implementation_req_id = l_request_id
4014: WHERE revised_item_sequence_id = p_object_id2;
4015: IF g_debug_flag THEN
4016: Write_Debug('After updating eng_revised_items (parent level).');
4017: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4018: END IF;
4019:
4020: -- update active children revised items

Line 4021: UPDATE eng_revised_items

4017: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4018: END IF;
4019:
4020: -- update active children revised items
4021: UPDATE eng_revised_items
4022: SET status_type = G_ENG_IMP_IN_PROGRESS,
4023: last_update_date = sysdate,
4024: last_updated_by = l_fnd_user_id,
4025: last_update_login = l_fnd_login_id,

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

4026: Implementation_req_id = l_request_id
4027: WHERE parent_revised_item_seq_id = p_object_id2
4028: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);
4029: IF g_debug_flag THEN
4030: Write_Debug('After updating eng_revised_items (child level).');
4031: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4032: END IF;
4033:
4034: -- Case: promoting revised item to a phase that's not the last implement phase

Line 4037: UPDATE eng_revised_items

4033:
4034: -- Case: promoting revised item to a phase that's not the last implement phase
4035: ELSE
4036: -- update parent revised item
4037: UPDATE eng_revised_items
4038: SET status_code = p_status_code,
4039: status_type = l_new_status_type,
4040: last_update_date = sysdate,
4041: last_updated_by = l_fnd_user_id,

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

4041: last_updated_by = l_fnd_user_id,
4042: last_update_login = l_fnd_login_id
4043: WHERE revised_item_sequence_id = p_object_id2;
4044: IF g_debug_flag THEN
4045: Write_Debug('After updating eng_revised_items (parent level).');
4046: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4047: END IF;
4048:
4049: -- update active children revised items

Line 4050: /* UPDATE eng_revised_items

4046: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4047: END IF;
4048:
4049: -- update active children revised items
4050: /* UPDATE eng_revised_items
4051: SET status_code = p_status_code,
4052: status_type = l_new_status_type,
4053: last_update_date = sysdate,
4054: last_updated_by = l_fnd_user_id,

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

4055: last_update_login = l_fnd_login_id
4056: WHERE parent_revised_item_seq_id = p_object_id2
4057: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);*/
4058: IF g_debug_flag THEN
4059: Write_Debug('After updating eng_revised_items (child level).');
4060: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4061: END IF;
4062: END IF;
4063:

Line 4232: FROM eng_revised_items

4228: WHERE entity_name = G_ENG_CHANGE
4229: AND entity_id1 = p_change_id
4230: AND active_flag = 'Y'
4231: AND status_code = ( SELECT status_code
4232: FROM eng_revised_items
4233: WHERE revised_item_sequence_id = p_object_id2)
4234: AND rownum = 1;
4235:
4236: -- Get the sequence number for the new phase of the change header

Line 4280: UPDATE eng_revised_items

4276: FND_MSG_PUB.Add;
4277: RAISE FND_API.G_EXC_ERROR;
4278: ELSE
4279: -- update parent revised item
4280: UPDATE eng_revised_items
4281: SET status_code = p_status_code,
4282: status_type = l_new_status_type,
4283: last_update_date = sysdate,
4284: last_updated_by = l_fnd_user_id,

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

4284: last_updated_by = l_fnd_user_id,
4285: last_update_login = l_fnd_login_id
4286: WHERE revised_item_sequence_id = p_object_id2;
4287: IF g_debug_flag THEN
4288: Write_Debug('After updating eng_revised_items (parent level).');
4289: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4290: END IF;
4291:
4292: -- update active children revised items

Line 4293: UPDATE eng_revised_items

4289: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4290: END IF;
4291:
4292: -- update active children revised items
4293: UPDATE eng_revised_items
4294: SET status_code = p_status_code,
4295: status_type = l_new_status_type,
4296: last_update_date = sysdate,
4297: last_updated_by = l_fnd_user_id,

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

4298: last_update_login = l_fnd_login_id
4299: WHERE parent_revised_item_seq_id = p_object_id2
4300: AND status_type NOT IN (G_ENG_IMPLEMENTED, G_ENG_CANCELLED);
4301: IF g_debug_flag THEN
4302: Write_Debug('After updating eng_revised_items (child level).');
4303: Write_Debug(' Row count = ' || SQL%ROWCOUNT);
4304: END IF;
4305:
4306:

Line 7156: UPDATE eng_revised_items

7152: END IF;
7153:
7154:
7155: -- Real code starts here -----------------------------------------------
7156: UPDATE eng_revised_items
7157: SET status_type = p_status_type,
7158: last_update_date = sysdate,
7159: last_updated_by = l_fnd_user_id,
7160: last_update_login = l_fnd_login_id