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_RM_APPROVAL_PVT dependencies on AHL_OPERATIONS_B

Line 68: FROM AHL_OPERATIONS_B_KFV

64:
65: CURSOR CurOperDet
66: is
67: SELECT *
68: FROM AHL_OPERATIONS_B_KFV
69: WHERE OPERATION_ID=p_activity_id;
70:
71: l_oper_Rec CurOperDet%rowtype;
72:

Line 283: From ahl_operations_b_KFV

279: revision_number,
280: start_date_active,
281: end_date_active,
282: concatenated_segments
283: From ahl_operations_b_KFV
284: Where operation_id = c_operation_id;
285:
286: l_oper_rec get_oper_Det%rowtype;
287:

Line 295: From ahl_operations_b_kfv

291: revision_number,
292: start_date_active,
293: end_date_active,
294: concatenated_segments
295: From ahl_operations_b_kfv
296: Where operation_id = c_operation_id;
297:
298: -- Bug # 8639648 -- start
299: -- Fetches all active routes which has time span greater than

Line 306: ahl_operations_b oper

302: IS
303: SELECT rou.route_id
304: FROM AHL_ROUTES_APP_V rou ,
305: ahl_route_operations arop,
306: ahl_operations_b oper
307: WHERE (
308: TRUNC(rou.start_date_active) >= TRUNC(oper.start_date_active)
309: AND
310: TRUNC(NVL(oper.end_date_active, rou.start_date_active + 1)) > TRUNC(rou.start_date_active)

Line 451: From ahl_operations_b

447: ELSIF p_apprvl_type = 'TERMINATE'
448: THEN
449: --bachandr Enigma Phase I changes -- start
450: Select ENIGMA_OP_ID into l_enig_op_id
451: From ahl_operations_b
452: Where operation_id = p_source_operation_id;
453:
454: IF ( l_enig_op_id is not null)
455: THEN

Line 490: FROM AHL_OPERATIONS_B_KFV

486: THEN
487: l_upd_status := 'TERMINATION_PENDING';
488:
489: SELECT COUNT(*) into l_counter
490: FROM AHL_OPERATIONS_B_KFV
491: WHERE CONCATENATED_SEGMENTS=l_oper_Rec.CONCATENATED_SEGMENTS
492: AND REVISION_NUMBER=l_oper_Rec.revision_number+1;
493:
494: IF l_counter>0

Line 520: Update AHL_OPERATIONS_B

516: END IF;
517:
518: IF l_ACTIVE='Y'
519: THEN
520: Update AHL_OPERATIONS_B
521: Set REVISION_STATUS_CODE=l_upd_status,
522: OBJECT_VERSION_number=OBJECT_VERSION_number+1
523: Where OPERATION_ID=p_source_operation_id
524: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 556: UPDATE AHL_OPERATIONS_B

552: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
553: P_ITEM_TYPE =>'AHLGAPP');
554:
555: ELSE
556: UPDATE AHL_OPERATIONS_B
557: SET REVISION_STATUS_CODE=l_upd_status,
558: OBJECT_VERSION_number=OBJECT_VERSION_number+1
559: WHERE OPERATION_ID=p_source_OPERATION_id
560: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1455: FROM AHL_OPERATIONS_B_KFV

1451: CONCATENATED_SEGMENTS,
1452: REVISION_NUMBER,
1453: START_DATE_ACTIVE,
1454: END_DATE_ACTIVE
1455: FROM AHL_OPERATIONS_B_KFV
1456: WHERE OPERATION_ID=C_OPERATION_ID;
1457:
1458: CURSOR GetPrevOperDet(C_REVISION_NUMBER NUMBER,C_CONCATENATED_SEGMENTS VARCHAR2)
1459: IS

Line 1465: FROM AHL_OPERATIONS_B_KFV

1461: CONCATENATED_SEGMENTS,
1462: REVISION_NUMBER,
1463: START_DATE_ACTIVE,
1464: END_DATE_ACTIVE
1465: FROM AHL_OPERATIONS_B_KFV
1466: WHERE CONCATENATED_SEGMENTS=C_CONCATENATED_SEGMENTS
1467: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
1468:
1469: l_oper_rec GetOperationDet%rowtype;

Line 1500: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;

1496: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1497: END IF;
1498:
1499: SELECT REVISION_STATUS_CODE INTO l_curr_status
1500: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;
1501:
1502: IF p_appr_status='APPROVED'
1503: THEN
1504: l_status:='COMPLETE';

Line 1543: UPDATE AHL_OPERATIONS_B

1539:
1540: CLOSE GetOperationDet;
1541: IF l_check_flag='Y' and p_appr_status='REJECTED'
1542: THEN
1543: UPDATE AHL_OPERATIONS_B
1544: SET REVISION_STATUS_CODE=l_status,
1545: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1546: WHERE OPERATION_ID=P_OPERATION_ID;
1547: UPDATE AHL_OPERATIONS_TL

Line 1553: UPDATE AHL_OPERATIONS_B

1549: WHERE OPERATION_ID=P_OPERATION_ID;
1550: ELSIF l_check_flag='Y' and l_curr_status='TERMINATION_PENDING'
1551: and p_appr_status='APPROVED'
1552: THEN
1553: UPDATE AHL_OPERATIONS_B
1554: SET REVISION_STATUS_CODE='TERMINATED',
1555: -- START_DATE_ACTIVE=l_fr_date,
1556: END_DATE_ACTIVE=l_to_date,
1557: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 1587: UPDATE AHL_OPERATIONS_B

1583:
1584: ELSIF l_check_flag='Y' and l_oper_rec.revision_number=1
1585: and l_curr_status='APPROVAL_PENDING' and p_appr_status='APPROVED'
1586: THEN
1587: UPDATE AHL_OPERATIONS_B
1588: SET REVISION_STATUS_CODE=l_status,
1589: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1590: WHERE OPERATION_ID=P_OPERATION_ID;
1591:

Line 1613: UPDATE AHL_OPERATIONS_B

1609: CLOSE GetPrevOperDet;
1610:
1611: IF l_check_flag2='Y'
1612: THEN
1613: UPDATE AHL_OPERATIONS_B
1614: SET REVISION_STATUS_CODE=l_status,
1615: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1616: START_DATE_ACTIVE=l_fr_date
1617: WHERE OPERATION_ID=P_OPERATION_ID;

Line 1620: UPDATE AHL_OPERATIONS_B

1616: START_DATE_ACTIVE=l_fr_date
1617: WHERE OPERATION_ID=P_OPERATION_ID;
1618: IF l_check_flag3='Y'
1619: THEN
1620: UPDATE AHL_OPERATIONS_B
1621: SET REVISION_STATUS_CODE=l_status,
1622: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1623: END_DATE_ACTIVE=l_to_date
1624: WHERE OPERATION_ID=l_prev_oper_rec.OPERATION_ID;