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_UC_APPROVALS_PVT dependencies on AHL_UNIT_CONFIG_HEADERS

Line 66: FROM ahl_unit_config_headers

62: c_object_version_number in number)
63: IS
64: SELECT unit_config_header_id, name, object_version_number,
65: unit_config_status_code, active_uc_status_code, parent_uc_header_id
66: FROM ahl_unit_config_headers
67: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
68: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
69: AND unit_config_header_id = c_uc_header_id
70: AND object_version_number = c_object_version_number;

Line 163: UPDATE ahl_unit_config_headers

159: --If the approvals WF is turned on
160: IF (l_active='Y' AND l_process_name IS NOT NULL) THEN
161:
162: --Approval process started for unit_config_status_code
163: UPDATE ahl_unit_config_headers
164: SET unit_config_status_code='APPROVAL_PENDING',
165: object_version_number=object_version_number+1
166: WHERE unit_config_header_id=p_uc_header_id
167: And object_version_number=p_object_version_number;

Line 192: UPDATE ahl_unit_config_headers

188: ELSE
189:
190: --Not active, push through to complete
191: --Approval process started for unit_config_status_code
192: UPDATE ahl_unit_config_headers
193: SET unit_config_status_code='APPROVAL_PENDING',
194: object_version_number=object_version_number+1
195: WHERE unit_config_header_id=p_uc_header_id
196: And object_version_number=p_object_version_number;

Line 248: UPDATE ahl_unit_config_headers

244: --If the approvals WF is turned on
245: IF (l_active='Y' AND l_process_name IS NOT NULL) THEN
246:
247: --Approval process started for active_uc_status_code
248: UPDATE ahl_unit_config_headers
249: SET active_uc_status_code='APPROVAL_PENDING',
250: object_version_number=object_version_number+1
251: WHERE unit_config_header_id=p_uc_header_id
252: And object_version_number=p_object_version_number;

Line 276: UPDATE ahl_unit_config_headers

272: ELSE --not active, push through to complete
273:
274:
275: --Approval process started for active_uc_status_code
276: UPDATE ahl_unit_config_headers
277: SET active_uc_status_code='APPROVAL_PENDING',
278: object_version_number=object_version_number+1
279: WHERE unit_config_header_id=p_uc_header_id
280: And object_version_number=p_object_version_number;

Line 422: FROM ahl_unit_config_headers

418:
419: CURSOR get_uc_header_det(c_uc_header_id in number)
420: IS
421: SELECT unit_config_header_id, name, object_version_number, unit_config_status_code, active_uc_status_code
422: FROM ahl_unit_config_headers
423: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
424: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
425: AND unit_config_header_id = c_uc_header_id;
426:

Line 522: UPDATE ahl_unit_config_headers

518: l_status := 'INCOMPLETE';
519: END IF;
520:
521: --update table and write to history table
522: UPDATE ahl_unit_config_headers
523: SET unit_config_status_code=l_status,
524: active_uc_status_code='APPROVED',
525: object_version_number=object_version_number+1
526: WHERE unit_config_header_id=p_uc_header_id;

Line 534: UPDATE ahl_unit_config_headers

530: ELSE
531:
532: l_status := 'APPROVAL_REJECTED';
533: --update table
534: UPDATE ahl_unit_config_headers
535: SET unit_config_status_code=l_status,
536: object_version_number=object_version_number+1
537: WHERE unit_config_header_id=p_uc_header_id;
538:

Line 572: UPDATE ahl_unit_config_headers

568: END IF;
569:
570: --update the active_uc_status_code column and copy to history
571: -- Update the unit_config_status_code column as well.
572: UPDATE ahl_unit_config_headers
573: SET active_uc_status_code=l_status
574: ,unit_config_status_code = l_uc_status
575: WHERE unit_config_header_id=p_uc_header_id;
576: -- SATHAPLI::Bug 7018042, 05-May-2008, Fix end

Line 696: FROM ahl_unit_config_headers

692: object_version_number,
693: unit_config_status_code,
694: active_uc_status_code,
695: parent_uc_header_id
696: FROM ahl_unit_config_headers
697: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
698: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
699: AND unit_config_header_id = c_uc_header_id
700: AND object_version_number = c_object_version_number;

Line 795: UPDATE ahl_unit_config_headers

791: -- Check if the approvals WF is turned on
792: IF (l_active='Y' AND l_process_name IS NOT NULL) THEN
793:
794: --Approval process started for unit_config_status_code
795: UPDATE ahl_unit_config_headers
796: SET active_uc_status_code='APPROVAL_PENDING',
797: unit_config_status_code='QUARANTINE',
798: object_version_number=object_version_number+1
799: WHERE unit_config_header_id=p_uc_header_id

Line 825: UPDATE ahl_unit_config_headers

821:
822: ELSE -- Workflow process is not active, push through to complete
823:
824: --Approval process started for unit_config_status_code
825: UPDATE ahl_unit_config_headers
826: SET active_uc_status_code = 'APPROVAL_PENDING',
827: unit_config_status_code='QUARANTINE',
828: object_version_number=object_version_number+1
829: WHERE unit_config_header_id=p_uc_header_id

Line 966: FROM ahl_unit_config_headers

962: object_version_number,
963: unit_config_status_code,
964: active_uc_status_code,
965: parent_uc_header_id
966: FROM ahl_unit_config_headers
967: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
968: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
969: AND unit_config_header_id = c_uc_header_id
970: AND object_version_number = c_object_version_number;

Line 1060: UPDATE ahl_unit_config_headers

1056: -- Check if the approvals WF is turned on
1057: IF (l_active='Y' AND l_process_name IS NOT NULL) THEN
1058:
1059: --Approval process started for unit_config_status_code
1060: UPDATE ahl_unit_config_headers
1061: SET active_uc_status_code='APPROVAL_PENDING',
1062: unit_config_status_code='DEACTIVATE_QUARANTINE',
1063: object_version_number=object_version_number+1
1064: WHERE unit_config_header_id=p_uc_header_id

Line 1090: UPDATE ahl_unit_config_headers

1086:
1087: ELSE -- Workflow process is not active, push through to complete
1088:
1089: --Approval process started for unit_config_status_code
1090: UPDATE ahl_unit_config_headers
1091: SET active_uc_status_code = 'APPROVAL_PENDING',
1092: unit_config_status_code='DEACTIVATE_QUARANTINE',
1093: object_version_number=object_version_number+1
1094: WHERE unit_config_header_id=p_uc_header_id

Line 1231: FROM ahl_unit_config_headers

1227: name,
1228: object_version_number,
1229: unit_config_status_code,
1230: active_uc_status_code
1231: FROM ahl_unit_config_headers
1232: WHERE trunc(nvl(active_start_date,sysdate)) <= trunc(sysdate)
1233: AND trunc(sysdate) < trunc(nvl(active_end_date, sysdate+1))
1234: AND unit_config_header_id = c_uc_header_id;
1235:

Line 1360: UPDATE ahl_unit_config_headers

1356: IF G_DEBUG='Y' THEN
1357: AHL_DEBUG_PUB.debug( 'UC: AHL_UC_APPROVALS_PVT.complete_uc_approval--> Before Update');
1358: END IF;
1359:
1360: UPDATE ahl_unit_config_headers
1361: SET unit_config_status_code=l_status,
1362: active_uc_status_code='APPROVED',
1363: object_version_number=object_version_number+1
1364: WHERE unit_config_header_id=p_uc_header_id;