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: l_oper_rec1 get_oper_Det2%rowtype;
299: l_msg VARCHAR2(30);

Line 395: From ahl_operations_b

391: ELSIF p_apprvl_type = 'TERMINATE'
392: THEN
393: --bachandr Enigma Phase I changes -- start
394: Select ENIGMA_OP_ID into l_enig_op_id
395: From ahl_operations_b
396: Where operation_id = p_source_operation_id;
397:
398: IF ( l_enig_op_id is not null)
399: THEN

Line 434: FROM AHL_OPERATIONS_B_KFV

430: THEN
431: l_upd_status := 'TERMINATION_PENDING';
432:
433: SELECT COUNT(*) into l_counter
434: FROM AHL_OPERATIONS_B_KFV
435: WHERE CONCATENATED_SEGMENTS=l_oper_Rec.CONCATENATED_SEGMENTS
436: AND REVISION_NUMBER=l_oper_Rec.revision_number+1;
437:
438: IF l_counter>0

Line 464: Update AHL_OPERATIONS_B

460: END IF;
461:
462: IF l_ACTIVE='Y'
463: THEN
464: Update AHL_OPERATIONS_B
465: Set REVISION_STATUS_CODE=l_upd_status,
466: OBJECT_VERSION_number=OBJECT_VERSION_number+1
467: Where OPERATION_ID=p_source_operation_id
468: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 500: UPDATE AHL_OPERATIONS_B

496: P_WORKFLOWPROCESS =>'AHL_GEN_APPROVAL',
497: P_ITEM_TYPE =>'AHLGAPP');
498:
499: ELSE
500: UPDATE AHL_OPERATIONS_B
501: SET REVISION_STATUS_CODE=l_upd_status,
502: OBJECT_VERSION_number=OBJECT_VERSION_number+1
503: WHERE OPERATION_ID=p_source_OPERATION_id
504: and OBJECT_VERSION_NUMBER=p_object_Version_number;

Line 1395: FROM AHL_OPERATIONS_B_KFV

1391: CONCATENATED_SEGMENTS,
1392: REVISION_NUMBER,
1393: START_DATE_ACTIVE,
1394: END_DATE_ACTIVE
1395: FROM AHL_OPERATIONS_B_KFV
1396: WHERE OPERATION_ID=C_OPERATION_ID;
1397:
1398: CURSOR GetPrevOperDet(C_REVISION_NUMBER NUMBER,C_CONCATENATED_SEGMENTS VARCHAR2)
1399: IS

Line 1405: FROM AHL_OPERATIONS_B_KFV

1401: CONCATENATED_SEGMENTS,
1402: REVISION_NUMBER,
1403: START_DATE_ACTIVE,
1404: END_DATE_ACTIVE
1405: FROM AHL_OPERATIONS_B_KFV
1406: WHERE CONCATENATED_SEGMENTS=C_CONCATENATED_SEGMENTS
1407: AND REVISION_NUMBER=C_REVISION_NUMBER-1;
1408:
1409: l_oper_rec GetOperationDet%rowtype;

Line 1440: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;

1436: AHL_DEBUG_PUB.debug( 'Complete_mr_revision Status----->'||p_appr_status,'+DEBUG_RELATIONS+');
1437: END IF;
1438:
1439: SELECT REVISION_STATUS_CODE INTO l_curr_status
1440: FROM AHL_OPERATIONS_B_KFV WHERE OPERATION_ID=p_operation_id;
1441:
1442: IF p_appr_status='APPROVED'
1443: THEN
1444: l_status:='COMPLETE';

Line 1483: UPDATE AHL_OPERATIONS_B

1479:
1480: CLOSE GetOperationDet;
1481: IF l_check_flag='Y' and p_appr_status='REJECTED'
1482: THEN
1483: UPDATE AHL_OPERATIONS_B
1484: SET REVISION_STATUS_CODE=l_status,
1485: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1486: WHERE OPERATION_ID=P_OPERATION_ID;
1487: UPDATE AHL_OPERATIONS_TL

Line 1493: UPDATE AHL_OPERATIONS_B

1489: WHERE OPERATION_ID=P_OPERATION_ID;
1490: ELSIF l_check_flag='Y' and l_curr_status='TERMINATION_PENDING'
1491: and p_appr_status='APPROVED'
1492: THEN
1493: UPDATE AHL_OPERATIONS_B
1494: SET REVISION_STATUS_CODE='TERMINATED',
1495: -- START_DATE_ACTIVE=l_fr_date,
1496: END_DATE_ACTIVE=l_to_date,
1497: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1

Line 1527: UPDATE AHL_OPERATIONS_B

1523:
1524: ELSIF l_check_flag='Y' and l_oper_rec.revision_number=1
1525: and l_curr_status='APPROVAL_PENDING' and p_appr_status='APPROVED'
1526: THEN
1527: UPDATE AHL_OPERATIONS_B
1528: SET REVISION_STATUS_CODE=l_status,
1529: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1
1530: WHERE OPERATION_ID=P_OPERATION_ID;
1531:

Line 1553: UPDATE AHL_OPERATIONS_B

1549: CLOSE GetPrevOperDet;
1550:
1551: IF l_check_flag2='Y'
1552: THEN
1553: UPDATE AHL_OPERATIONS_B
1554: SET REVISION_STATUS_CODE=l_status,
1555: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER+1,
1556: START_DATE_ACTIVE=l_fr_date
1557: WHERE OPERATION_ID=P_OPERATION_ID;

Line 1560: UPDATE AHL_OPERATIONS_B

1556: START_DATE_ACTIVE=l_fr_date
1557: WHERE OPERATION_ID=P_OPERATION_ID;
1558: IF l_check_flag3='Y'
1559: THEN
1560: UPDATE AHL_OPERATIONS_B
1561: SET REVISION_STATUS_CODE=l_status,
1562: OBJECT_VERSION_NUMBER=OBJECT_VERSION_NUMBER+1,
1563: END_DATE_ACTIVE=l_to_date
1564: WHERE OPERATION_ID=l_prev_oper_rec.OPERATION_ID;