APPS.AHL_OPERATIONS_APPROVAL_PVT dependencies on AHL_OPERATIONS_B

Line 55: from ahl_OPERATIONS_b_KFV

51:
52: cursor GetOperationDet(c_OPERATION_ID number)
53: is
54: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
55: from ahl_OPERATIONS_b_KFV
56: where OPERATION_ID=c_OPERATION_ID;
57:
58: l_operation_rec GetOperationDet%rowtype;
59:

Line 265: from ahl_OPERATIONS_b_KFV

261:
262: cursor GetOperationDet(c_OPERATION_ID number)
263: is
264: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
265: from ahl_OPERATIONS_b_KFV
266: where OPERATION_ID=c_OPERATION_ID;
267:
268: l_operation_rec GetOperationDet%rowtype;
269: l_fullname VARCHAR2(100);

Line 384: from ahl_OPERATIONS_b_KFV

380:
381: cursor GetOperationDet(c_OPERATION_ID number)
382: is
383: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
384: from ahl_OPERATIONS_b_KFV
385: where OPERATION_ID=c_OPERATION_ID;
386:
387: l_operation_rec GetOperationDet%rowtype;
388: l_fullname VARCHAR2(100);

Line 502: from ahl_OPERATIONS_b_KFV

498:
499: cursor GetOperationDet(c_OPERATION_ID number)
500: is
501: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
502: from ahl_OPERATIONS_b_KFV
503: where OPERATION_ID=c_OPERATION_ID;
504:
505: l_operation_rec GetOperationDet%rowtype;
506: BEGIN

Line 609: from ahl_OPERATIONS_b_KFV

605: l_fullname VARCHAR2(100);
606: cursor GetOperationDet(c_OPERATION_ID number)
607: is
608: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
609: from ahl_OPERATIONS_b_KFV
610: where OPERATION_ID=c_OPERATION_ID;
611:
612: l_operation_rec GetOperationDet%rowtype;
613: BEGIN

Line 727: from ahl_OPERATIONS_b_KFV

723: l_error_msg VARCHAR2(2000);
724: cursor GetOperationDet(c_OPERATION_ID number)
725: is
726: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
727: from ahl_OPERATIONS_b_KFV
728: where OPERATION_ID=c_OPERATION_ID;
729:
730: l_operation_rec GetOperationDet%rowtype;
731: l_fullname VARCHAR2(100);

Line 855: from ahl_OPERATIONS_b_KFV

851:
852: cursor GetOperationDet(c_OPERATION_ID number)
853: is
854: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
855: from ahl_OPERATIONS_b_KFV
856: where OPERATION_ID=c_OPERATION_ID;
857: l_operation_rec GetOperationDet%rowtype;
858: BEGIN
859:

Line 980: from ahl_OPERATIONS_b_KFV

976:
977: cursor GetOperationDet(c_OPERATION_ID number)
978: is
979: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
980: from ahl_OPERATIONS_b_KFV
981: where OPERATION_ID=c_OPERATION_ID;
982:
983: l_operation_rec GetOperationDet%rowtype;
984: BEGIN

Line 1115: from ahl_OPERATIONS_b_KFV

1111:
1112: cursor GetOperationDet(c_OPERATION_ID number)
1113: is
1114: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
1115: from ahl_OPERATIONS_b_KFV
1116: where OPERATION_ID=c_OPERATION_ID;
1117:
1118:
1119: l_operation_rec GetOperationDet%rowtype;

Line 1283: from ahl_OPERATIONS_b_KFV

1279:
1280: cursor GetOperationDet(c_OPERATION_ID number)
1281: is
1282: select OPERATION_ID,CONCATENATED_SEGMENTS SEGMENT
1283: from ahl_OPERATIONS_b_KFV
1284: where OPERATION_ID=c_OPERATION_ID;
1285:
1286: l_operation_rec GetOperationDet%rowtype;
1287: l_return_status VARCHAR2(1);

Line 1316: UPDATE AHL_OPERATIONS_B

1312: );
1313:
1314: l_status_date := SYSDATE;
1315:
1316: UPDATE AHL_OPERATIONS_B
1317: SET REVISION_STATUS_CODE = 'DRAFT',
1318: object_version_number =l_object_version_number+1
1319: WHERE OPERATION_ID = l_object_id
1320: and object_Version_number=l_object_version_number;