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.AMW_CONTROL_PVT dependencies on AMW_CONTROLS_B

Line 87: --(SELECT control_rev_id FROM amw_controls_b WHERE control_id =ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_id,

83: ac.approval_status,ac.end_date,
84: amw_controls_page_pkg.get_lookup_value('AMW_CONTROL_APPROVAL_STATUS',ac.approval_status) as approval_status_name,
85: DECODE(ac.curr_approved_flag,'Y',DECODE(ac.latest_revision_flag,'N', DECODE(ac.end_date,NULL, 'ChangeInProgress','NoChangeInProgress'),'NoChangeInProgress'),'NoChangeInProgress') as progress_switcher,
86: DECODE(ac.approval_status,'D','UpdateEnabled','UpdateDisabled') as update_switcher,
87: --(SELECT control_rev_id FROM amw_controls_b WHERE control_id =ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_id,
88: --(SELECT rev_num FROM amw_controls_b WHERE control_id = ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_num,
89: ac.rev_num,
90: DECODE(ac.approval_status,'D', DECODE (ac.end_date,NULL, 'DeleteEnabled','DeleteDisabled'),'DeleteDisabled') delete_switcher,
91: ac.latest_revision_flag|| ac.curr_approved_flag control_revision_choice,

Line 88: --(SELECT rev_num FROM amw_controls_b WHERE control_id = ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_num,

84: amw_controls_page_pkg.get_lookup_value('AMW_CONTROL_APPROVAL_STATUS',ac.approval_status) as approval_status_name,
85: DECODE(ac.curr_approved_flag,'Y',DECODE(ac.latest_revision_flag,'N', DECODE(ac.end_date,NULL, 'ChangeInProgress','NoChangeInProgress'),'NoChangeInProgress'),'NoChangeInProgress') as progress_switcher,
86: DECODE(ac.approval_status,'D','UpdateEnabled','UpdateDisabled') as update_switcher,
87: --(SELECT control_rev_id FROM amw_controls_b WHERE control_id =ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_id,
88: --(SELECT rev_num FROM amw_controls_b WHERE control_id = ac.control_id AND latest_revision_flag = 'Y') as latest_control_rev_num,
89: ac.rev_num,
90: DECODE(ac.approval_status,'D', DECODE (ac.end_date,NULL, 'DeleteEnabled','DeleteDisabled'),'DeleteDisabled') delete_switcher,
91: ac.latest_revision_flag|| ac.curr_approved_flag control_revision_choice,
92: amw_controls_page_pkg.get_lookup_value('AMW_REVISION_VIEW_CHOICE',ac.latest_revision_flag|| ac.curr_approved_flag) revision

Line 93: FROM amw_controls_b ac,

89: ac.rev_num,
90: DECODE(ac.approval_status,'D', DECODE (ac.end_date,NULL, 'DeleteEnabled','DeleteDisabled'),'DeleteDisabled') delete_switcher,
91: ac.latest_revision_flag|| ac.curr_approved_flag control_revision_choice,
92: amw_controls_page_pkg.get_lookup_value('AMW_REVISION_VIEW_CHOICE',ac.latest_revision_flag|| ac.curr_approved_flag) revision
93: FROM amw_controls_b ac,
94: amw_controls_tl act,
95: fnd_application_vl fav,
96: per_jobs pj
97: WHERE ac.application_id = fav.application_id(+)

Line 110: FROM amw_controls_b ac, amw_controls_tl act

106: CURSOR rev_enabled IS
107: SELECT act.NAME, act.description, ac.control_rev_id, ac.control_id, ac.rev_num,
108: ac.object_version_number, ac.approval_status,
109: ac.curr_approved_flag, ac.latest_revision_flag, ac.requestor_id
110: FROM amw_controls_b ac, amw_controls_tl act
111: WHERE ac.latest_revision_flag = 'Y'
112: AND act.control_rev_id = ac.control_rev_id
113: AND act.LANGUAGE = USERENV ('LANG')
114: AND ( ac.approval_status = 'A'

Line 130: FROM amw_controls_b

126: l_c_r_i number := 0;
127:
128: CURSOR get_control_id (l_control_rev_id IN NUMBER) IS
129: SELECT control_id
130: FROM amw_controls_b
131: WHERE control_rev_id = l_control_rev_id;
132:
133: out_control_id number;
134:

Line 383: select count(*) into l_rev_count from amw_controls_b

379:
380: RAISE fnd_api.g_exc_error;
381: ELSIF (l_update_row_found = 1) THEN ----elsif for update status
382: fnd_file.put_line (fnd_file.LOG,'Inside L_Update_Row_Found = 1, l_control_rec.control_id: '||l_control_rec.control_id);
383: select count(*) into l_rev_count from amw_controls_b
384: where control_id=l_control_rec.control_id
385: and curr_approved_flag='Y'
386: and latest_revision_flag='N';
387:

Line 396: /*select nvl(object_version_number,0) into l_o_v_n from amw_controls_b

392: --- this if is needed to set the curr_approved_flag of the
393: --- previous revision to 'N'
394: if(l_rev_count=1 and l_control_rec.approval_status='A') then
395: fnd_file.put_line (fnd_file.LOG,'Inside controversial IF because ---> l_rev_count: '||l_rev_count||' l_control_rec.approval_status: '||l_control_rec.approval_status);
396: /*select nvl(object_version_number,0) into l_o_v_n from amw_controls_b
397: where control_id=l_control_rec.control_id
398: and curr_approved_flag='Y'
399: and latest_revision_flag='N';
400:

Line 404: select control_rev_id into l_c_r_i from amw_controls_b

400:
401: l_o_v_n := l_o_v_n+1;
402: */
403:
404: select control_rev_id into l_c_r_i from amw_controls_b
405: where control_id=l_control_rec.control_id
406: and curr_approved_flag='Y'
407: and latest_revision_flag='N';
408:

Line 409: update amw_controls_b

405: where control_id=l_control_rec.control_id
406: and curr_approved_flag='Y'
407: and latest_revision_flag='N';
408:
409: update amw_controls_b
410: set object_version_number=object_version_number+1,
411: curr_approved_flag='N',
412: latest_revision_flag='N',
413: ---12.28.2004 npanandi: setting the EndDate to sysdate for

Line 523: FROM amw_controls_b

519: SELECT amw_control_rev_s.NEXTVAL
520: FROM DUAL;
521: CURSOR c_id_exists (l_id IN NUMBER) IS
522: SELECT 1
523: FROM amw_controls_b
524: WHERE control_id = l_id;
525: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
526: SELECT 1
527: FROM amw_controls_b

Line 527: FROM amw_controls_b

523: FROM amw_controls_b
524: WHERE control_id = l_id;
525: CURSOR c_rev_id_exists (l_rev_id IN NUMBER) IS
526: SELECT 1
527: FROM amw_controls_b
528: WHERE control_rev_id = l_rev_id;
529: l_row_id amw_controls_all_vl.row_id%TYPE;
530: CURSOR c IS
531: SELECT ROWID

Line 532: FROM amw_controls_b

528: WHERE control_rev_id = l_rev_id;
529: l_row_id amw_controls_all_vl.row_id%TYPE;
530: CURSOR c IS
531: SELECT ROWID
532: FROM amw_controls_b
533: WHERE control_rev_id = x_control_rev_id;
534: BEGIN
535: -- Standard Start of API savepoint
536: SAVEPOINT create_control_pvt;

Line 631: -- Invoke table handler(AMW_CONTROLS_B_PKG.Insert_Row)

627: l_control_id := l_control_id;
628: ELSE
629: l_control_id := l_control_rec.control_id;
630: END IF;
631: -- Invoke table handler(AMW_CONTROLS_B_PKG.Insert_Row)
632: amw_controls_pkg.insert_row
633: (x_rowid => l_row_id,
634: x_control_rev_id => l_control_rec.control_rev_id,
635: x_object_version_number => l_control_rec.object_version_number,

Line 755: FROM amw_controls_b

751: x_object_version_number OUT nocopy NUMBER
752: ) IS
753: CURSOR c_get_control (control_rev_id NUMBER) IS
754: SELECT *
755: FROM amw_controls_b
756: WHERE control_rev_id = control_rev_id;
757: -- Hint: Developer need to provide Where clause
758: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Control';
759: l_api_version_number CONSTANT NUMBER := 1.0;

Line 990: -- Invoke table handler(AMW_CONTROLS_B_PKG.Delete_Row)

986: --
987: -- Debug Message
988: ---amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
989: amw_utility_pvt.debug_message ('Private API: Calling delete table handler');
990: -- Invoke table handler(AMW_CONTROLS_B_PKG.Delete_Row)
991: amw_controls_pkg.delete_row (x_control_rev_id => p_control_rev_id);
992: --
993: -- End of API body
994: --

Line 1055: FROM amw_controls_b

1051: := g_pkg_name || '.' || l_api_name;
1052: l_control_rev_id NUMBER;
1053: CURSOR c_control IS
1054: SELECT control_rev_id
1055: FROM amw_controls_b
1056: WHERE control_rev_id = p_control_rev_id
1057: AND object_version_number = p_object_version
1058: FOR UPDATE NOWAIT;
1059: BEGIN

Line 1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');

1135: BEGIN
1136: x_return_status := fnd_api.g_ret_sts_success;
1137: IF p_validation_mode = 'CREATE' THEN
1138: l_valid_flag :=
1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');
1140: ELSE
1141: l_valid_flag :=
1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;

Line 1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);

1138: l_valid_flag :=
1139: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| '''');
1140: ELSE
1141: l_valid_flag :=
1142: amw_utility_pvt.check_uniqueness ('AMW_CONTROLS_B','CONTROL_REV_ID = '''|| p_control_rec.control_rev_id|| ''' AND CONTROL_REV_ID <> '|| p_control_rec.control_rev_id);
1143: END IF;
1144: IF l_valid_flag = fnd_api.g_false THEN
1145: ---amw_utility_pvt.error_message(p_message_name => 'AMW_CONTROL_REV_ID_DUPLICATE');
1146: AMW_UTILITY_PVT.Error_Message(p_message_name => 'AMW_UNIQUE_ITEM_ERROR',

Line 1305: FROM amw_controls_b

1301: ) IS
1302: l_return_status VARCHAR2 (1);
1303: CURSOR c_complete IS
1304: SELECT *
1305: FROM amw_controls_b
1306: WHERE control_rev_id = p_control_rec.control_rev_id;
1307: l_control_rec c_complete%ROWTYPE;
1308:
1309: CURSOR c_desc IS